{"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":54},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"count":31},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"count":19},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"count":15},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"count":11},{"query":"avg_over_time(node:cpu:usage[5m])","timeRangeSeconds":0,"count":3},{"query":"sum without (mode) (node:cpu:time_irate1m{mode=\"idle\"})","timeRangeSeconds":0,"count":2},{"query":"pg:db:ixact_time_rate15m / (pg:db:active_time_rate15m + pg:db:ixact_time_rate15m)","timeRangeSeconds":0,"count":2},{"query":"rate(node_schedstat_waiting_seconds_total[1m])","timeRangeSeconds":0,"count":2},{"query":"pg:table:scan_rate1m{ins=\"pg-meta-1\", datname=\"meta\"}","timeRangeSeconds":3600,"count":1},{"query":"rate(pg_query_exec_time{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-2783306896154707576\"}[1m]) /\n rate(pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-2783306896154707576\"}[1m])","timeRangeSeconds":3600,"count":1},{"query":"node:dev:network_tx_bytes_rate1m + node:dev:network_rx_bytes_rate1m","timeRangeSeconds":0,"count":1},{"query":"avg_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-2783306896154707576\"}[15m]) + stddev_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-2783306896154707576\"}[15m])","timeRangeSeconds":3600,"count":1},{"query":"sum by (relname) (pg_table_n_live_tup{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"count":1},{"query":"sum by (ins,instance) (haproxy_backend_current_sessions{cls=\"pg-meta\", proxy!=\"stats\"})","timeRangeSeconds":0,"count":1},{"query":"sum by (ins,datname) (pg_db_numbackends{cls=\"pg-meta\", datname!~\"wal|log|template\\\\d\"})","timeRangeSeconds":3600,"count":1},{"query":"max by (datname, query) (pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\"}) > 0","timeRangeSeconds":0,"count":1},{"query":"increase(pg_query_exec_time{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-2783306896154707576\"}[5m]) /\n increase(pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-2783306896154707576\"}[5m])","timeRangeSeconds":3600,"count":1},{"query":"stddev_over_time(pg:query:call_rate1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-2783306896154707576\"}[5m]) /\navg_over_time(pg:query:call_rate1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-2783306896154707576\"}[5m])","timeRangeSeconds":3600,"count":1}],"topByAvgDuration":[{"query":"sum by (relname) (pg_table_size_bytes{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgDurationSeconds":0.008,"count":1},{"query":"pg:db:num_backends / pg:db:conn_limit","timeRangeSeconds":0,"avgDurationSeconds":0.006,"count":1},{"query":"sum by (relname) (pg_table_n_live_tup{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgDurationSeconds":0.005,"count":1},{"query":"sum by (relname) (pg:table:scan_rate1m{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgDurationSeconds":0.005,"count":1},{"query":"rate(pg_query_exec_time{ins=\"pg-meta-1\", datname=\"pgweb\", query=\"-1278418280557789645\"}[1m]) /\n rate(pg_query_calls{ins=\"pg-meta-1\", datname=\"pgweb\", query=\"-1278418280557789645\"}[1m])","timeRangeSeconds":3600,"avgDurationSeconds":0.004,"count":1},{"query":"avg_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-2783306896154707576\"}[15m]) + 3 * stddev_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-2783306896154707576\"}[15m])","timeRangeSeconds":3600,"avgDurationSeconds":0.004,"count":1},{"query":"rate(pg_query_exec_time{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-2783306896154707576\"}[1m]) /\n rate(pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-2783306896154707576\"}[1m])","timeRangeSeconds":3600,"avgDurationSeconds":0.003,"count":1},{"query":"stddev_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-2783306896154707576\"}[5m]) /\navg_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-2783306896154707576\"}[5m])","timeRangeSeconds":3600,"avgDurationSeconds":0.003,"count":1},{"query":"sum by (ins,datname) (pg_db_numbackends{cls=\"pg-meta\", datname!~\"wal|log|template\\\\d\"})","timeRangeSeconds":3600,"avgDurationSeconds":0.003,"count":1},{"query":"rate(pg_query_calls{ins=\"pg-meta-1\", datname=\"pgweb\", query=\"-1278418280557789645\"}[1m])","timeRangeSeconds":3600,"avgDurationSeconds":0.003,"count":1},{"query":"avg_over_time(node:cpu:usage[5m])","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":3},{"query":"sum without (mode) (node:cpu:time_irate1m{mode=\"idle\"})","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":2},{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":60},{"query":"avg_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-2783306896154707576\"}[15m]) - 3 * stddev_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-2783306896154707576\"}[15m])","timeRangeSeconds":3600,"avgDurationSeconds":0.002,"count":1},{"query":"pg:table:scan_rate1m{ins=\"pg-meta-1\", datname=\"meta\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.002,"count":1},{"query":"avg_over_time(pg:query:call_rate1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-2783306896154707576\"}[15m]) - 3 * stddev_over_time(pg:query:call_rate1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-2783306896154707576\"}[15m])","timeRangeSeconds":3600,"avgDurationSeconds":0.002,"count":1},{"query":"max by (query) (pg:query:call_rate1m{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"sum by (ins,proxy) (haproxy_server_status{state=\"UP\", proxy!=\u0027stats\u0027}) > bool 0","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"rate(node_schedstat_waiting_seconds_total[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":2},{"query":"pg:query:call_rate1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-2783306896154707576\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.002,"count":1}],"topBySumDuration":[{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"sumDurationSeconds":0.139,"count":60},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"sumDurationSeconds":0.072,"count":54},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.039,"count":31},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.022,"count":19},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"sumDurationSeconds":0.021,"count":15},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.015,"count":11},{"query":"sum by (relname) (pg_table_size_bytes{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"sumDurationSeconds":0.008,"count":1},{"query":"avg_over_time(node:cpu:usage[5m])","timeRangeSeconds":0,"sumDurationSeconds":0.007,"count":3},{"query":"pg:db:num_backends / pg:db:conn_limit","timeRangeSeconds":0,"sumDurationSeconds":0.006,"count":1},{"query":"sum without (mode) (node:cpu:time_irate1m{mode=\"idle\"})","timeRangeSeconds":0,"sumDurationSeconds":0.005,"count":2},{"query":"sum by (relname) (pg_table_n_live_tup{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"sumDurationSeconds":0.005,"count":1},{"query":"sum by (relname) (pg:table:scan_rate1m{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"sumDurationSeconds":0.005,"count":1},{"query":"rate(pg_query_exec_time{ins=\"pg-meta-1\", datname=\"pgweb\", query=\"-1278418280557789645\"}[1m]) /\n rate(pg_query_calls{ins=\"pg-meta-1\", datname=\"pgweb\", query=\"-1278418280557789645\"}[1m])","timeRangeSeconds":3600,"sumDurationSeconds":0.004,"count":1},{"query":"avg_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-2783306896154707576\"}[15m]) + 3 * stddev_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-2783306896154707576\"}[15m])","timeRangeSeconds":3600,"sumDurationSeconds":0.004,"count":1},{"query":"rate(node_schedstat_waiting_seconds_total[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.004,"count":2},{"query":"rate(pg_query_exec_time{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-2783306896154707576\"}[1m]) /\n rate(pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-2783306896154707576\"}[1m])","timeRangeSeconds":3600,"sumDurationSeconds":0.003,"count":1},{"query":"stddev_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-2783306896154707576\"}[5m]) /\navg_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-2783306896154707576\"}[5m])","timeRangeSeconds":3600,"sumDurationSeconds":0.003,"count":1},{"query":"sum by (ins,datname) (pg_db_numbackends{cls=\"pg-meta\", datname!~\"wal|log|template\\\\d\"})","timeRangeSeconds":3600,"sumDurationSeconds":0.003,"count":1},{"query":"rate(pg_query_calls{ins=\"pg-meta-1\", datname=\"pgweb\", query=\"-1278418280557789645\"}[1m])","timeRangeSeconds":3600,"sumDurationSeconds":0.003,"count":1},{"query":"pg:db:ixact_time_rate15m / (pg:db:active_time_rate15m + pg:db:ixact_time_rate15m)","timeRangeSeconds":0,"sumDurationSeconds":0.003,"count":2}],"topByAvgMemoryUsage":[{"query":"pg:table:scan_rate1m{ins=\"pg-meta-1\", datname=\"meta\"}","timeRangeSeconds":3600,"avgMemoryBytes":277816,"count":1},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"avgMemoryBytes":130048,"count":31},{"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":19},{"query":"sum by (relname) (pg_table_size_bytes{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgMemoryBytes":70104,"count":1},{"query":"max by (query) (pg:query:call_rate1m{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"avgMemoryBytes":46736,"count":1},{"query":"max by (datname, query) (pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\"}) > 0","timeRangeSeconds":0,"avgMemoryBytes":46736,"count":1},{"query":"max by (query) (pg_query_wal_bytes{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"avgMemoryBytes":46736,"count":1},{"query":"max by (query) (pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"avgMemoryBytes":44704,"count":1},{"query":"sum by (relname) (pg_table_n_live_tup{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgMemoryBytes":41656,"count":1},{"query":"sum by (relname) (pg:table:scan_rate1m{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgMemoryBytes":41656,"count":1},{"query":"sum by (ins,datname) (pg_db_numbackends{cls=\"pg-meta\", datname!~\"wal|log|template\\\\d\"})","timeRangeSeconds":3600,"avgMemoryBytes":37608,"count":1},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"avgMemoryBytes":32512,"count":15},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"avgMemoryBytes":32512,"count":11},{"query":"rate(pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-2783306896154707576\"}[1m])","timeRangeSeconds":3600,"avgMemoryBytes":12536,"count":1},{"query":"stddev_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-2783306896154707576\"}[5m]) /\navg_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-2783306896154707576\"}[5m])","timeRangeSeconds":3600,"avgMemoryBytes":12536,"count":1},{"query":"avg_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-2783306896154707576\"}[15m]) - 3 * stddev_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-2783306896154707576\"}[15m])","timeRangeSeconds":3600,"avgMemoryBytes":12536,"count":1},{"query":"increase(pg_query_exec_time{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-2783306896154707576\"}[15m]) /\n increase(pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-2783306896154707576\"}[15m])","timeRangeSeconds":3600,"avgMemoryBytes":12536,"count":1},{"query":"increase(pg_query_exec_time{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-2783306896154707576\"}[5m]) /\n increase(pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-2783306896154707576\"}[5m])","timeRangeSeconds":3600,"avgMemoryBytes":12536,"count":1},{"query":"rate(pg_query_exec_time{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-2783306896154707576\"}[1m]) /\n rate(pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-2783306896154707576\"}[1m])","timeRangeSeconds":3600,"avgMemoryBytes":12536,"count":1}]}