{"topN":"20","maxLifetime":"10m0s","search.queryStats.lastQueriesCount":20000,"search.queryStats.minQueryDuration":"1ms","search.queryStats.minQueryMemoryUsage":"1024","topByCount":[{"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":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"count":60},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"count":60},{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"count":60},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","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":51},{"query":"sum by (job) (node:cls:cpu_usage * node:cls:cpu_count) / sum by (job) (node:cls:cpu_count)","timeRangeSeconds":0,"count":25},{"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":14},{"query":"pg_up * 2 + (1 - pg_in_recovery)","timeRangeSeconds":0,"count":12},{"query":"avg_over_time(node:cpu:usage[1m])","timeRangeSeconds":0,"count":10},{"query":"sum by (cls, job) (node:ins:cpu_count)","timeRangeSeconds":0,"count":10},{"query":"node:dev:disk_mreads_rate1m / (node:dev:disk_reads_rate1m + node:dev:disk_mreads_rate1m)","timeRangeSeconds":0,"count":9},{"query":"group by (job, cls, ins, ip) (up{cls!=\"\", ins!=\"\", job=\u0027pgsql\u0027})","timeRangeSeconds":0,"count":9},{"query":"avg_over_time(node:cpu:usage[15m])","timeRangeSeconds":0,"count":9},{"query":"pgbouncer:db:waiting_clients > 1","timeRangeSeconds":0,"count":7},{"query":"avg_over_time(node:cpu:usage[5m])","timeRangeSeconds":0,"count":7},{"query":"pg:db:conn_usage > 0.70","timeRangeSeconds":0,"count":7},{"query":"sum without (mode) (pg_lock_count)","timeRangeSeconds":0,"count":7},{"query":"1 - pg_in_recovery","timeRangeSeconds":0,"count":7}],"topByAvgDuration":[{"query":"avg_over_time(node:env:cpu_usage[5m])","timeRangeSeconds":0,"avgDurationSeconds":0.006,"count":1},{"query":"max without (instance) (pg:ins:load1 > ignoring(instance) pgbouncer:ins:load1 or pgbouncer:ins:load1)","timeRangeSeconds":0,"avgDurationSeconds":0.006,"count":1},{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"avgDurationSeconds":0.005,"count":60},{"query":"max without (instance) (pg:ins:load5 > ignoring(instance) pgbouncer:ins:load5 or pgbouncer:ins:load5)","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":2},{"query":"sum by (job) (pg:cls:tup_deleted_rate1m)","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":1},{"query":"node:ins:fd_usage > 0.90","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":1},{"query":"sum by (job) (pg:cls:xact_total_rate1m)","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":1},{"query":"pgbouncer_pool_maxwait{datname!=\"pgbouncer\"} + pgbouncer_pool_maxwait_us{datname!=\"pgbouncer\"} / 1000000","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":1},{"query":"sum by (cls, job) (node:ins:disk_write_bytes_rate1m)","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":1},{"query":"node:ins:disk_read_bytes_rate1m + node:ins:disk_write_bytes_rate1m","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":3},{"query":"rate(node_disk_io_time_seconds_total{device=~\"[a-z0-9A-Z-_]+\"}[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":1},{"query":"node:cls:disk_reads_rate1m + node:cls:disk_writes_rate1m","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":1},{"query":"sum without(datname) (pg:db:wlock_count)","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":1},{"query":"node:dev:disk_write_bytes_rate1m / node:dev:disk_writes_rate1m","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":1},{"query":"rate(node_disk_read_time_seconds_total{device=~\"[a-z0-9A-Z-_]+\"}[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":1},{"query":"rate(node_network_transmit_packets_total[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":2},{"query":"sum by (job, cls) (pg:ins:xact_total_rate1m)","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":1},{"query":"rate(node_vmstat_pswpout[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":1},{"query":"rate(node_netstat_TcpExt_ListenDrops[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":2},{"query":"rate(node_filefd_allocated[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":1}],"topBySumDuration":[{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"sumDurationSeconds":0.286,"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.162,"count":60},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.143,"count":60},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.107,"count":60},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"sumDurationSeconds":0.103,"count":60},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"sumDurationSeconds":0.094,"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.065,"count":51},{"query":"sum by (job) (node:cls:cpu_usage * node:cls:cpu_count) / sum by (job) (node:cls:cpu_count)","timeRangeSeconds":0,"sumDurationSeconds":0.033,"count":25},{"query":"pg_up * 2 + (1 - pg_in_recovery)","timeRangeSeconds":0,"sumDurationSeconds":0.028,"count":12},{"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.027,"count":14},{"query":"group by (job, cls, ins, ip) (up{cls!=\"\", ins!=\"\", job=\u0027pgsql\u0027})","timeRangeSeconds":0,"sumDurationSeconds":0.018,"count":9},{"query":"avg_over_time(node:cpu:usage[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.017,"count":10},{"query":"avg_over_time(node:cpu:usage[15m])","timeRangeSeconds":0,"sumDurationSeconds":0.016,"count":9},{"query":"avg_over_time(node:cpu:usage[5m])","timeRangeSeconds":0,"sumDurationSeconds":0.016,"count":7},{"query":"sum by (cls, job) (node:ins:cpu_count)","timeRangeSeconds":0,"sumDurationSeconds":0.015,"count":10},{"query":"pg:db:conn_usage > 0.70","timeRangeSeconds":0,"sumDurationSeconds":0.014,"count":7},{"query":"pgbouncer:db:waiting_clients > 1","timeRangeSeconds":0,"sumDurationSeconds":0.013,"count":7},{"query":"rate(pg_db_xact_commit[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.013,"count":4},{"query":"max by (job, cls, ins, ip, appname, usename, address, pid) (pg_repl_sync_state)","timeRangeSeconds":0,"sumDurationSeconds":0.012,"count":4},{"query":"sum without (mode) (pg_lock_count)","timeRangeSeconds":0,"sumDurationSeconds":0.012,"count":7}],"topByAvgMemoryUsage":[{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"avgMemoryBytes":390144,"count":60},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"avgMemoryBytes":390144,"count":60},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"avgMemoryBytes":195072,"count":60},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"avgMemoryBytes":195072,"count":60},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"avgMemoryBytes":115824,"count":2},{"query":"sum without (mode) (pg_lock_count)","timeRangeSeconds":0,"avgMemoryBytes":48768,"count":7},{"query":"sum without (datname) (pg_lock_count)","timeRangeSeconds":0,"avgMemoryBytes":48768,"count":6},{"query":"rate(node_schedstat_waiting_seconds_total[1m])","timeRangeSeconds":0,"avgMemoryBytes":24384,"count":4},{"query":"avg without (cpu) (node:cpu:sched_wait_rate1m)","timeRangeSeconds":0,"avgMemoryBytes":24384,"count":2},{"query":"sum without (mode) (node:cpu:time_irate1m{mode=\"idle\"})","timeRangeSeconds":0,"avgMemoryBytes":24384,"count":6},{"query":"avg_over_time(node:cpu:usage[15m])","timeRangeSeconds":0,"avgMemoryBytes":24384,"count":9},{"query":"rate(node_schedstat_timeslices_total[1m])","timeRangeSeconds":0,"avgMemoryBytes":24384,"count":3},{"query":"avg_over_time(node:cpu:usage[5m])","timeRangeSeconds":0,"avgMemoryBytes":24384,"count":7},{"query":"avg by (cls, job) (node:cpu:usage)","timeRangeSeconds":0,"avgMemoryBytes":24384,"count":1},{"query":"count without (cpu) (node:cpu:usage)","timeRangeSeconds":0,"avgMemoryBytes":24384,"count":6},{"query":"sum by (job, cls, mode) (pg:ins:locks)","timeRangeSeconds":0,"avgMemoryBytes":24384,"count":5},{"query":"avg_over_time(node:cpu:usage[1m])","timeRangeSeconds":0,"avgMemoryBytes":24384,"count":10},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"avgMemoryBytes":24384,"count":60},{"query":"rate(node_disk_written_bytes_total{device=~\"[a-z0-9A-Z-_]+\"}[1m])","timeRangeSeconds":0,"avgMemoryBytes":22352,"count":3},{"query":"rate(node_disk_writes_merged_total{device=~\"[a-z0-9A-Z-_]+\"}[1m])","timeRangeSeconds":0,"avgMemoryBytes":22352,"count":1}]}