{"topN":"20","maxLifetime":"10m0s","search.queryStats.lastQueriesCount":20000,"search.queryStats.minQueryDuration":"1ms","search.queryStats.minQueryMemoryUsage":"1024","topByCount":[{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"count":60},{"query":"node_memory_KernelStack_bytes +\nnode_memory_VmallocUsed_bytes +\nnode_memory_HardwareCorrupted_bytes +\nnode_memory_PageTables_bytes +\nnode_memory_Slab_bytes +\nnode_memory_PageTables_bytes\n","timeRangeSeconds":0,"count":60},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"count":60},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"count":60},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"count":60},{"query":"sum without (machine, release, version, sysname, domainname) (\n  label_replace(node_uname_info, \"id\", \"$1\", \"nodename\", \"(.+)\") OR\n  label_replace(node_uname_info, \"id\", \"$1\", \"instance\", \"(.+)\\\\:\\\\d+\") OR\n  label_replace(node_uname_info, \"id\", \"$1\", \"ins\", \"(.+)\")\n)\n","timeRangeSeconds":0,"count":60},{"query":"node_memory_MemTotal_bytes -\n(node_memory_KernelStack_bytes +\nnode_memory_VmallocUsed_bytes +\nnode_memory_HardwareCorrupted_bytes +\nnode_memory_PageTables_bytes +\nnode_memory_Slab_bytes +\nnode_memory_PageTables_bytes) - \nnode_memory_Buffers_bytes -\n(node_memory_Hugepagesize_bytes * node_memory_HugePages_Total) -\n(node_memory_Cached_bytes - node_memory_Mapped_bytes ) -\nnode_memory_MemFree_bytes\n","timeRangeSeconds":0,"count":60},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"count":60},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"count":60},{"query":"pg:db:ixact_time_rate1m / (pg:db:active_time_rate1m + pg:db:ixact_time_rate1m)","timeRangeSeconds":0,"count":51},{"query":"pg:db:ixact_time_rate15m / (pg:db:active_time_rate15m + pg:db:ixact_time_rate15m)","timeRangeSeconds":0,"count":50},{"query":"pg:db:ixact_time_rate5m / (pg:db:active_time_rate5m + pg:db:ixact_time_rate5m)","timeRangeSeconds":0,"count":49},{"query":"sum(patroni_failsafe_mode_is_active{}) > 0","timeRangeSeconds":0,"count":47},{"query":"node:dev:disk_mwrites_rate1m / (node:dev:disk_writes_rate1m + node:dev:disk_mwrites_rate1m)","timeRangeSeconds":0,"count":46},{"query":"sum by (job) (node:cls:cpu_usage * node:cls:cpu_count) / sum by (job) (node:cls:cpu_count)","timeRangeSeconds":0,"count":44},{"query":"node:dev:network_tx_bytes_rate1m + node:dev:network_rx_bytes_rate1m","timeRangeSeconds":0,"count":42},{"query":"node:dev:disk_mreads_rate1m / (node:dev:disk_reads_rate1m + node:dev:disk_mreads_rate1m)","timeRangeSeconds":0,"count":41},{"query":"node:dev:disk_reads_rate1m + node:dev:disk_writes_rate1m","timeRangeSeconds":0,"count":40},{"query":"1 - node:fs:avail_bytes / node:fs:size_bytes","timeRangeSeconds":0,"count":37},{"query":"sum without (mode) (pg_lock_count)","timeRangeSeconds":0,"count":36}],"topByAvgDuration":[{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"avgDurationSeconds":0.009,"count":60},{"query":"node_memory_MemTotal_bytes -\n(node_memory_KernelStack_bytes +\nnode_memory_VmallocUsed_bytes +\nnode_memory_HardwareCorrupted_bytes +\nnode_memory_PageTables_bytes +\nnode_memory_Slab_bytes +\nnode_memory_PageTables_bytes) - \nnode_memory_Buffers_bytes -\n(node_memory_Hugepagesize_bytes * node_memory_HugePages_Total) -\n(node_memory_Cached_bytes - node_memory_Mapped_bytes ) -\nnode_memory_MemFree_bytes\n","timeRangeSeconds":0,"avgDurationSeconds":0.007,"count":60},{"query":"node_filefd_allocated / node_filefd_maximum","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":2},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":60},{"query":"node_memory_KernelStack_bytes +\nnode_memory_VmallocUsed_bytes +\nnode_memory_HardwareCorrupted_bytes +\nnode_memory_PageTables_bytes +\nnode_memory_Slab_bytes +\nnode_memory_PageTables_bytes\n","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":60},{"query":"node:ins:stdload1 > 1","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":1},{"query":"max without (device, fstype, mountpoint) (node:fs:space_usage)","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":1},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":60},{"query":"infra_up \u003c 1","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":1},{"query":"sum by (cls, job) (node_load5) / node:cls:cpu_count","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":3},{"query":"rate(node_netstat_Tcp_PassiveOpens[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":1},{"query":"max without (instance) (pg:ins:load5 > ignoring(instance) pgbouncer:ins:load5 or pgbouncer:ins:load5)","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":6},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":60},{"query":"max without (instance) (pg:ins:load15 > ignoring(instance) pgbouncer:ins:load15 or pgbouncer:ins:load15)","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":2},{"query":"pg:ins:active_time_rate1m / pg:ins:cpu_count or (0 * pg_up - 1)","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":6},{"query":"rate(node_disk_reads_merged_total{device=~\"[a-z0-9A-Z-_]+\"}[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":1},{"query":"sum without(datname) (pg:db:xact_rollback_rate1m)","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":1},{"query":"sum without(datname) (pg:db:xact_commit_rate1m)","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":3},{"query":"rate(pg_db_active_time[5m])","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":2},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":60}],"topBySumDuration":[{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"sumDurationSeconds":0.524,"count":60},{"query":"node_memory_MemTotal_bytes -\n(node_memory_KernelStack_bytes +\nnode_memory_VmallocUsed_bytes +\nnode_memory_HardwareCorrupted_bytes +\nnode_memory_PageTables_bytes +\nnode_memory_Slab_bytes +\nnode_memory_PageTables_bytes) - \nnode_memory_Buffers_bytes -\n(node_memory_Hugepagesize_bytes * node_memory_HugePages_Total) -\n(node_memory_Cached_bytes - node_memory_Mapped_bytes ) -\nnode_memory_MemFree_bytes\n","timeRangeSeconds":0,"sumDurationSeconds":0.412,"count":60},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.212,"count":60},{"query":"node_memory_KernelStack_bytes +\nnode_memory_VmallocUsed_bytes +\nnode_memory_HardwareCorrupted_bytes +\nnode_memory_PageTables_bytes +\nnode_memory_Slab_bytes +\nnode_memory_PageTables_bytes\n","timeRangeSeconds":0,"sumDurationSeconds":0.208,"count":60},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"sumDurationSeconds":0.194,"count":60},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.169,"count":60},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"sumDurationSeconds":0.147,"count":60},{"query":"sum without (machine, release, version, sysname, domainname) (\n  label_replace(node_uname_info, \"id\", \"$1\", \"nodename\", \"(.+)\") OR\n  label_replace(node_uname_info, \"id\", \"$1\", \"instance\", \"(.+)\\\\:\\\\d+\") OR\n  label_replace(node_uname_info, \"id\", \"$1\", \"ins\", \"(.+)\")\n)\n","timeRangeSeconds":0,"sumDurationSeconds":0.137,"count":60},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.127,"count":60},{"query":"pg:db:ixact_time_rate1m / (pg:db:active_time_rate1m + pg:db:ixact_time_rate1m)","timeRangeSeconds":0,"sumDurationSeconds":0.079,"count":51},{"query":"sum(patroni_failsafe_mode_is_active{}) > 0","timeRangeSeconds":0,"sumDurationSeconds":0.076,"count":47},{"query":"pg:db:ixact_time_rate15m / (pg:db:active_time_rate15m + pg:db:ixact_time_rate15m)","timeRangeSeconds":0,"sumDurationSeconds":0.072,"count":50},{"query":"pg:db:ixact_time_rate5m / (pg:db:active_time_rate5m + pg:db:ixact_time_rate5m)","timeRangeSeconds":0,"sumDurationSeconds":0.072,"count":49},{"query":"sum by (job) (node:cls:cpu_usage * node:cls:cpu_count) / sum by (job) (node:cls:cpu_count)","timeRangeSeconds":0,"sumDurationSeconds":0.066,"count":44},{"query":"node:dev:disk_mwrites_rate1m / (node:dev:disk_writes_rate1m + node:dev:disk_mwrites_rate1m)","timeRangeSeconds":0,"sumDurationSeconds":0.063,"count":46},{"query":"node:dev:network_tx_bytes_rate1m + node:dev:network_rx_bytes_rate1m","timeRangeSeconds":0,"sumDurationSeconds":0.059,"count":42},{"query":"node:dev:disk_mreads_rate1m / (node:dev:disk_reads_rate1m + node:dev:disk_mreads_rate1m)","timeRangeSeconds":0,"sumDurationSeconds":0.058,"count":41},{"query":"node:dev:disk_reads_rate1m + node:dev:disk_writes_rate1m","timeRangeSeconds":0,"sumDurationSeconds":0.054,"count":40},{"query":"1 - node:fs:avail_bytes / node:fs:size_bytes","timeRangeSeconds":0,"sumDurationSeconds":0.053,"count":37},{"query":"sum without (datname) (pg_lock_count)","timeRangeSeconds":0,"sumDurationSeconds":0.050,"count":35}],"topByAvgMemoryUsage":[{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"avgMemoryBytes":212547,"count":60},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"avgMemoryBytes":212242,"count":60},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"avgMemoryBytes":191431,"count":60},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"avgMemoryBytes":113792,"count":60},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"avgMemoryBytes":113792,"count":60},{"query":"sum without (mode) (pg_lock_count)","timeRangeSeconds":0,"avgMemoryBytes":81280,"count":36},{"query":"sum without (datname) (pg_lock_count)","timeRangeSeconds":0,"avgMemoryBytes":81280,"count":35},{"query":"sum without (mode) (pg_lock_count{mode!~\"AccessShareLock|RowShareLock|RowExclusiveLock\"})","timeRangeSeconds":0,"avgMemoryBytes":50800,"count":11},{"query":"sum without(state) (pg_activity_count{state=~\"idle in.*\"})","timeRangeSeconds":0,"avgMemoryBytes":20320,"count":1},{"query":"sum without(mode) (pg:ins:locks)","timeRangeSeconds":0,"avgMemoryBytes":16256,"count":2},{"query":"sum by (job, cls, mode) (pg:ins:locks)","timeRangeSeconds":0,"avgMemoryBytes":16256,"count":3},{"query":"histogram_quantile(0.95, rate(etcd_disk_wal_fsync_duration_seconds_bucket{job=\"etcd\"}[5m]))","timeRangeSeconds":0,"avgMemoryBytes":15240,"count":2},{"query":"sum by (cls,proxy) (haproxy_server_status{state=\"UP\", proxy!=\u0027stats\u0027}) > bool 0","timeRangeSeconds":0,"avgMemoryBytes":14224,"count":2},{"query":"pg_size_bytes{datname!~\"wal|log\"}","timeRangeSeconds":0,"avgMemoryBytes":14224,"count":1},{"query":"rate(pg_db_blk_write_time[1m])","timeRangeSeconds":0,"avgMemoryBytes":14224,"count":2},{"query":"sum without(datname) (pg:db:xact_commit_rate1m)","timeRangeSeconds":0,"avgMemoryBytes":14224,"count":3},{"query":"rate(node_schedstat_timeslices_total[1m])","timeRangeSeconds":0,"avgMemoryBytes":14224,"count":2},{"query":"sum without (mode) (node:cpu:time_irate1m{mode=\"idle\"})","timeRangeSeconds":0,"avgMemoryBytes":14224,"count":17},{"query":"pg:db:ixact_time_rate15m / (pg:db:active_time_rate15m + pg:db:ixact_time_rate15m)","timeRangeSeconds":0,"avgMemoryBytes":14224,"count":50},{"query":"sum without(datname) (pg:db:xact_rollback_rate1m)","timeRangeSeconds":0,"avgMemoryBytes":14224,"count":1}]}