{"topN":"20","maxLifetime":"10m0s","search.queryStats.lastQueriesCount":20000,"search.queryStats.minQueryDuration":"1ms","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":"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":58},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"count":32},{"query":"sum by (job) (node:cls:cpu_usage * node:cls:cpu_count) / sum by (job) (node:cls:cpu_count)","timeRangeSeconds":0,"count":15},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"count":15},{"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":15},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"count":8},{"query":"up{instance=~\".*:9100\"}","timeRangeSeconds":0,"count":8},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"count":6},{"query":"pg:db:blk_read_time_seconds_rate1m + pg:db:blk_write_time_seconds_rate1m","timeRangeSeconds":0,"count":4},{"query":"pgbouncer_up \u003c 1","timeRangeSeconds":0,"count":4},{"query":"redis:ins:cmd_time / redis:ins:cmd_qps","timeRangeSeconds":0,"count":4},{"query":"node:ins:cpu_count + on(ip) group_right() pg_up * 0","timeRangeSeconds":0,"count":4},{"query":"sum without (cmd) (redis:ins:cmd_time) / sum without (cmd) (redis:ins:cmd_qps)","timeRangeSeconds":0,"count":3},{"query":"sum(kafka:topic:msg_rate1m) without (topic)","timeRangeSeconds":0,"count":3},{"query":"time() - node_boot_time_seconds","timeRangeSeconds":0,"count":3},{"query":"redis:cls:cmd_time / redis:cls:cmd_qps","timeRangeSeconds":0,"count":3},{"query":"pg:db:blks_hit_1m / pg:db:blks_access_1m","timeRangeSeconds":0,"count":3},{"query":"redis:env:cmd_time / redis:env:cmd_qps","timeRangeSeconds":0,"count":3}],"topByAvgDuration":[{"query":"sum(pg:ins:mem_size{job=\"pgsql\"})","timeRangeSeconds":0,"avgDurationSeconds":0.014,"count":1},{"query":"count(count by (cls) (pg_up{job=\"pgsql\"}))","timeRangeSeconds":0,"avgDurationSeconds":0.009,"count":1},{"query":"sum(max by (cls,datname)(pg_size_bytes{datname!~\"log|wal\", job=\"pgsql\"}))","timeRangeSeconds":0,"avgDurationSeconds":0.008,"count":1},{"query":"count(count(pg_up{job=\"pgsql\"}) by (ip))","timeRangeSeconds":0,"avgDurationSeconds":0.007,"count":1},{"query":"count(max by (cls,datname) (pg_db_age{job=\"pgsql\", datname!~\u0027template0|template1|postgres\u0027}))","timeRangeSeconds":0,"avgDurationSeconds":0.007,"count":1},{"query":"count(pg_up{job=\"pgsql\"})","timeRangeSeconds":0,"avgDurationSeconds":0.006,"count":1},{"query":"up{job=\"minio\"}","timeRangeSeconds":0,"avgDurationSeconds":0.005,"count":1},{"query":"sum(pg:cls:cpu_count{job=\"pgsql\"})","timeRangeSeconds":0,"avgDurationSeconds":0.005,"count":1},{"query":"ins:pressure1 > 0.70","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":1},{"query":"pg:env:cpu_usage{job=\"pgsql\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.004,"count":1},{"query":"sum by (job) (pg:cls:tup_returned_rate1m)","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":1},{"query":"sum by (job, cls) (group by (job, cls, ins, ip) (up{cls!=\"\", ins!=\"\", job=\u0027pgsql\u0027}))","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":1},{"query":"pgbouncer_exporter_agent_up \u003c 1","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":1},{"query":"pg:db:blk_read_time_seconds_rate1m + pg:db:blk_write_time_seconds_rate1m","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":4},{"query":"patroni_up \u003c 1","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":2},{"query":"increase(pg_db_blks_hit[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":2},{"query":"max by (job,cls) (etcd_mvcc_db_total_size_in_bytes{job=\"etcd\"} / etcd_server_quota_backend_bytes{job=\"etcd\"})","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":2},{"query":"sum without (mode) (node:cpu:time_irate1m{mode=\"idle\"})","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":1},{"query":"pgbouncer_database_disabled{datname!=\"pgbouncer\"}","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":1},{"query":"sum by (job, cls) (pg:ins:cpu_usage * pg:ins:cpu_count) / pg:cls:cpu_count","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":1}],"topBySumDuration":[{"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.158,"count":60},{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"sumDurationSeconds":0.129,"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.079,"count":58},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"sumDurationSeconds":0.042,"count":32},{"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.025,"count":15},{"query":"sum by (job) (node:cls:cpu_usage * node:cls:cpu_count) / sum by (job) (node:cls:cpu_count)","timeRangeSeconds":0,"sumDurationSeconds":0.025,"count":15},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.021,"count":15},{"query":"pg:db:blk_read_time_seconds_rate1m + pg:db:blk_write_time_seconds_rate1m","timeRangeSeconds":0,"sumDurationSeconds":0.016,"count":4},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.016,"count":8},{"query":"sum(pg:ins:mem_size{job=\"pgsql\"})","timeRangeSeconds":0,"sumDurationSeconds":0.014,"count":1},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"sumDurationSeconds":0.014,"count":6},{"query":"up{instance=~\".*:9100\"}","timeRangeSeconds":0,"sumDurationSeconds":0.013,"count":8},{"query":"sum by (job) (pg:cls:cpu_usage * pg:cls:cpu_count) / pg:env:cpu_count","timeRangeSeconds":0,"sumDurationSeconds":0.009,"count":3},{"query":"count(count by (cls) (pg_up{job=\"pgsql\"}))","timeRangeSeconds":0,"sumDurationSeconds":0.009,"count":1},{"query":"sum(kafka:topic:msg_rate1m) without (topic)","timeRangeSeconds":0,"sumDurationSeconds":0.008,"count":3},{"query":"node:ins:cpu_count + on(ip) group_right() pg_up * 0","timeRangeSeconds":0,"sumDurationSeconds":0.008,"count":4},{"query":"patroni_up \u003c 1","timeRangeSeconds":0,"sumDurationSeconds":0.008,"count":2},{"query":"sum(max by (cls,datname)(pg_size_bytes{datname!~\"log|wal\", job=\"pgsql\"}))","timeRangeSeconds":0,"sumDurationSeconds":0.008,"count":1},{"query":"pgbouncer_up \u003c 1","timeRangeSeconds":0,"sumDurationSeconds":0.008,"count":4},{"query":"increase(pg_db_blks_hit[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.007,"count":2}]}