{"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":52},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"count":47},{"query":"sum by (job) (node:cls:cpu_usage * node:cls:cpu_count) / sum by (job) (node:cls:cpu_count)","timeRangeSeconds":0,"count":24},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"count":23},{"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":18},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"count":10},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"count":9},{"query":"sum without (partition) (rate(kafka_topic_partition_current_offset{}[1m]))","timeRangeSeconds":0,"count":8},{"query":"sum(kafka:topic:msg_rate1m) without (topic)","timeRangeSeconds":0,"count":7},{"query":"pg:ins:lag_bytes > 1048576 or pg:ins:lag_seconds > 1","timeRangeSeconds":0,"count":6},{"query":"up{instance=~\".*:9100\"}","timeRangeSeconds":0,"count":6},{"query":"pg:db:conn_usage > 0.70","timeRangeSeconds":0,"count":3},{"query":"redis:ins:cmd_time / redis:ins:cmd_qps","timeRangeSeconds":0,"count":3},{"query":"sum without (cmd) (redis:ins:cmd_time) / sum without (cmd) (redis:ins:cmd_qps)","timeRangeSeconds":0,"count":3},{"query":"sum(patroni_failsafe_mode_is_active{}) > 0","timeRangeSeconds":0,"count":3},{"query":"node:ins:disk_mreads_rate1m / (node:ins:disk_reads_rate1m + node:ins:disk_mreads_rate1m)","timeRangeSeconds":0,"count":2},{"query":"count by (job, cls, ins) (up{cls!=\"\", ins!=\"\", job=\u0027pgsql\u0027})","timeRangeSeconds":0,"count":2},{"query":"node:ins:cpu_usage_1m + on(ip) group_right() pg_up * 0","timeRangeSeconds":0,"count":2}],"topByAvgDuration":[{"query":"avg_over_time(haproxy:cls:service_up{cls=\"pg-meta\", proxy=\"pg-meta-default\"}[30d])","timeRangeSeconds":0,"avgDurationSeconds":0.033,"count":1},{"query":"pg_up * 2 + (1 - pg_in_recovery)","timeRangeSeconds":0,"avgDurationSeconds":0.018,"count":1},{"query":"count(sum by (ins)(haproxy_server_current_sessions{proxy=\"pg-meta-default\"}))","timeRangeSeconds":3600,"avgDurationSeconds":0.012,"count":1},{"query":"sum(haproxy_server_current_sessions{proxy=\"pg-meta-default\"})","timeRangeSeconds":3600,"avgDurationSeconds":0.011,"count":1},{"query":"count(sum by (server) (haproxy_server_current_sessions{proxy=\"pg-meta-default\"}))","timeRangeSeconds":3600,"avgDurationSeconds":0.010,"count":1},{"query":"docker_up \u003c 1","timeRangeSeconds":0,"avgDurationSeconds":0.007,"count":1},{"query":"sum by (cls, job) (node_load5) / node:cls:cpu_count","timeRangeSeconds":0,"avgDurationSeconds":0.007,"count":1},{"query":"node:ins:cpu_usage_1m > 0.70","timeRangeSeconds":0,"avgDurationSeconds":0.007,"count":1},{"query":"max by (datname) (1 - pg_db_is_template{ins=\"pg-meta-1\"} + pg_db_allow_conn{ins=\"pg-meta-1\"} * 2)","timeRangeSeconds":0,"avgDurationSeconds":0.005,"count":1},{"query":"node:ins:disk_mwrites_rate1m / (node:ins:disk_writes_rate1m + node:ins:disk_mwrites_rate1m)","timeRangeSeconds":0,"avgDurationSeconds":0.005,"count":1},{"query":"sum by (job) (node_memory_MemAvailable_bytes)","timeRangeSeconds":0,"avgDurationSeconds":0.005,"count":1},{"query":"pgbouncer_database_pool_size{datname!=\"pgbouncer\"} + pgbouncer_database_reserve_pool{datname!=\"pgbouncer\"}","timeRangeSeconds":0,"avgDurationSeconds":0.005,"count":1},{"query":"max by (datname) (pg_db_datid{ins=\"pg-meta-1\"})","timeRangeSeconds":0,"avgDurationSeconds":0.005,"count":1},{"query":"count without (cpu) (node:cpu:usage)","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":1},{"query":"redis:ins:rx + redis:ins:tx","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":1},{"query":"pg:cls:partition != 1","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":1},{"query":"sum by (job) (node:cls:stdload15) / node:env:cpu_count","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":1},{"query":"(pg_db_conn_limit != -1 ) or (0 * pg_db_conn_limit + on(cls, ins) group_left pg_setting_max_connections)","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":1},{"query":"up{instance=~\".*:9100\"}","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":6},{"query":"sum by (job, cls) (pg:ins:xact_rollback_rate15m)","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.160,"count":60},{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"sumDurationSeconds":0.155,"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.068,"count":52},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"sumDurationSeconds":0.060,"count":47},{"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.048,"count":18},{"query":"sum by (job) (node:cls:cpu_usage * node:cls:cpu_count) / sum by (job) (node:cls:cpu_count)","timeRangeSeconds":0,"sumDurationSeconds":0.040,"count":24},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.035,"count":23},{"query":"avg_over_time(haproxy:cls:service_up{cls=\"pg-meta\", proxy=\"pg-meta-default\"}[30d])","timeRangeSeconds":0,"sumDurationSeconds":0.033,"count":1},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"sumDurationSeconds":0.025,"count":10},{"query":"up{instance=~\".*:9100\"}","timeRangeSeconds":0,"sumDurationSeconds":0.021,"count":6},{"query":"sum(kafka:topic:msg_rate1m) without (topic)","timeRangeSeconds":0,"sumDurationSeconds":0.018,"count":7},{"query":"pg_up * 2 + (1 - pg_in_recovery)","timeRangeSeconds":0,"sumDurationSeconds":0.018,"count":1},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.017,"count":9},{"query":"sum without (partition) (rate(kafka_topic_partition_current_offset{}[1m]))","timeRangeSeconds":0,"sumDurationSeconds":0.016,"count":8},{"query":"pg:ins:lag_bytes > 1048576 or pg:ins:lag_seconds > 1","timeRangeSeconds":0,"sumDurationSeconds":0.016,"count":6},{"query":"count(sum by (ins)(haproxy_server_current_sessions{proxy=\"pg-meta-default\"}))","timeRangeSeconds":3600,"sumDurationSeconds":0.012,"count":1},{"query":"sum(haproxy_server_current_sessions{proxy=\"pg-meta-default\"})","timeRangeSeconds":3600,"sumDurationSeconds":0.011,"count":1},{"query":"count(sum by (server) (haproxy_server_current_sessions{proxy=\"pg-meta-default\"}))","timeRangeSeconds":3600,"sumDurationSeconds":0.010,"count":1},{"query":"sum(patroni_failsafe_mode_is_active{}) > 0","timeRangeSeconds":0,"sumDurationSeconds":0.008,"count":3},{"query":"docker_up \u003c 1","timeRangeSeconds":0,"sumDurationSeconds":0.007,"count":1}]}