{"topN":"20","maxLifetime":"10m0s","search.queryStats.lastQueriesCount":20000,"search.queryStats.minQueryDuration":"1ms","search.queryStats.minQueryMemoryUsage":"1024","topByCount":[{"query":"node:ins:cpu_usage_1m + on(ip) group_right() pg_up * 0","timeRangeSeconds":0,"count":115},{"query":"pg:db:ixact_time_rate5m / (pg:db:active_time_rate5m + pg:db:ixact_time_rate5m)","timeRangeSeconds":0,"count":61},{"query":"(2147483648 - pg_db_age) / pg:db:age_deriv1h","timeRangeSeconds":0,"count":61},{"query":"pg:db:ixact_time_rate1m / (pg:db:active_time_rate1m + pg:db:ixact_time_rate1m)","timeRangeSeconds":0,"count":61},{"query":"pg:db:num_backends / pg:db:conn_limit","timeRangeSeconds":0,"count":61},{"query":"pg:db:ixact_time_rate15m / (pg:db:active_time_rate15m + pg:db:ixact_time_rate15m)","timeRangeSeconds":0,"count":61},{"query":"(pg_db_conn_limit != -1 ) or (0 * pg_db_conn_limit + on(cls, ins) group_left pg_setting_max_connections)","timeRangeSeconds":0,"count":61},{"query":"pg:db:blk_read_time_seconds_rate1m + pg:db:blk_write_time_seconds_rate1m","timeRangeSeconds":0,"count":60},{"query":"pg:cls:load5 > pgbouncer:cls:load5 or pgbouncer:cls:load5","timeRangeSeconds":0,"count":60},{"query":"sum without(datname) (pg:db:xact_total_rate1m)","timeRangeSeconds":0,"count":60},{"query":"sum without (cmd) (redis:ins:cmd_time) / sum without (cmd) (redis:ins:cmd_qps)","timeRangeSeconds":0,"count":60},{"query":"histogram_quantile(0.95, rate(etcd_disk_backend_commit_duration_seconds_bucket{job=\"etcd\"}[5m]))","timeRangeSeconds":0,"count":60},{"query":"pgbouncer:db:pool_current_conn / pgbouncer:db:pool_size","timeRangeSeconds":0,"count":60},{"query":"node:dev:disk_reads_rate1m + node:dev:disk_writes_rate1m","timeRangeSeconds":0,"count":60},{"query":"sum without (datname) (pg_lock_count)","timeRangeSeconds":0,"count":60},{"query":"sum by (job,cls,cmd) (redis:ins:cmd_time)","timeRangeSeconds":0,"count":60},{"query":"rate(redis_commands_total[1m])","timeRangeSeconds":0,"count":60},{"query":"node_netstat_TcpExt_ListenOverflows +\nnode_netstat_TcpExt_ListenDrops +\nnode_netstat_Tcp_InErrs\n","timeRangeSeconds":0,"count":60},{"query":"rate(redis_commands_duration_seconds_total[1m])","timeRangeSeconds":0,"count":60},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"count":60}],"topByAvgDuration":[{"query":"sum by (relname) (\n    rate(pg_table_tup_read{cls=\"pg-meta\", datname=\"discourse\"}[1m])\n)","timeRangeSeconds":10800,"avgDurationSeconds":0.121,"count":1},{"query":"max by (relname) (pg_table_size_bytes{cls=\"pg-meta\", datname=\"discourse\"})","timeRangeSeconds":0,"avgDurationSeconds":0.114,"count":1},{"query":"sum by (relname) (\n    pg:table:scan_rate1m{cls=\"pg-meta\", datname=\"discourse\"}\n)","timeRangeSeconds":0,"avgDurationSeconds":0.096,"count":1},{"query":"max by (relname) (pg_table_n_dead_tup{ins=\"pg-meta-3\", datname=\"discourse\"})","timeRangeSeconds":0,"avgDurationSeconds":0.063,"count":1},{"query":"sum by (relname) (pg_table_seq_scan{ins=\"pg-meta-3\", datname=\"discourse\"})","timeRangeSeconds":0,"avgDurationSeconds":0.057,"count":1},{"query":"max by (relname) (pg_table_n_live_tup{ins=\"pg-meta-3\", datname=\"discourse\"})","timeRangeSeconds":0,"avgDurationSeconds":0.057,"count":1},{"query":"sum by (relname) (rate(pg_table_tup_read{ins=\"pg-meta-3\", datname=\"discourse\"}[1m]))","timeRangeSeconds":0,"avgDurationSeconds":0.053,"count":1},{"query":"sum by (relname) (rate(pg_table_n_tup_mod{ins=\"pg-meta-3\", datname=\"discourse\"}[1m]))","timeRangeSeconds":0,"avgDurationSeconds":0.048,"count":1},{"query":"rate(pg_index_idx_blks_hit{ins=\"pg-center-1\", datname=\"test_center_restore_20260930\", relname=\"public.release_patch\"}[1m]) / (rate(pg_index_idx_blks_read{ins=\"pg-center-1\", datname=\"test_center_restore_20260930\", relname=\"public.release_patch\"}[1m]) + rate(pg_index_idx_blks_hit{ins=\"pg-center-1\", datname=\"test_center_restore_20260930\", relname=\"public.release_patch\"}[1m]))","timeRangeSeconds":3600,"avgDurationSeconds":0.046,"count":1},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.023,"count":60},{"query":"sum by (relname) (pg:table:scan_rate1m{ins=\"pg-center-1\", datname=\"test_center_restore_20260930\"})","timeRangeSeconds":0,"avgDurationSeconds":0.022,"count":1},{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"avgDurationSeconds":0.022,"count":60},{"query":"sum by (relname) (pg_table_n_live_tup{ins=\"pg-center-1\", datname=\"test_center_restore_20260930\"})","timeRangeSeconds":0,"avgDurationSeconds":0.021,"count":1},{"query":"sum by (relname) (pg_table_size_bytes{ins=\"pg-center-1\", datname=\"test_center_restore_20260930\"})","timeRangeSeconds":0,"avgDurationSeconds":0.018,"count":1},{"query":"sum by (ins) (pg:ins:xact_total_rate5m{cls=\"pg-center\", ins=\"pg-center-1\"})","timeRangeSeconds":3600,"avgDurationSeconds":0.017,"count":1},{"query":"rate(pg_table_heap_blks_hit{ins=\"pg-center-1\", datname=\"test_center_restore_20260930\", relname=\"public.release_patch\"}[1m]) / (rate(pg_table_heap_blks_read{ins=\"pg-center-1\", datname=\"test_center_restore_20260930\", relname=\"public.release_patch\"}[1m]) + rate(pg_table_heap_blks_hit{ins=\"pg-center-1\", datname=\"test_center_restore_20260930\", relname=\"public.release_patch\"}[1m]))","timeRangeSeconds":3600,"avgDurationSeconds":0.014,"count":1},{"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,"avgDurationSeconds":0.013,"count":60},{"query":"max by (relname, relid) (pg_table_relid{ins=\"pg-meta-3\"})","timeRangeSeconds":0,"avgDurationSeconds":0.013,"count":3},{"query":"rate(pg_index_idx_tup_fetch{ins=\"pg-center-1\", datname=\"test_center_restore_20260930\", relname=\"public.release_patch\"}[1m])","timeRangeSeconds":3600,"avgDurationSeconds":0.012,"count":1},{"query":"increase(pg_index_idx_tup_read{ins=\"pg-center-1\", datname=\"test_center_restore_20260930\", relname=\"public.release_patch\"}[1m]) / increase(pg_index_idx_scan{ins=\"pg-center-1\", datname=\"test_center_restore_20260930\", relname=\"public.release_patch\"}[1m])","timeRangeSeconds":3600,"avgDurationSeconds":0.012,"count":1}],"topBySumDuration":[{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"sumDurationSeconds":1.376,"count":60},{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"sumDurationSeconds":1.292,"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.795,"count":60},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.522,"count":60},{"query":"redis:ins:cmd_time / redis:ins:cmd_qps","timeRangeSeconds":0,"sumDurationSeconds":0.479,"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.411,"count":60},{"query":"sum without (cmd) (redis:ins:cmd_time) / sum without (cmd) (redis:ins:cmd_qps)","timeRangeSeconds":0,"sumDurationSeconds":0.396,"count":60},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"sumDurationSeconds":0.273,"count":60},{"query":"sum by (job,cls,cmd) (redis:ins:cmd_time)","timeRangeSeconds":0,"sumDurationSeconds":0.245,"count":60},{"query":"pg:db:ixact_time_rate15m / (pg:db:active_time_rate15m + pg:db:ixact_time_rate15m)","timeRangeSeconds":0,"sumDurationSeconds":0.244,"count":61},{"query":"sum by (job,cmd) (redis:ins:cmd_time)","timeRangeSeconds":0,"sumDurationSeconds":0.238,"count":60},{"query":"pg:db:ixact_time_rate1m / (pg:db:active_time_rate1m + pg:db:ixact_time_rate1m)","timeRangeSeconds":0,"sumDurationSeconds":0.237,"count":61},{"query":"pg:db:ixact_time_rate5m / (pg:db:active_time_rate5m + pg:db:ixact_time_rate5m)","timeRangeSeconds":0,"sumDurationSeconds":0.233,"count":61},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.230,"count":60},{"query":"rate(redis_commands_total[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.216,"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.214,"count":59},{"query":"rate(redis_commands_duration_seconds_total[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.213,"count":60},{"query":"sum by (job,cls,cmd) (redis:ins:cmd_qps)","timeRangeSeconds":0,"sumDurationSeconds":0.212,"count":60},{"query":"pg:db:blk_read_time_seconds_rate1m + pg:db:blk_write_time_seconds_rate1m","timeRangeSeconds":0,"sumDurationSeconds":0.211,"count":60},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"sumDurationSeconds":0.208,"count":60}],"topByAvgMemoryUsage":[{"query":"sum by (relname) (\n    rate(pg_table_tup_read{cls=\"pg-meta\", datname=\"discourse\"}[1m])\n)","timeRangeSeconds":10800,"avgMemoryBytes":4098048,"count":1},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"avgMemoryBytes":1554480,"count":60},{"query":"sum by (relname) (\n    pg:table:scan_rate1m{cls=\"pg-meta\", datname=\"discourse\"}\n)","timeRangeSeconds":0,"avgMemoryBytes":780288,"count":1},{"query":"max by (relname) (pg_table_size_bytes{cls=\"pg-meta\", datname=\"discourse\"})","timeRangeSeconds":0,"avgMemoryBytes":780288,"count":1},{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"avgMemoryBytes":520192,"count":60},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"avgMemoryBytes":520192,"count":60},{"query":"pg:table:scan_rate1m{ins=\"pg-center-1\", datname=\"test_center_restore_20260930\"}","timeRangeSeconds":3600,"avgMemoryBytes":389600,"count":1},{"query":"max by (relname, relid) (pg_table_relid{ins=\"pg-meta-3\"})","timeRangeSeconds":0,"avgMemoryBytes":272288,"count":3},{"query":"max by (relname) (pg_table_size_bytes{ins=\"pg-meta-3\", datname=\"discourse\"})","timeRangeSeconds":0,"avgMemoryBytes":260096,"count":1},{"query":"sum by (relname) (rate(pg_table_n_tup_mod{ins=\"pg-meta-3\", datname=\"discourse\"}[1m]))","timeRangeSeconds":0,"avgMemoryBytes":260096,"count":1},{"query":"sum by (relname) (pg_table_seq_scan{ins=\"pg-meta-3\", datname=\"discourse\"})","timeRangeSeconds":0,"avgMemoryBytes":260096,"count":1},{"query":"sum by (relname) (rate(pg_table_tup_read{ins=\"pg-meta-3\", datname=\"discourse\"}[1m]))","timeRangeSeconds":0,"avgMemoryBytes":260096,"count":1},{"query":"max by (relname) (pg_table_n_live_tup{ins=\"pg-meta-3\", datname=\"discourse\"})","timeRangeSeconds":0,"avgMemoryBytes":260096,"count":1},{"query":"max by (relname) (pg_table_n_dead_tup{ins=\"pg-meta-3\", datname=\"discourse\"})","timeRangeSeconds":0,"avgMemoryBytes":260096,"count":1},{"query":"sum by (relname) (pg:table:scan_rate1m{ins=\"pg-meta-3\", datname=\"discourse\"})","timeRangeSeconds":0,"avgMemoryBytes":260096,"count":1},{"query":"sum without (mode) (pg_lock_count)","timeRangeSeconds":0,"avgMemoryBytes":178816,"count":60},{"query":"sum without (datname) (pg_lock_count)","timeRangeSeconds":0,"avgMemoryBytes":178816,"count":60},{"query":"rate(redis_commands_duration_seconds_total[1m])","timeRangeSeconds":0,"avgMemoryBytes":174752,"count":60},{"query":"sum by (job,cls,cmd) (redis:ins:cmd_qps)","timeRangeSeconds":0,"avgMemoryBytes":174752,"count":60},{"query":"sum without (cmd) (redis:ins:cmd_time) / sum without (cmd) (redis:ins:cmd_qps)","timeRangeSeconds":0,"avgMemoryBytes":174752,"count":60}]}