{"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":57},{"query":"pg:db:ixact_time_rate1m / (pg:db:active_time_rate1m + pg:db:ixact_time_rate1m)","timeRangeSeconds":0,"count":19},{"query":"pgbouncer:db:waiting_clients > 1","timeRangeSeconds":0,"count":19},{"query":"sum without (mode) (pg_lock_count)","timeRangeSeconds":0,"count":17},{"query":"pg:db:age > 0.80","timeRangeSeconds":0,"count":15},{"query":"pg:db:ixact_time_rate15m / (pg:db:active_time_rate15m + pg:db:ixact_time_rate15m)","timeRangeSeconds":0,"count":14},{"query":"pg:db:ixact_time_rate5m / (pg:db:active_time_rate5m + pg:db:ixact_time_rate5m)","timeRangeSeconds":0,"count":13},{"query":"pg:db:conn_usage > 0.70","timeRangeSeconds":0,"count":13},{"query":"sum without (datname) (pg:db:blks_hit_1m) / sum without (datname) (pg:db:blks_access_1m)","timeRangeSeconds":0,"count":11},{"query":"sum without (datname) (pg_lock_count)","timeRangeSeconds":0,"count":9},{"query":"pg:db:blks_hit_1m / pg:db:blks_access_1m","timeRangeSeconds":0,"count":8},{"query":"sum without (mode) (pg_lock_count{mode!~\"AccessShareLock|RowShareLock|RowExclusiveLock\"})","timeRangeSeconds":0,"count":7},{"query":"sum without (datname) (pgbouncer:db:rx_rate1m)","timeRangeSeconds":0,"count":7},{"query":"pgbouncer_database_pool_size{datname!=\"pgbouncer\"} + pgbouncer_database_reserve_pool{datname!=\"pgbouncer\"}","timeRangeSeconds":0,"count":7},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"count":7},{"query":"pgbouncer:db:pool_current_conn / pgbouncer:db:pool_max_conn","timeRangeSeconds":0,"count":6},{"query":"rate(pgbouncer_stat_total_received{datname!=\"pgbouncer\"}[1m])","timeRangeSeconds":0,"count":6},{"query":"sum without (datname) (pgbouncer:db:tx_rate1m)","timeRangeSeconds":0,"count":5},{"query":"(pg_db_conn_limit != -1 ) or (0 * pg_db_conn_limit + on(cls, ins) group_left pg_setting_max_connections)","timeRangeSeconds":0,"count":5}],"topByAvgDuration":[{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"avgDurationSeconds":0.006,"count":60},{"query":"sum by (job, cls) (group by (job, cls, ins, ip) (up{cls!=\"\", ins!=\"\", job=\u0027pgsql\u0027}))","timeRangeSeconds":0,"avgDurationSeconds":0.005,"count":2},{"query":"sum without(datname) (pgbouncer:db:query_rate15m)","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":1},{"query":"rate(pg_db_active_time[5m])","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":57},{"query":"pgbouncer:db:pool_current_conn / pgbouncer:db:pool_size","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":2},{"query":"max without(user, pool_mode) (pgbouncer:pool:active_clients)","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":2},{"query":"rate(pgbouncer_stat_total_xact_time{datname!=\"pgbouncer\"}[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"pg:db:blk_read_time_seconds_rate1m + pg:db:blk_write_time_seconds_rate1m","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":5},{"query":"histogram_quantile(0.95, rate(etcd_disk_wal_fsync_duration_seconds_bucket{job=\"etcd\"}[5m]))","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"node_filesystem_avail_bytes{fstype!~\"(n|root|tmp)fs.*\"}","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"pgbouncer_database_current_connections{datname!=\"pgbouncer\"}","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"histogram_quantile(0.95, rate(etcd_disk_backend_commit_duration_seconds_bucket{job=\"etcd\"}[5m]))","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"sum without(datname) (pg:db:tup_deleted_rate1m)","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"rate(pgbouncer_stat_total_received{datname!=\"pgbouncer\"}[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":6},{"query":"pgbouncer:db:waiting_clients > 1","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":19},{"query":"sum without(datname) (pgbouncer:db:active_clients)","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"pgbouncer_database_pool_size{datname!=\"pgbouncer\"} + pgbouncer_database_reserve_pool{datname!=\"pgbouncer\"}","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":7},{"query":"pgbouncer_pool_maxwait{datname!=\"pgbouncer\"} + pgbouncer_pool_maxwait_us{datname!=\"pgbouncer\"} / 1000000","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":3},{"query":"node:dev:network_tx_bytes_rate1m + node:dev:network_rx_bytes_rate1m","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1}],"topBySumDuration":[{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"sumDurationSeconds":0.367,"count":60},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.138,"count":57},{"query":"pgbouncer:db:waiting_clients > 1","timeRangeSeconds":0,"sumDurationSeconds":0.035,"count":19},{"query":"pg:db:ixact_time_rate1m / (pg:db:active_time_rate1m + pg:db:ixact_time_rate1m)","timeRangeSeconds":0,"sumDurationSeconds":0.027,"count":19},{"query":"pg:db:age > 0.80","timeRangeSeconds":0,"sumDurationSeconds":0.023,"count":15},{"query":"sum without (mode) (pg_lock_count)","timeRangeSeconds":0,"sumDurationSeconds":0.021,"count":17},{"query":"pg:db:conn_usage > 0.70","timeRangeSeconds":0,"sumDurationSeconds":0.018,"count":13},{"query":"pg:db:ixact_time_rate15m / (pg:db:active_time_rate15m + pg:db:ixact_time_rate15m)","timeRangeSeconds":0,"sumDurationSeconds":0.017,"count":14},{"query":"pg:db:ixact_time_rate5m / (pg:db:active_time_rate5m + pg:db:ixact_time_rate5m)","timeRangeSeconds":0,"sumDurationSeconds":0.016,"count":13},{"query":"sum without (datname) (pg:db:blks_hit_1m) / sum without (datname) (pg:db:blks_access_1m)","timeRangeSeconds":0,"sumDurationSeconds":0.015,"count":11},{"query":"sum without (datname) (pg_lock_count)","timeRangeSeconds":0,"sumDurationSeconds":0.013,"count":9},{"query":"pg:db:blks_hit_1m / pg:db:blks_access_1m","timeRangeSeconds":0,"sumDurationSeconds":0.012,"count":8},{"query":"pgbouncer_database_pool_size{datname!=\"pgbouncer\"} + pgbouncer_database_reserve_pool{datname!=\"pgbouncer\"}","timeRangeSeconds":0,"sumDurationSeconds":0.012,"count":7},{"query":"rate(pgbouncer_stat_total_received{datname!=\"pgbouncer\"}[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.011,"count":6},{"query":"sum without (datname) (pgbouncer:db:rx_rate1m)","timeRangeSeconds":0,"sumDurationSeconds":0.011,"count":7},{"query":"pg:db:blk_read_time_seconds_rate1m + pg:db:blk_write_time_seconds_rate1m","timeRangeSeconds":0,"sumDurationSeconds":0.010,"count":5},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.010,"count":7},{"query":"sum by (job, cls) (group by (job, cls, ins, ip) (up{cls!=\"\", ins!=\"\", job=\u0027pgsql\u0027}))","timeRangeSeconds":0,"sumDurationSeconds":0.010,"count":2},{"query":"sum without (mode) (pg_lock_count{mode!~\"AccessShareLock|RowShareLock|RowExclusiveLock\"})","timeRangeSeconds":0,"sumDurationSeconds":0.009,"count":7},{"query":"sum without (datname) (pgbouncer:db:tx_rate1m)","timeRangeSeconds":0,"sumDurationSeconds":0.008,"count":5}],"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":57},{"query":"sum without (datname) (pg_lock_count)","timeRangeSeconds":0,"avgMemoryBytes":56896,"count":9},{"query":"sum without (mode) (pg_lock_count)","timeRangeSeconds":0,"avgMemoryBytes":56896,"count":17},{"query":"sum without (mode) (pg_lock_count{mode!~\"AccessShareLock|RowShareLock|RowExclusiveLock\"})","timeRangeSeconds":0,"avgMemoryBytes":35560,"count":7},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"avgMemoryBytes":32512,"count":7},{"query":"histogram_quantile(0.95, rate(etcd_disk_backend_commit_duration_seconds_bucket{job=\"etcd\"}[5m]))","timeRangeSeconds":0,"avgMemoryBytes":15240,"count":1},{"query":"histogram_quantile(0.95, rate(etcd_disk_wal_fsync_duration_seconds_bucket{job=\"etcd\"}[5m]))","timeRangeSeconds":0,"avgMemoryBytes":15240,"count":1},{"query":"sum without (mode) (pg_lock_count{mode=~\"RowShareLock|RowExclusiveLock\"})","timeRangeSeconds":0,"avgMemoryBytes":14224,"count":3},{"query":"rate(pg_db_blk_read_time[1m])","timeRangeSeconds":0,"avgMemoryBytes":9144,"count":4},{"query":"sum without(datname) (pg:db:active_time_rate5m)","timeRangeSeconds":0,"avgMemoryBytes":9144,"count":2},{"query":"sum without(datname) (pg:db:session_time_rate1m)","timeRangeSeconds":0,"avgMemoryBytes":9144,"count":3},{"query":"rate(pg_db_xact_rollback[1m])","timeRangeSeconds":0,"avgMemoryBytes":9144,"count":1},{"query":"(pg_db_conn_limit != -1 ) or (0 * pg_db_conn_limit + on(cls, ins) group_left pg_setting_max_connections)","timeRangeSeconds":0,"avgMemoryBytes":9144,"count":5},{"query":"pg:db:conn_usage > 0.70","timeRangeSeconds":0,"avgMemoryBytes":9144,"count":13},{"query":"sum without (datname) (pg:db:blks_hit_1m) / sum without (datname) (pg:db:blks_access_1m)","timeRangeSeconds":0,"avgMemoryBytes":9144,"count":11},{"query":"sum without(datname) (pg:db:tup_deleted_rate1m)","timeRangeSeconds":0,"avgMemoryBytes":9144,"count":1},{"query":"rate(pg_db_tup_fetched[1m])","timeRangeSeconds":0,"avgMemoryBytes":9144,"count":1},{"query":"rate(pg_db_ixact_time[5m])","timeRangeSeconds":0,"avgMemoryBytes":9144,"count":1},{"query":"pg:db:age > 0.80","timeRangeSeconds":0,"avgMemoryBytes":9144,"count":15}]}