{"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":"rate(pg_query_calls[1m])","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":"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":59},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"count":55},{"query":"sum by (job) (node:cls:cpu_usage * node:cls:cpu_count) / sum by (job) (node:cls:cpu_count)","timeRangeSeconds":0,"count":45},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"count":43},{"query":"redis:ins:cmd_time / redis:ins:cmd_qps","timeRangeSeconds":0,"count":36},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"count":35},{"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":28},{"query":"sum without (cmd) (redis:ins:cmd_time) / sum without (cmd) (redis:ins:cmd_qps)","timeRangeSeconds":0,"count":23},{"query":"(pg_db_conn_limit != -1 ) or (0 * pg_db_conn_limit + on(cls, ins) group_left pg_setting_max_connections)","timeRangeSeconds":0,"count":21},{"query":"pg:db:ixact_time_rate1m / (pg:db:active_time_rate1m + pg:db:ixact_time_rate1m)","timeRangeSeconds":0,"count":19},{"query":"pg:db:ixact_time_rate5m / (pg:db:active_time_rate5m + pg:db:ixact_time_rate5m)","timeRangeSeconds":0,"count":19},{"query":"sum(patroni_failsafe_mode_is_active{}) > 0","timeRangeSeconds":0,"count":18},{"query":"max without (instance) (pg:ins:load1 > ignoring(instance) pgbouncer:ins:load1 or pgbouncer:ins:load1)","timeRangeSeconds":0,"count":17},{"query":"pgbouncer_database_pool_size{datname!=\"pgbouncer\"} + pgbouncer_database_reserve_pool{datname!=\"pgbouncer\"}","timeRangeSeconds":0,"count":17},{"query":"avg_over_time(node:cpu:usage[5m])","timeRangeSeconds":0,"count":16},{"query":"pg:db:ixact_time_rate15m / (pg:db:active_time_rate15m + pg:db:ixact_time_rate15m)","timeRangeSeconds":0,"count":15}],"topByAvgDuration":[{"query":"avg by (job, cls) (redis:ins:cpu_sys)","timeRangeSeconds":0,"avgDurationSeconds":0.021,"count":1},{"query":"redis:cls:mem_used / redis:cls:mem_max","timeRangeSeconds":0,"avgDurationSeconds":0.021,"count":1},{"query":"sum without(state) (pg_activity_count{state=~\"idle in.*\"})","timeRangeSeconds":0,"avgDurationSeconds":0.019,"count":1},{"query":"rate(pg_db_tup_inserted[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.016,"count":1},{"query":"sum without (device) (node:dev:disk_write_bytes_rate1m)","timeRangeSeconds":0,"avgDurationSeconds":0.016,"count":1},{"query":"max by (job, cls) (node:ins:space_usage_max)","timeRangeSeconds":0,"avgDurationSeconds":0.014,"count":1},{"query":"max by (job, cls) (pg:ins:lag_seconds)","timeRangeSeconds":0,"avgDurationSeconds":0.014,"count":1},{"query":"rate(pg_db_xact_total[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.014,"count":1},{"query":"rate(pg_table_seq_tup_read{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pglog.sample\"}[1m])","timeRangeSeconds":3600,"avgDurationSeconds":0.014,"count":1},{"query":"rate(node_disk_reads_completed_total{device=~\"[a-z0-9A-Z-_]+\"}[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.012,"count":1},{"query":"sum by (relname) (pg:table:scan_rate1m{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgDurationSeconds":0.012,"count":1},{"query":"redis:env:key_hit / (redis:env:key_hit + redis:env:key_miss)","timeRangeSeconds":0,"avgDurationSeconds":0.011,"count":1},{"query":"sum by (relname) (pg_table_size_bytes{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgDurationSeconds":0.011,"count":1},{"query":"avg_over_time(node:env:cpu_usage[5m])","timeRangeSeconds":0,"avgDurationSeconds":0.011,"count":2},{"query":"sum by (job) (pg:cls:xact_commit_rate5m)","timeRangeSeconds":0,"avgDurationSeconds":0.010,"count":3},{"query":"avg_over_time(node:cls:cpu_usage[15m])","timeRangeSeconds":0,"avgDurationSeconds":0.010,"count":3},{"query":"sum by (job, cls) (group by (job, cls, ins, ip) (up{cls!=\"\", ins!=\"\", job=\u0027pgsql\u0027}))","timeRangeSeconds":0,"avgDurationSeconds":0.010,"count":6},{"query":"min by (ins,ip) (pg_in_recovery{cls=\"pg-meta\"})","timeRangeSeconds":0,"avgDurationSeconds":0.010,"count":1},{"query":"rate(node_forks_total[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.009,"count":7},{"query":"avg_over_time(node:cls:cpu_usage[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.009,"count":2}],"topBySumDuration":[{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"sumDurationSeconds":0.372,"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.308,"count":60},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"sumDurationSeconds":0.202,"count":55},{"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.198,"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,"sumDurationSeconds":0.144,"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.135,"count":21},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.135,"count":60},{"query":"sum by (job) (node:cls:cpu_usage * node:cls:cpu_count) / sum by (job) (node:cls:cpu_count)","timeRangeSeconds":0,"sumDurationSeconds":0.128,"count":45},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.108,"count":43},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"sumDurationSeconds":0.085,"count":35},{"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.081,"count":28},{"query":"avg_over_time(node:cpu:usage[5m])","timeRangeSeconds":0,"sumDurationSeconds":0.078,"count":16},{"query":"rate(node_forks_total[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.066,"count":7},{"query":"sum by (job, cls) (group by (job, cls, ins, ip) (up{cls!=\"\", ins!=\"\", job=\u0027pgsql\u0027}))","timeRangeSeconds":0,"sumDurationSeconds":0.061,"count":6},{"query":"redis:ins:cmd_time / redis:ins:cmd_qps","timeRangeSeconds":0,"sumDurationSeconds":0.058,"count":36},{"query":"pg:ins:active_time_rate1m / pg:ins:cpu_count or (0 * pg_up - 1)","timeRangeSeconds":0,"sumDurationSeconds":0.058,"count":12},{"query":"pg:db:ixact_time_rate5m / (pg:db:active_time_rate5m + pg:db:ixact_time_rate5m)","timeRangeSeconds":0,"sumDurationSeconds":0.057,"count":19},{"query":"sum without (cmd) (redis:ins:cmd_time) / sum without (cmd) (redis:ins:cmd_qps)","timeRangeSeconds":0,"sumDurationSeconds":0.057,"count":23},{"query":"pg:ins:active_time_rate5m / pg:ins:cpu_count or (0 * pg_up - 1)","timeRangeSeconds":0,"sumDurationSeconds":0.053,"count":8},{"query":"pg:db:ixact_time_rate1m / (pg:db:active_time_rate1m + pg:db:ixact_time_rate1m)","timeRangeSeconds":0,"sumDurationSeconds":0.052,"count":19}]}