{"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":42},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"count":21},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"count":14},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"count":6},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"count":5},{"query":"sum by (relname) (pg_table_size_bytes{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"count":2},{"query":"avg_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[15m]) - 3 * stddev_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[15m])","timeRangeSeconds":3600,"count":2},{"query":"rate(pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[1m])","timeRangeSeconds":3600,"count":2},{"query":"avg_over_time(pg:query:call_rate1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[15m]) + 3 * stddev_over_time(pg:query:call_rate1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[15m])","timeRangeSeconds":3600,"count":2},{"query":"rate(pg_query_exec_time{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[1m]) /\n rate(pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[1m])","timeRangeSeconds":3600,"count":2},{"query":"avg_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[15m]) + 3 * stddev_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[15m])","timeRangeSeconds":3600,"count":2},{"query":"avg without (cpu) (node:cpu:usage)","timeRangeSeconds":0,"count":1},{"query":"rate(pg_table_n_tup_mod{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.dbrank\"}[1m])","timeRangeSeconds":3600,"count":1},{"query":"pg:db:num_backends / pg:db:conn_limit","timeRangeSeconds":0,"count":1},{"query":"sum(rate(nginx_http_requests_total{ins=~\"nginx-1\"}[32s]))","timeRangeSeconds":3600,"count":1},{"query":"irate(nginx_connections_handled{ins=\"nginx-1\"}[5m])","timeRangeSeconds":3600,"count":1},{"query":"pg_table_size_bytes{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.dbrank\"}","timeRangeSeconds":3600,"count":1},{"query":"increase(pg_table_n_tup_ins{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.dbrank\"}[5m])","timeRangeSeconds":3600,"count":1},{"query":"rate(pg_table_idx_scan{ins=\"pg-meta-1\", datname=\"pgweb\", relname=\"public.webpages\"}[5m])","timeRangeSeconds":3600,"count":1}],"topByAvgDuration":[{"query":"pg_table_n_tup_mod{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.dbrank\"}\n/( 1 + pg_table_tup_read{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.dbrank\"})","timeRangeSeconds":3600,"avgDurationSeconds":0.024,"count":1},{"query":"pg_table_age{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.dbrank\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.023,"count":1},{"query":"avg_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[15m]) + stddev_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[15m])","timeRangeSeconds":3600,"avgDurationSeconds":0.018,"count":1},{"query":"max by (query) (pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"avgDurationSeconds":0.018,"count":1},{"query":"pg_table_tuples{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.dbrank\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.018,"count":1},{"query":"pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}  OFFSET 450s","timeRangeSeconds":3600,"avgDurationSeconds":0.017,"count":1},{"query":"rate(pg_table_seq_tup_read{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.dbrank\"}[1m])","timeRangeSeconds":3600,"avgDurationSeconds":0.016,"count":1},{"query":"avg_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[15m])","timeRangeSeconds":3600,"avgDurationSeconds":0.016,"count":1},{"query":"pg_table_relid{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.dbrank\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.015,"count":1},{"query":"max by (datname, query) (pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\"}) > 0","timeRangeSeconds":0,"avgDurationSeconds":0.014,"count":1},{"query":"pg_table_ncols{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.dbrank\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.013,"count":1},{"query":"rate(pg_table_seq_scan{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.dbrank\"}[5m])","timeRangeSeconds":3600,"avgDurationSeconds":0.013,"count":1},{"query":"rate(pg_table_idx_tup_fetch{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.dbrank\"}[1m])","timeRangeSeconds":3600,"avgDurationSeconds":0.011,"count":1},{"query":"max by (query) (pg_query_exec_time{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"avgDurationSeconds":0.010,"count":1},{"query":"avg_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[15m]) - stddev_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[15m])","timeRangeSeconds":3600,"avgDurationSeconds":0.010,"count":1},{"query":"max by (query) (pg_query_wal_bytes{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"avgDurationSeconds":0.009,"count":1},{"query":"avg_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[15m]) + 3 * stddev_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[15m])","timeRangeSeconds":3600,"avgDurationSeconds":0.009,"count":2},{"query":"stddev_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[5m]) /\navg_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[5m])","timeRangeSeconds":3600,"avgDurationSeconds":0.007,"count":1},{"query":"rate(pg_table_tup_read{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.dbrank\"}[1m])","timeRangeSeconds":3600,"avgDurationSeconds":0.006,"count":1},{"query":"avg_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[15m]) - 3 * stddev_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[15m])","timeRangeSeconds":3600,"avgDurationSeconds":0.005,"count":2}],"topBySumDuration":[{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"sumDurationSeconds":0.128,"count":60},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"sumDurationSeconds":0.057,"count":42},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.026,"count":21},{"query":"pg_table_n_tup_mod{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.dbrank\"}\n/( 1 + pg_table_tup_read{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.dbrank\"})","timeRangeSeconds":3600,"sumDurationSeconds":0.024,"count":1},{"query":"pg_table_age{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.dbrank\"}","timeRangeSeconds":3600,"sumDurationSeconds":0.023,"count":1},{"query":"avg_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[15m]) + 3 * stddev_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[15m])","timeRangeSeconds":3600,"sumDurationSeconds":0.018,"count":2},{"query":"avg_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[15m]) + stddev_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[15m])","timeRangeSeconds":3600,"sumDurationSeconds":0.018,"count":1},{"query":"max by (query) (pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"sumDurationSeconds":0.018,"count":1},{"query":"pg_table_tuples{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.dbrank\"}","timeRangeSeconds":3600,"sumDurationSeconds":0.018,"count":1},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.017,"count":14},{"query":"pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}  OFFSET 450s","timeRangeSeconds":3600,"sumDurationSeconds":0.017,"count":1},{"query":"rate(pg_table_seq_tup_read{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.dbrank\"}[1m])","timeRangeSeconds":3600,"sumDurationSeconds":0.016,"count":1},{"query":"avg_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[15m])","timeRangeSeconds":3600,"sumDurationSeconds":0.016,"count":1},{"query":"pg_table_relid{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.dbrank\"}","timeRangeSeconds":3600,"sumDurationSeconds":0.015,"count":1},{"query":"max by (datname, query) (pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\"}) > 0","timeRangeSeconds":0,"sumDurationSeconds":0.014,"count":1},{"query":"pg_table_ncols{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.dbrank\"}","timeRangeSeconds":3600,"sumDurationSeconds":0.013,"count":1},{"query":"rate(pg_table_seq_scan{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.dbrank\"}[5m])","timeRangeSeconds":3600,"sumDurationSeconds":0.013,"count":1},{"query":"rate(pg_table_idx_tup_fetch{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.dbrank\"}[1m])","timeRangeSeconds":3600,"sumDurationSeconds":0.011,"count":1},{"query":"avg_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[15m]) - 3 * stddev_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[15m])","timeRangeSeconds":3600,"sumDurationSeconds":0.011,"count":2},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.010,"count":6}],"topByAvgMemoryUsage":[{"query":"pg:table:scan_rate1m{ins=\"pg-meta-1\", datname=\"pgweb\"}","timeRangeSeconds":3600,"avgMemoryBytes":481096,"count":1},{"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":21},{"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":14},{"query":"sum by (relname) (pg_table_size_bytes{ins=\"pg-meta-1\", datname=\"pgweb\"})","timeRangeSeconds":0,"avgMemoryBytes":73152,"count":1},{"query":"sum by (relname) (pg_table_n_live_tup{ins=\"pg-meta-1\", datname=\"pgweb\"})","timeRangeSeconds":0,"avgMemoryBytes":72136,"count":1},{"query":"sum by (relname) (pg:table:scan_rate1m{ins=\"pg-meta-1\", datname=\"pgweb\"})","timeRangeSeconds":0,"avgMemoryBytes":72136,"count":1},{"query":"sum by (relname) (pg_table_size_bytes{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgMemoryBytes":70104,"count":2},{"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_exec_time{ins=\"pg-meta-1\", datname=\"postgres\"})","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":46736,"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 (relname) (pg_table_n_live_tup{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgMemoryBytes":41656,"count":1},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"avgMemoryBytes":32512,"count":5},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"avgMemoryBytes":32512,"count":6},{"query":"pg_table_ncols{ins=\"pg-meta-1\", datname=\"pgweb\", relname=\"public.webpages\"}","timeRangeSeconds":3600,"avgMemoryBytes":12536,"count":1},{"query":"avg_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[15m]) - stddev_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[15m])","timeRangeSeconds":3600,"avgMemoryBytes":12536,"count":1}]}