{"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":20},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"count":8},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"count":6},{"query":"max by (query) (pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"count":2},{"query":"sum by (ins,instance) (haproxy_backend_current_sessions{cls=\"pg-meta\", proxy!=\"stats\"})","timeRangeSeconds":0,"count":2},{"query":"sum without (datname) (pg:db:blks_hit_1m) / sum without (datname) (pg:db:blks_access_1m)","timeRangeSeconds":0,"count":2},{"query":"pg:table:scan_rate1m{ins=\"pg-meta-1\", datname=\"meta\"}","timeRangeSeconds":3600,"count":2},{"query":"max by (query) (pg:query:call_rate1m{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"count":2},{"query":"min by (ins,ip) (up{job=\"pgsql\", cls=\"pg-meta\"})","timeRangeSeconds":0,"count":2},{"query":"max by (datname, query) (pg_query_calls{ins=\"pg-meta-1\", datname=\"meta\"}) > 0","timeRangeSeconds":0,"count":2},{"query":"pgbouncer_database_pool_size{datname!=\"pgbouncer\"} + pgbouncer_database_reserve_pool{datname!=\"pgbouncer\"}","timeRangeSeconds":0,"count":2},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"count":2},{"query":"sum by (proxy,server) (haproxy_server_current_sessions{ins=\"pg-meta-1\"})","timeRangeSeconds":3600,"count":1},{"query":"stddev_over_time(pg:query:call_rate1m{ins=\"pg-meta-1\", datname=\"meta\", query=\"2562851877910530907\"}[5m]) /\navg_over_time(pg:query:call_rate1m{ins=\"pg-meta-1\", datname=\"meta\", query=\"2562851877910530907\"}[5m])","timeRangeSeconds":10800,"count":1},{"query":"rate(pg_query_exec_time{ins=\"pg-meta-1\", datname=\"meta\", query=\"2562851877910530907\"}[1m]) /\n rate(pg_query_calls{ins=\"pg-meta-1\", datname=\"meta\", query=\"2562851877910530907\"}[1m])","timeRangeSeconds":10800,"count":1},{"query":"rate(node_schedstat_waiting_seconds_total[1m])","timeRangeSeconds":0,"count":1},{"query":"avg_over_time(haproxy:ins:service_up{ins=\"pg-meta-1\"}[30d])","timeRangeSeconds":0,"count":1},{"query":"count(sum by (server)(haproxy_server_status{ins=\"pg-meta-1\"})) or on() vector(0)","timeRangeSeconds":0,"count":1},{"query":"max by (query) (pg_query_exec_time{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"count":1}],"topByAvgDuration":[{"query":"avg_over_time(haproxy:ins:service_up{ins=\"pg-meta-1\"}[30d])","timeRangeSeconds":0,"avgDurationSeconds":0.101,"count":1},{"query":"max by (query) (pg_query_wal_bytes{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgDurationSeconds":0.007,"count":1},{"query":"haproxy:ins:service_up{ins=\"pg-meta-1\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.005,"count":1},{"query":"max by (query) (pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":2},{"query":"sum without (datname) (pg:db:blks_hit_1m) / sum without (datname) (pg:db:blks_access_1m)","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":2},{"query":"sum without(state) (pg_activity_count{state=\"active\"})","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":1},{"query":"sum by (relname) (pg_table_n_live_tup{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":1},{"query":"pg_table_n_tup_mod{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pgext.category\"}\n/( 1 + pg_table_tup_read{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pgext.category\"})","timeRangeSeconds":3600,"avgDurationSeconds":0.002,"count":1},{"query":"sum by (relname) (pg_table_size_bytes{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"max by (query) (pg:query:call_rate1m{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":2},{"query":"sum by (relname) (pg:table:scan_rate1m{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":60},{"query":"stddev_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"meta\", query=\"2562851877910530907\"}[5m]) /\navg_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"meta\", query=\"2562851877910530907\"}[5m])","timeRangeSeconds":10800,"avgDurationSeconds":0.002,"count":1},{"query":"sum(haproxy_frontend_current_sessions{ins=\"pg-meta-1\"})","timeRangeSeconds":3600,"avgDurationSeconds":0.002,"count":1},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":6},{"query":"pg:query:call_rate1m{ins=\"pg-meta-1\", datname=\"meta\", query=\"2562851877910530907\"}","timeRangeSeconds":10800,"avgDurationSeconds":0.002,"count":1},{"query":"min by (ins,ip) (up{job=\"pgsql\", cls=\"pg-meta\"})","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":2},{"query":"sum without(datname) (pg:db:tup_fetched_rate1m)","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"rate(pg_query_exec_time{ins=\"pg-meta-1\", datname=\"meta\", query=\"-8552847445689500967\"}[1m]) /\n rate(pg_query_calls{ins=\"pg-meta-1\", datname=\"meta\", query=\"-8552847445689500967\"}[1m])","timeRangeSeconds":10800,"avgDurationSeconds":0.002,"count":1},{"query":"sum by (ins,instance) (haproxy_backend_current_sessions{cls=\"pg-meta\", proxy!=\"stats\"})","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":2}],"topBySumDuration":[{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"sumDurationSeconds":0.121,"count":60},{"query":"avg_over_time(haproxy:ins:service_up{ins=\"pg-meta-1\"}[30d])","timeRangeSeconds":0,"sumDurationSeconds":0.101,"count":1},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"sumDurationSeconds":0.031,"count":20},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.013,"count":8},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"sumDurationSeconds":0.012,"count":6},{"query":"max by (query) (pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"sumDurationSeconds":0.007,"count":2},{"query":"max by (query) (pg_query_wal_bytes{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"sumDurationSeconds":0.007,"count":1},{"query":"sum without (datname) (pg:db:blks_hit_1m) / sum without (datname) (pg:db:blks_access_1m)","timeRangeSeconds":0,"sumDurationSeconds":0.006,"count":2},{"query":"haproxy:ins:service_up{ins=\"pg-meta-1\"}","timeRangeSeconds":3600,"sumDurationSeconds":0.005,"count":1},{"query":"max by (query) (pg:query:call_rate1m{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"sumDurationSeconds":0.004,"count":2},{"query":"min by (ins,ip) (up{job=\"pgsql\", cls=\"pg-meta\"})","timeRangeSeconds":0,"sumDurationSeconds":0.003,"count":2},{"query":"sum by (ins,instance) (haproxy_backend_current_sessions{cls=\"pg-meta\", proxy!=\"stats\"})","timeRangeSeconds":0,"sumDurationSeconds":0.003,"count":2},{"query":"sum without(state) (pg_activity_count{state=\"active\"})","timeRangeSeconds":0,"sumDurationSeconds":0.003,"count":1},{"query":"pg:table:scan_rate1m{ins=\"pg-meta-1\", datname=\"meta\"}","timeRangeSeconds":3600,"sumDurationSeconds":0.003,"count":2},{"query":"sum by (relname) (pg_table_n_live_tup{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"sumDurationSeconds":0.003,"count":1},{"query":"pg_table_n_tup_mod{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pgext.category\"}\n/( 1 + pg_table_tup_read{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pgext.category\"})","timeRangeSeconds":3600,"sumDurationSeconds":0.002,"count":1},{"query":"max by (datname, query) (pg_query_calls{ins=\"pg-meta-1\", datname=\"meta\"}) > 0","timeRangeSeconds":0,"sumDurationSeconds":0.002,"count":2},{"query":"sum by (relname) (pg_table_size_bytes{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"sumDurationSeconds":0.002,"count":1},{"query":"pgbouncer_database_pool_size{datname!=\"pgbouncer\"} + pgbouncer_database_reserve_pool{datname!=\"pgbouncer\"}","timeRangeSeconds":0,"sumDurationSeconds":0.002,"count":2},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.002,"count":2}],"topByAvgMemoryUsage":[{"query":"pg:table:scan_rate1m{ins=\"pg-meta-1\", datname=\"meta\"}","timeRangeSeconds":3600,"avgMemoryBytes":159736,"count":2},{"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":8},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"avgMemoryBytes":113792,"count":2},{"query":"sum by (relname) (pg_table_size_bytes{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgMemoryBytes":70104,"count":1},{"query":"pg:db:blks_hit_ratio1m{ins=\"pg-meta-1\"}","timeRangeSeconds":3600,"avgMemoryBytes":62680,"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":"max by (query) (pg_query_exec_time{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgMemoryBytes":40640,"count":1},{"query":"max by (query) (pg_query_wal_bytes{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgMemoryBytes":40640,"count":1},{"query":"max by (query) (pg:query:call_rate1m{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgMemoryBytes":40640,"count":2},{"query":"max by (datname, query) (pg_query_calls{ins=\"pg-meta-1\", datname=\"meta\"}) > 0","timeRangeSeconds":0,"avgMemoryBytes":40640,"count":2},{"query":"haproxy:ins:service_up{ins=\"pg-meta-1\"}","timeRangeSeconds":3600,"avgMemoryBytes":37608,"count":1},{"query":"sum by (proxy,server) (haproxy_server_current_sessions{ins=\"pg-meta-1\"})","timeRangeSeconds":3600,"avgMemoryBytes":37608,"count":1},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"avgMemoryBytes":32512,"count":6},{"query":"max by (query) (pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgMemoryBytes":30480,"count":2},{"query":"count(sum by (server)(haproxy_server_status{ins=\"pg-meta-1\"})) or on() vector(0)","timeRangeSeconds":0,"avgMemoryBytes":15240,"count":1},{"query":"1 * min without(state) (haproxy_server_status{ins=\"pg-meta-1\", proxy=\"pg-meta-default\", state=\"UP\"})\n+ 2 * min without(state) (haproxy_server_status{ins=\"pg-meta-1\", proxy=\"pg-meta-default\", state=\"DRAIN\"})\n+ 4 * min without(state) (haproxy_server_status{ins=\"pg-meta-1\", proxy=\"pg-meta-default\", state=\"MAINT\"})\n+ 8 * min without(state) (haproxy_server_status{ins=\"pg-meta-1\", proxy=\"pg-meta-default\", state=\"NOLB\"})","timeRangeSeconds":3600,"avgMemoryBytes":12536,"count":1},{"query":"rate(pg_query_exec_time{ins=\"pg-meta-1\", datname=\"meta\", query=\"-8552847445689500967\"}[1m]) /\n rate(pg_query_calls{ins=\"pg-meta-1\", datname=\"meta\", query=\"-8552847445689500967\"}[1m])","timeRangeSeconds":10800,"avgMemoryBytes":9656,"count":1},{"query":"sum(haproxy_frontend_current_sessions{ins=\"pg-meta-1\"})","timeRangeSeconds":3600,"avgMemoryBytes":7904,"count":1}]}