{"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":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"count":49},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"count":23},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"count":13},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"count":7},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"count":6},{"query":"node:dev:network_tx_bytes_rate1m + node:dev:network_rx_bytes_rate1m","timeRangeSeconds":0,"count":4},{"query":"pg:db:conn_usage > 0.70","timeRangeSeconds":0,"count":3},{"query":"pg:db:age > 0.80","timeRangeSeconds":0,"count":3},{"query":"avg_over_time(node:cpu:usage[5m])","timeRangeSeconds":0,"count":2},{"query":"pg:cls:load1{cls=\"pg-meta\"}","timeRangeSeconds":3600,"count":2},{"query":"sum by (cls,proxy) (haproxy_server_status{proxy=~\"pg-meta-.*\", state=\"UP\"}) > bool 0","timeRangeSeconds":3600,"count":1},{"query":"node:fs:inode_usage > 0.90","timeRangeSeconds":0,"count":1},{"query":"sum without(datname) (pg:db:xlock_count)","timeRangeSeconds":0,"count":1},{"query":"count(group by (ins) (haproxy_backend_current_sessions{cls=\u0027pg-meta\u0027}))","timeRangeSeconds":0,"count":1},{"query":"pgbouncer:cls:load1{cls=\"pg-meta\"}","timeRangeSeconds":3600,"count":1},{"query":"sum by (cls) (pg_db_numbackends{cls=\"pg-meta\"})","timeRangeSeconds":3600,"count":1},{"query":"sum by (cls) (pgbouncer_pool_waiting_clients{cls=\"pg-meta\"})\n# pgbouncer:cls:waiting_clients{cls=\"pg-meta\"}","timeRangeSeconds":3600,"count":1},{"query":"rate(node_schedstat_timeslices_total[1m])","timeRangeSeconds":0,"count":1},{"query":"pg:db:ixact_time_rate5m / (pg:db:active_time_rate5m + pg:db:ixact_time_rate5m)","timeRangeSeconds":0,"count":1}],"topByAvgDuration":[{"query":"max by (datname) (pg_db_datid{cls=\"pg-meta\"})","timeRangeSeconds":0,"avgDurationSeconds":0.018,"count":1},{"query":"count(group by (ins) (haproxy_backend_current_sessions{cls=\u0027pg-meta\u0027}))","timeRangeSeconds":0,"avgDurationSeconds":0.009,"count":1},{"query":"count(max by (cls,datname) (pg_db_age{cls=\"pg-meta\"}))","timeRangeSeconds":0,"avgDurationSeconds":0.008,"count":1},{"query":"sum(rate(process_cpu_seconds_total{cls=\"pg-meta\"}[1m]))","timeRangeSeconds":3600,"avgDurationSeconds":0.008,"count":1},{"query":"avg_over_time(node:cpu:usage[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.005,"count":1},{"query":"sum by (ins,instance) (haproxy_backend_current_sessions{cls=\"pg-meta\", proxy!=\"stats\"})","timeRangeSeconds":0,"avgDurationSeconds":0.005,"count":1},{"query":"ALERTS{cls=\"pg-meta\", alertstate=\"firing\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.004,"count":1},{"query":"pg:db:age > 0.80","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":3},{"query":"sum(node:fs:size_bytes{ip=~\"10\\\\.31\\\\.13\\\\.3\"})","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":1},{"query":"sum(rate(pgbouncer_stat_total_xact_count{cls=\"pg-meta\"}[1m])) \n# pgbouncer:cls:xact_rate1m{cls=\"pg-meta\"} ","timeRangeSeconds":3600,"avgDurationSeconds":0.003,"count":1},{"query":"node:ins:cpu_usage{ip=~\"10\\\\.31\\\\.13\\\\.3\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.003,"count":1},{"query":"pg:cls:load1{cls=\"pg-meta\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.003,"count":2},{"query":"avg by (cls) (haproxy:ins:usage{ip=~\"10\\\\.31\\\\.13\\\\.3\"})","timeRangeSeconds":3600,"avgDurationSeconds":0.003,"count":1},{"query":"pg:cls:cpu_usage{cls=\"pg-meta\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.003,"count":1},{"query":"pg:ins:load1{cls=\"pg-meta\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.003,"count":1},{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":60},{"query":"count(count by (proxy) (haproxy_server_status{proxy=~\"pg-meta-.*\"}))","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"sum without(datname) (pg:db:xlock_count)","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"sum by (cls,proxy) (haproxy_server_status{proxy=~\"pg-meta-.*\", state=\"UP\"}) > bool 0","timeRangeSeconds":3600,"avgDurationSeconds":0.002,"count":1},{"query":"sum by (ins) (haproxy_backend_current_sessions{proxy=~\u0027pg-meta.*\u0027})","timeRangeSeconds":3600,"avgDurationSeconds":0.002,"count":1}],"topBySumDuration":[{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"sumDurationSeconds":0.147,"count":60},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"sumDurationSeconds":0.063,"count":49},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.029,"count":23},{"query":"max by (datname) (pg_db_datid{cls=\"pg-meta\"})","timeRangeSeconds":0,"sumDurationSeconds":0.018,"count":1},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.016,"count":13},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.014,"count":7},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"sumDurationSeconds":0.010,"count":6},{"query":"pg:db:age > 0.80","timeRangeSeconds":0,"sumDurationSeconds":0.010,"count":3},{"query":"count(group by (ins) (haproxy_backend_current_sessions{cls=\u0027pg-meta\u0027}))","timeRangeSeconds":0,"sumDurationSeconds":0.009,"count":1},{"query":"count(max by (cls,datname) (pg_db_age{cls=\"pg-meta\"}))","timeRangeSeconds":0,"sumDurationSeconds":0.008,"count":1},{"query":"sum(rate(process_cpu_seconds_total{cls=\"pg-meta\"}[1m]))","timeRangeSeconds":3600,"sumDurationSeconds":0.008,"count":1},{"query":"pg:cls:load1{cls=\"pg-meta\"}","timeRangeSeconds":3600,"sumDurationSeconds":0.005,"count":2},{"query":"avg_over_time(node:cpu:usage[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.005,"count":1},{"query":"sum by (ins,instance) (haproxy_backend_current_sessions{cls=\"pg-meta\", proxy!=\"stats\"})","timeRangeSeconds":0,"sumDurationSeconds":0.005,"count":1},{"query":"node:dev:network_tx_bytes_rate1m + node:dev:network_rx_bytes_rate1m","timeRangeSeconds":0,"sumDurationSeconds":0.005,"count":4},{"query":"ALERTS{cls=\"pg-meta\", alertstate=\"firing\"}","timeRangeSeconds":3600,"sumDurationSeconds":0.004,"count":1},{"query":"pg:db:conn_usage > 0.70","timeRangeSeconds":0,"sumDurationSeconds":0.003,"count":3},{"query":"sum(node:fs:size_bytes{ip=~\"10\\\\.31\\\\.13\\\\.3\"})","timeRangeSeconds":0,"sumDurationSeconds":0.003,"count":1},{"query":"sum(rate(pgbouncer_stat_total_xact_count{cls=\"pg-meta\"}[1m])) \n# pgbouncer:cls:xact_rate1m{cls=\"pg-meta\"} ","timeRangeSeconds":3600,"sumDurationSeconds":0.003,"count":1},{"query":"node:ins:cpu_usage{ip=~\"10\\\\.31\\\\.13\\\\.3\"}","timeRangeSeconds":3600,"sumDurationSeconds":0.003,"count":1}],"topByAvgMemoryUsage":[{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"avgMemoryBytes":130048,"count":23},{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"avgMemoryBytes":130048,"count":60},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"avgMemoryBytes":113792,"count":13},{"query":"sum by (cls,proxy) (haproxy_server_status{proxy=~\"pg-meta-.*\", state=\"UP\"}) > bool 0","timeRangeSeconds":3600,"avgMemoryBytes":37608,"count":1},{"query":"ALERTS{cls=\"pg-meta\", alertstate=\"firing\"}","timeRangeSeconds":3600,"avgMemoryBytes":37608,"count":1},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"avgMemoryBytes":32512,"count":7},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"avgMemoryBytes":32512,"count":6},{"query":"sum(rate(pg_db_xact_commit{cls=\"pg-meta\"}[1m]))\n# pg:cls:xact_commit_rate1m{cls=\"pg-meta\"}","timeRangeSeconds":3600,"avgMemoryBytes":27104,"count":1},{"query":"sum(rate(pg_db_xact_rollback{cls=\"pg-meta\"}[1m]))\n# pg:cls:xact_commit_rate1m{cls=\"pg-meta\"}","timeRangeSeconds":3600,"avgMemoryBytes":27104,"count":1},{"query":"sum without (mode) (pg_lock_count)","timeRangeSeconds":0,"avgMemoryBytes":24384,"count":1},{"query":"sum(rate(process_cpu_seconds_total{cls=\"pg-meta\"}[1m]))","timeRangeSeconds":3600,"avgMemoryBytes":19424,"count":1},{"query":"sum by (ins) (haproxy_backend_current_sessions{proxy=~\u0027pg-meta.*\u0027})","timeRangeSeconds":3600,"avgMemoryBytes":19424,"count":1},{"query":"sort_desc(sum by (proxy) (haproxy_backend_current_sessions{proxy=~\u0027pg-meta-.*\u0027}))","timeRangeSeconds":3600,"avgMemoryBytes":19424,"count":1},{"query":"count(count by (proxy) (haproxy_server_status{proxy=~\"pg-meta-.*\"}))","timeRangeSeconds":0,"avgMemoryBytes":15240,"count":1},{"query":"sum by (cls) (pg_db_numbackends{cls=\"pg-meta\"})","timeRangeSeconds":3600,"avgMemoryBytes":14680,"count":1},{"query":"sum by (datname) (rate(pg_db_xact_total{cls=\"pg-meta\", datname!~\u0027template\\\\d\u0027}[1m]))","timeRangeSeconds":3600,"avgMemoryBytes":14568,"count":1},{"query":"pg:ins:load1{cls=\"pg-meta\", ins=\"pg-meta-1\"}","timeRangeSeconds":3600,"avgMemoryBytes":12536,"count":1},{"query":"pg:cls:load1{cls=\"pg-meta\"}","timeRangeSeconds":3600,"avgMemoryBytes":8696,"count":2},{"query":"sum(rate(pgbouncer_stat_total_xact_count{cls=\"pg-meta\"}[1m])) \n# pgbouncer:cls:xact_rate1m{cls=\"pg-meta\"} ","timeRangeSeconds":3600,"avgMemoryBytes":6776,"count":1},{"query":"sum(rate(pgbouncer_stat_total_query_count{cls=\"pg-meta\"}[1m])) \n# pgbouncer:cls:query_rate1m{cls=\"pg-meta\"} ","timeRangeSeconds":3600,"avgMemoryBytes":6776,"count":1}]}