{"topN":"20","maxLifetime":"10m0s","search.queryStats.lastQueriesCount":20000,"search.queryStats.minQueryDuration":"1ms","search.queryStats.minQueryMemoryUsage":"1024","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":49},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"count":45},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"count":32},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"count":20},{"query":"node:fs:inode_usage > 0.90","timeRangeSeconds":0,"count":12},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"count":10},{"query":"sum without (datname) (pg_lock_count)","timeRangeSeconds":0,"count":7},{"query":"node:fs:space_usage > 0.90","timeRangeSeconds":0,"count":7},{"query":"pg:db:ixact_time_rate5m / (pg:db:active_time_rate5m + pg:db:ixact_time_rate5m)","timeRangeSeconds":0,"count":5},{"query":"sum without(datname) (pg:db:xact_rollback_rate1m)","timeRangeSeconds":0,"count":5},{"query":"count by (job, cls, ins) (up{cls!=\"\", ins!=\"\", job=\u0027pgsql\u0027})","timeRangeSeconds":0,"count":5},{"query":"avg_over_time(node:cpu:usage[1m])","timeRangeSeconds":0,"count":5},{"query":"pg:db:conn_usage > 0.70","timeRangeSeconds":0,"count":4},{"query":"infra_up \u003c 1","timeRangeSeconds":0,"count":4},{"query":"pg:db:ixact_backends > 1","timeRangeSeconds":0,"count":4},{"query":"pgbouncer_database_pool_size{datname!=\"pgbouncer\"} + pgbouncer_database_reserve_pool{datname!=\"pgbouncer\"}","timeRangeSeconds":0,"count":4},{"query":"sum without (mode) (pg_lock_count)","timeRangeSeconds":0,"count":3},{"query":"clamp(node:fs:avail_bytes / - node:fs:space_deriv1h, -1, 126230400)","timeRangeSeconds":0,"count":3},{"query":"sum without (mode) (node:cpu:time_irate1m{mode=\"idle\"})","timeRangeSeconds":0,"count":3}],"topByAvgDuration":[{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":60},{"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.003,"count":1},{"query":"sum without(datname) (pg:db:active_time_rate1m)","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":2},{"query":"sum without(mode) (pg:cls:locks)","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":1},{"query":"rate(pg_db_active_time[5m])","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":1},{"query":"rate(pg_db_session_time[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":2},{"query":"node:dev:network_tx_bytes_rate1m + node:dev:network_rx_bytes_rate1m","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":2},{"query":"avg_over_time(node:cpu:usage[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":5},{"query":"pg:db:ixact_backends > 1","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":4},{"query":"avg without (cpu) (node:cpu:sched_wait_rate1m)","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"rate(pg_db_active_time[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":2},{"query":"sum without (mode) (node:cpu:time_irate1m{mode=\"idle\"})","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":3},{"query":"avg by (cls, job) (node:cpu:usage)","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":2},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":10},{"query":"count by (job, cls, ins) (up{cls!=\"\", ins!=\"\", job=\u0027pgsql\u0027})","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":5},{"query":"max without (device, fstype, mountpoint) (node:fs:space_usage)","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":20},{"query":"sum without (mode) (pg_lock_count)","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":3},{"query":"sum without (fstype, device, mountpoint) (node:fs:inode_used{fstype!~\"fuse.juicefs\"}) /\nsum without (fstype, device, mountpoint) (node:fs:inode_total{fstype!~\"fuse.juicefs\"})\n","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":3},{"query":"max by (job, device, fstype, mountpoint) (node:fs:space_usage)","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1}],"topBySumDuration":[{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"sumDurationSeconds":0.210,"count":60},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.077,"count":49},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"sumDurationSeconds":0.071,"count":45},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.044,"count":32},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"sumDurationSeconds":0.035,"count":20},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.019,"count":10},{"query":"node:fs:inode_usage > 0.90","timeRangeSeconds":0,"sumDurationSeconds":0.017,"count":12},{"query":"avg_over_time(node:cpu:usage[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.012,"count":5},{"query":"node:fs:space_usage > 0.90","timeRangeSeconds":0,"sumDurationSeconds":0.011,"count":7},{"query":"count by (job, cls, ins) (up{cls!=\"\", ins!=\"\", job=\u0027pgsql\u0027})","timeRangeSeconds":0,"sumDurationSeconds":0.009,"count":5},{"query":"pg:db:ixact_backends > 1","timeRangeSeconds":0,"sumDurationSeconds":0.009,"count":4},{"query":"sum without (datname) (pg_lock_count)","timeRangeSeconds":0,"sumDurationSeconds":0.008,"count":7},{"query":"pg:db:ixact_time_rate5m / (pg:db:active_time_rate5m + pg:db:ixact_time_rate5m)","timeRangeSeconds":0,"sumDurationSeconds":0.007,"count":5},{"query":"sum without (mode) (node:cpu:time_irate1m{mode=\"idle\"})","timeRangeSeconds":0,"sumDurationSeconds":0.006,"count":3},{"query":"sum without(datname) (pg:db:xact_rollback_rate1m)","timeRangeSeconds":0,"sumDurationSeconds":0.006,"count":5},{"query":"sum without(datname) (pg:db:active_time_rate1m)","timeRangeSeconds":0,"sumDurationSeconds":0.006,"count":2},{"query":"sum without (mode) (pg_lock_count)","timeRangeSeconds":0,"sumDurationSeconds":0.005,"count":3},{"query":"sum without (fstype, device, mountpoint) (node:fs:inode_used{fstype!~\"fuse.juicefs\"}) /\nsum without (fstype, device, mountpoint) (node:fs:inode_total{fstype!~\"fuse.juicefs\"})\n","timeRangeSeconds":0,"sumDurationSeconds":0.005,"count":3},{"query":"rate(pg_db_session_time[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.005,"count":2},{"query":"node:dev:network_tx_bytes_rate1m + node:dev:network_rx_bytes_rate1m","timeRangeSeconds":0,"sumDurationSeconds":0.005,"count":2}],"topByAvgMemoryUsage":[{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"avgMemoryBytes":130048,"count":60},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"avgMemoryBytes":130048,"count":49},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"avgMemoryBytes":90424,"count":32},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"avgMemoryBytes":32512,"count":10},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"avgMemoryBytes":32512,"count":20},{"query":"sum without (datname) (pg_lock_count)","timeRangeSeconds":0,"avgMemoryBytes":24384,"count":7},{"query":"sum without (mode) (pg_lock_count)","timeRangeSeconds":0,"avgMemoryBytes":24384,"count":3},{"query":"sum without (mode) (pg_lock_count{mode!~\"AccessShareLock|RowShareLock|RowExclusiveLock\"})","timeRangeSeconds":0,"avgMemoryBytes":15240,"count":1},{"query":"sum without(mode) (pg:cls:locks)","timeRangeSeconds":0,"avgMemoryBytes":8128,"count":1},{"query":"infra_up \u003c 1","timeRangeSeconds":0,"avgMemoryBytes":8128,"count":4},{"query":"sum by (job, cls, mode) (pg:ins:locks)","timeRangeSeconds":0,"avgMemoryBytes":8128,"count":1},{"query":"sum without (mode) (pg_lock_count{mode=~\"RowShareLock|RowExclusiveLock\"})","timeRangeSeconds":0,"avgMemoryBytes":6096,"count":1},{"query":"rate(pg_db_active_time[1m])","timeRangeSeconds":0,"avgMemoryBytes":5080,"count":2},{"query":"pg:db:blks_hit_1m / pg:db:blks_access_1m","timeRangeSeconds":0,"avgMemoryBytes":5080,"count":2},{"query":"rate(pg_db_active_time[5m])","timeRangeSeconds":0,"avgMemoryBytes":5080,"count":1},{"query":"rate(pg_db_temp_bytes[1m])","timeRangeSeconds":0,"avgMemoryBytes":5080,"count":1},{"query":"sum without(datname) (pg:db:xact_commit_rate1m)","timeRangeSeconds":0,"avgMemoryBytes":5080,"count":2},{"query":"pg:db:age > 0.80","timeRangeSeconds":0,"avgMemoryBytes":5080,"count":2},{"query":"pg:db:ixact_time_rate15m / (pg:db:active_time_rate15m + pg:db:ixact_time_rate15m)","timeRangeSeconds":0,"avgMemoryBytes":5080,"count":2},{"query":"sum without(datname) (pg:db:ixact_time_rate5m)","timeRangeSeconds":0,"avgMemoryBytes":5080,"count":1}]}