{"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":39},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"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,"count":28},{"query":"sum without (partition) (rate(kafka_topic_partition_current_offset{}[1m]))","timeRangeSeconds":0,"count":15},{"query":"sum by (job) (node:cls:cpu_usage * node:cls:cpu_count) / sum by (job) (node:cls:cpu_count)","timeRangeSeconds":0,"count":14},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"count":12},{"query":"pgbouncer_exporter_agent_up \u003c 1","timeRangeSeconds":0,"count":7},{"query":"pg:ins:lag_bytes > 1048576 or pg:ins:lag_seconds > 1","timeRangeSeconds":0,"count":6},{"query":"patroni_up \u003c 1","timeRangeSeconds":0,"count":6},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"count":6},{"query":"pg:db:age > 0.80","timeRangeSeconds":0,"count":5},{"query":"sum(kafka:topic:msg_rate1m) without (topic)","timeRangeSeconds":0,"count":5},{"query":"up{instance=~\".*:9100\"}","timeRangeSeconds":0,"count":5},{"query":"sum without (datname) (pg:db:blks_hit_1m) / sum without (datname) (pg:db:blks_access_1m)","timeRangeSeconds":0,"count":5},{"query":"sum(kafka:topic:msg_rate5m) without (topic)","timeRangeSeconds":0,"count":4},{"query":"ins:pressure1 > 0.70","timeRangeSeconds":0,"count":4},{"query":"sum(patroni_failsafe_mode_is_active{}) > 0","timeRangeSeconds":0,"count":4}],"topByAvgDuration":[{"query":"redis:ins:key_hit / (redis:ins:key_hit + redis:ins:key_miss)","timeRangeSeconds":0,"avgDurationSeconds":0.012,"count":1},{"query":"deriv(node:fs:avail_bytes[1h])","timeRangeSeconds":0,"avgDurationSeconds":0.010,"count":1},{"query":"sum by (job, cls) (pg:ins:cpu_usage_15m * pg:ins:cpu_count) / pg:cls:cpu_count","timeRangeSeconds":0,"avgDurationSeconds":0.007,"count":3},{"query":"sum by (job, cls) (pg:ins:cpu_usage_5m * pg:ins:cpu_count) / pg:cls:cpu_count","timeRangeSeconds":0,"avgDurationSeconds":0.007,"count":2},{"query":"promtail_up \u003c 1","timeRangeSeconds":0,"avgDurationSeconds":0.005,"count":1},{"query":"sum by (job)(redis:cls:mem_used) / sum by (job)(redis:cls:mem_max)","timeRangeSeconds":0,"avgDurationSeconds":0.005,"count":2},{"query":"max by ( job, cls, ip, appname, sender_host, sender_port, slot_name, state ) (\n  label_replace(pg_recv_flush_tli, \"appname\" , \"$1\",  \"ins\", \"(.*)\" )\n)\n","timeRangeSeconds":0,"avgDurationSeconds":0.005,"count":1},{"query":"node_up \u003c 1","timeRangeSeconds":0,"avgDurationSeconds":0.005,"count":1},{"query":"pgbouncer_exporter_agent_up \u003c 1","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":7},{"query":"avg_over_time(node:ins:cpu_usage[5m])","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":2},{"query":"sum(rate(pg_db_tup_inserted{ins=\"pg-meta-1\"}[1m]))","timeRangeSeconds":3600,"avgDurationSeconds":0.004,"count":1},{"query":"1 - node:cls:avail_bytes / node:cls:size_bytes","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":1},{"query":"sum by (relname) (pg_table_size_bytes{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":1},{"query":"sum(kafka:topic:msg_rate5m) by (job,cls)","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":1},{"query":"rate(node_filefd_allocated[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":1},{"query":"redis:env:cmd_time / redis:env:cmd_qps","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":2},{"query":"sum by (job) (pg:cls:cpu_usage_5m * pg:cls:cpu_count) / pg:env:cpu_count","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":2},{"query":"sum by (ins) (pg_activity_count{cls=\"pg-meta\"})","timeRangeSeconds":3600,"avgDurationSeconds":0.004,"count":1},{"query":"pgbouncer:db:pool_current_conn / pgbouncer:db:pool_size","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":1},{"query":"sum by (job) (pg:cls:tup_modified_rate1m)","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.157,"count":60},{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"sumDurationSeconds":0.148,"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.073,"count":58},{"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.056,"count":28},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"sumDurationSeconds":0.054,"count":39},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.049,"count":32},{"query":"sum without (partition) (rate(kafka_topic_partition_current_offset{}[1m]))","timeRangeSeconds":0,"sumDurationSeconds":0.046,"count":15},{"query":"pgbouncer_exporter_agent_up \u003c 1","timeRangeSeconds":0,"sumDurationSeconds":0.031,"count":7},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.029,"count":12},{"query":"sum by (job, cls) (pg:ins:cpu_usage_15m * pg:ins:cpu_count) / pg:cls:cpu_count","timeRangeSeconds":0,"sumDurationSeconds":0.022,"count":3},{"query":"sum by (job) (node:cls:cpu_usage * node:cls:cpu_count) / sum by (job) (node:cls:cpu_count)","timeRangeSeconds":0,"sumDurationSeconds":0.020,"count":14},{"query":"pg:ins:lag_bytes > 1048576 or pg:ins:lag_seconds > 1","timeRangeSeconds":0,"sumDurationSeconds":0.017,"count":6},{"query":"pg:db:age > 0.80","timeRangeSeconds":0,"sumDurationSeconds":0.015,"count":5},{"query":"patroni_up \u003c 1","timeRangeSeconds":0,"sumDurationSeconds":0.014,"count":6},{"query":"pg_uptime \u003c 300","timeRangeSeconds":0,"sumDurationSeconds":0.014,"count":4},{"query":"sum by (job, cls) (pg:ins:cpu_usage_5m * pg:ins:cpu_count) / pg:cls:cpu_count","timeRangeSeconds":0,"sumDurationSeconds":0.013,"count":2},{"query":"redis:ins:key_hit / (redis:ins:key_hit + redis:ins:key_miss)","timeRangeSeconds":0,"sumDurationSeconds":0.012,"count":1},{"query":"sum(kafka:topic:msg_rate5m) without (topic)","timeRangeSeconds":0,"sumDurationSeconds":0.012,"count":4},{"query":"sum(kafka:topic:msg_rate1m) without (topic)","timeRangeSeconds":0,"sumDurationSeconds":0.011,"count":5},{"query":"deriv(node:fs:avail_bytes[1h])","timeRangeSeconds":0,"sumDurationSeconds":0.010,"count":1}]}