{"topN":"20","maxLifetime":"10m0s","search.queryStats.lastQueriesCount":20000,"search.queryStats.minQueryDuration":"1ms","topByCount":[{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","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":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"count":59},{"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":59},{"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":57},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"count":56},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"count":41},{"query":"sum by (job) (node:cls:cpu_usage * node:cls:cpu_count) / sum by (job) (node:cls:cpu_count)","timeRangeSeconds":0,"count":40},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"count":40},{"query":"redis:ins:cmd_time / redis:ins:cmd_qps","timeRangeSeconds":0,"count":33},{"query":"sum without (cmd) (redis:ins:cmd_time) / sum without (cmd) (redis:ins:cmd_qps)","timeRangeSeconds":0,"count":32},{"query":"max by (id, ins, instance, cls, job) (\n  label_replace(redis_up, \"id\", \"$1\", \"ins\", \"(.+)\") OR\n  label_replace(redis_up, \"id\", \"$1\", \"instance\", \"(.+)\")\n)\n","timeRangeSeconds":0,"count":30},{"query":"(pg_db_conn_limit != -1 ) or (0 * pg_db_conn_limit + on(cls, ins) group_left pg_setting_max_connections)","timeRangeSeconds":0,"count":28},{"query":"pg:db:ixact_time_rate5m / (pg:db:active_time_rate5m + pg:db:ixact_time_rate5m)","timeRangeSeconds":0,"count":26},{"query":"pg:db:ixact_time_rate15m / (pg:db:active_time_rate15m + pg:db:ixact_time_rate15m)","timeRangeSeconds":0,"count":20},{"query":"time() - node_boot_time_seconds","timeRangeSeconds":0,"count":19},{"query":"sum(patroni_failsafe_mode_is_active{}) > 0","timeRangeSeconds":0,"count":18},{"query":"sum by (job, cls) (pg:ins:cpu_usage * pg:ins:cpu_count) / pg:cls:cpu_count","timeRangeSeconds":0,"count":17},{"query":"pg:db:ixact_time_rate1m / (pg:db:active_time_rate1m + pg:db:ixact_time_rate1m)","timeRangeSeconds":0,"count":17},{"query":"pgbouncer_database_pool_size{datname!=\"pgbouncer\"} + pgbouncer_database_reserve_pool{datname!=\"pgbouncer\"}","timeRangeSeconds":0,"count":17}],"topByAvgDuration":[{"query":"sum by (job, cls) (pg:ins:session_time_rate1m)","timeRangeSeconds":0,"avgDurationSeconds":0.017,"count":2},{"query":"pgbouncer:ins:query_time_rate1m / on(ins) group_left pg:ins:cpu_count or (0 * pgbouncer_up - 1)","timeRangeSeconds":0,"avgDurationSeconds":0.014,"count":1},{"query":"sum by (job) (redis:cls:rx)","timeRangeSeconds":0,"avgDurationSeconds":0.014,"count":1},{"query":"sum without (datname) (pg_lock_count)","timeRangeSeconds":0,"avgDurationSeconds":0.013,"count":1},{"query":"sum by (job) (pg:cls:ixact_backends)","timeRangeSeconds":0,"avgDurationSeconds":0.011,"count":2},{"query":"sum by (job) (pg:cls:active_backends)","timeRangeSeconds":0,"avgDurationSeconds":0.010,"count":2},{"query":"sum without(datname) (pg:db:session_time_rate1m)","timeRangeSeconds":0,"avgDurationSeconds":0.010,"count":2},{"query":"sum without(datname) (pg:db:ixact_time_rate1m)","timeRangeSeconds":0,"avgDurationSeconds":0.009,"count":5},{"query":"sum by (job) (pg:cls:session_time_rate1m)","timeRangeSeconds":0,"avgDurationSeconds":0.008,"count":2},{"query":"sum by (job,cls,ip) (label_replace(redis_memory_used_bytes, \"ip\", \"$1\", \"instance\", \"(.*)\\\\:\\\\d+\"))","timeRangeSeconds":0,"avgDurationSeconds":0.008,"count":1},{"query":"predict_linear(node:fs:avail_bytes[1h], 86400)","timeRangeSeconds":0,"avgDurationSeconds":0.008,"count":2},{"query":"pg:ins:ixact_time_rate15m / (pg:ins:active_time_rate15m + pg:ins:ixact_time_rate15m)","timeRangeSeconds":0,"avgDurationSeconds":0.008,"count":5},{"query":"node:cls:disk_read_bytes_rate1m + node:cls:disk_write_bytes_rate1m","timeRangeSeconds":0,"avgDurationSeconds":0.007,"count":2},{"query":"time() - haproxy_process_start_time_seconds","timeRangeSeconds":0,"avgDurationSeconds":0.007,"count":2},{"query":"avg_over_time(node:env:cpu_usage[5m])","timeRangeSeconds":0,"avgDurationSeconds":0.007,"count":2},{"query":"node:ins:network_tx_bytes_rate1m + node:ins:network_rx_bytes_rate1m","timeRangeSeconds":0,"avgDurationSeconds":0.007,"count":2},{"query":"pg_setting_max_connections","timeRangeSeconds":0,"avgDurationSeconds":0.007,"count":2},{"query":"sum without(datname) (pg:db:ixact_time_rate15m)","timeRangeSeconds":0,"avgDurationSeconds":0.006,"count":4},{"query":"promtail_up \u003c 1","timeRangeSeconds":0,"avgDurationSeconds":0.006,"count":3},{"query":"sum by (job) (pg:cls:xact_total_rate15m)","timeRangeSeconds":0,"avgDurationSeconds":0.006,"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.313,"count":60},{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"sumDurationSeconds":0.304,"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.263,"count":57},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"sumDurationSeconds":0.172,"count":56},{"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.152,"count":59},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.136,"count":59},{"query":"(pg_db_conn_limit != -1 ) or (0 * pg_db_conn_limit + on(cls, ins) group_left pg_setting_max_connections)","timeRangeSeconds":0,"sumDurationSeconds":0.134,"count":28},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.111,"count":40},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"sumDurationSeconds":0.107,"count":41},{"query":"sum by (job) (node:cls:cpu_usage * node:cls:cpu_count) / sum by (job) (node:cls:cpu_count)","timeRangeSeconds":0,"sumDurationSeconds":0.085,"count":40},{"query":"time() - node_boot_time_seconds","timeRangeSeconds":0,"sumDurationSeconds":0.084,"count":19},{"query":"max by (id, ins, instance, cls, job) (\n  label_replace(redis_up, \"id\", \"$1\", \"ins\", \"(.+)\") OR\n  label_replace(redis_up, \"id\", \"$1\", \"instance\", \"(.+)\")\n)\n","timeRangeSeconds":0,"sumDurationSeconds":0.077,"count":30},{"query":"redis:ins:cmd_time / redis:ins:cmd_qps","timeRangeSeconds":0,"sumDurationSeconds":0.064,"count":33},{"query":"sum without (cmd) (redis:ins:cmd_time) / sum without (cmd) (redis:ins:cmd_qps)","timeRangeSeconds":0,"sumDurationSeconds":0.055,"count":32},{"query":"pg:db:ixact_time_rate1m / (pg:db:active_time_rate1m + pg:db:ixact_time_rate1m)","timeRangeSeconds":0,"sumDurationSeconds":0.053,"count":17},{"query":"pg:db:ixact_time_rate5m / (pg:db:active_time_rate5m + pg:db:ixact_time_rate5m)","timeRangeSeconds":0,"sumDurationSeconds":0.048,"count":26},{"query":"sum by (cls, job) (node:ins:cpu_count)","timeRangeSeconds":0,"sumDurationSeconds":0.047,"count":8},{"query":"sum without(datname) (pg:db:ixact_time_rate1m)","timeRangeSeconds":0,"sumDurationSeconds":0.045,"count":5},{"query":"pg:db:ixact_time_rate15m / (pg:db:active_time_rate15m + pg:db:ixact_time_rate15m)","timeRangeSeconds":0,"sumDurationSeconds":0.043,"count":20},{"query":"sum(patroni_failsafe_mode_is_active{}) > 0","timeRangeSeconds":0,"sumDurationSeconds":0.043,"count":18}]}