{"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":25},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"count":14},{"query":"deriv(node:fs:avail_bytes[1h])","timeRangeSeconds":0,"count":13},{"query":"avg_over_time(node:cpu:usage[15m])","timeRangeSeconds":0,"count":13},{"query":"rate(pg_db_xact_commit[15m])","timeRangeSeconds":0,"count":12},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"count":11},{"query":"rate(pg_db_active_time[15m])","timeRangeSeconds":0,"count":10},{"query":"rate(pg_db_xact_rollback[15m])","timeRangeSeconds":0,"count":9},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"count":8},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"count":6},{"query":"pgbouncer_database_pool_size{datname!=\"pgbouncer\"} + pgbouncer_database_reserve_pool{datname!=\"pgbouncer\"}","timeRangeSeconds":0,"count":6},{"query":"pg:db:ixact_time_rate1m / (pg:db:active_time_rate1m + pg:db:ixact_time_rate1m)","timeRangeSeconds":0,"count":6},{"query":"pg:db:age > 0.80","timeRangeSeconds":0,"count":3},{"query":"sum without (type, client_api_version) (increase(etcd_server_client_requests_total{job=\"etcd\"}[1m]))","timeRangeSeconds":0,"count":3},{"query":"rate(node_schedstat_waiting_seconds_total[1m])","timeRangeSeconds":0,"count":2},{"query":"up{job=\"infra\"}","timeRangeSeconds":0,"count":2},{"query":"rate(pg_query_exec_time{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-4426219414945232276\"}[1m]) /\n rate(pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-4426219414945232276\"}[1m])","timeRangeSeconds":3600,"count":2},{"query":"histogram_quantile(0.95, rate(etcd_disk_wal_fsync_duration_seconds_bucket{job=\"etcd\"}[5m]))","timeRangeSeconds":0,"count":2},{"query":"pg:db:conn_usage > 0.70","timeRangeSeconds":0,"count":2}],"topByAvgDuration":[{"query":"max by (datname, query) (pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\"}) > 0","timeRangeSeconds":0,"avgDurationSeconds":0.027,"count":1},{"query":"max by (query) (pg_query_wal_bytes{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"avgDurationSeconds":0.024,"count":1},{"query":"max by (query) (pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"avgDurationSeconds":0.017,"count":1},{"query":"max by (query) (pg:query:call_rate1m{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"avgDurationSeconds":0.014,"count":1},{"query":"max by (query) (pg_query_exec_time{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"avgDurationSeconds":0.012,"count":1},{"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,"avgDurationSeconds":0.012,"count":1},{"query":"rate(pg_table_n_tup_mod{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pgext.universe\"}[1m])","timeRangeSeconds":3600,"avgDurationSeconds":0.011,"count":1},{"query":"up{job=\"infra\"}","timeRangeSeconds":0,"avgDurationSeconds":0.009,"count":2},{"query":"node:fs:space_usage > 0.90","timeRangeSeconds":0,"avgDurationSeconds":0.009,"count":1},{"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.009,"count":1},{"query":"rate(pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[1m])","timeRangeSeconds":3600,"avgDurationSeconds":0.008,"count":1},{"query":"pg_table_relid{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pgext.universe\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.008,"count":1},{"query":"count(sum by (proxy) (haproxy_backend_current_sessions{ins=\"pg-meta-1\", proxy!=\"stats\"}))","timeRangeSeconds":0,"avgDurationSeconds":0.007,"count":1},{"query":"rate(pg_table_seq_scan{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pgext.universe\"}[5m])","timeRangeSeconds":3600,"avgDurationSeconds":0.007,"count":1},{"query":"changes(process_start_time_seconds{ ins=~\"alertmanager-1\"}[2m]) > 0","timeRangeSeconds":10800,"avgDurationSeconds":0.007,"count":1},{"query":"- absent(node_network_speed_bytes{ip=\"10.31.13.3\"}) OR max by (ins) (node_network_speed_bytes{ip=\"10.31.13.3\"}) * 8","timeRangeSeconds":0,"avgDurationSeconds":0.006,"count":1},{"query":"pg:table:scan_rate1m{ins=\"pg-meta-1\", datname=\"pgweb\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.006,"count":1},{"query":"pg_table_age{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pgext.universe\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.006,"count":1},{"query":"rate(pg_query_exec_time{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-4426219414945232276\"}[1m]) /\n rate(pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-4426219414945232276\"}[1m])","timeRangeSeconds":3600,"avgDurationSeconds":0.006,"count":2},{"query":"ALERTS{cls=\"pg-meta\", alertstate=\"firing\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.006,"count":1}],"topBySumDuration":[{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"sumDurationSeconds":0.132,"count":60},{"query":"rate(pg_db_xact_commit[15m])","timeRangeSeconds":0,"sumDurationSeconds":0.054,"count":12},{"query":"deriv(node:fs:avail_bytes[1h])","timeRangeSeconds":0,"sumDurationSeconds":0.050,"count":13},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"sumDurationSeconds":0.049,"count":25},{"query":"max by (datname, query) (pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\"}) > 0","timeRangeSeconds":0,"sumDurationSeconds":0.027,"count":1},{"query":"max by (query) (pg_query_wal_bytes{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"sumDurationSeconds":0.024,"count":1},{"query":"avg_over_time(node:cpu:usage[15m])","timeRangeSeconds":0,"sumDurationSeconds":0.020,"count":13},{"query":"rate(pg_db_xact_rollback[15m])","timeRangeSeconds":0,"sumDurationSeconds":0.020,"count":9},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"sumDurationSeconds":0.019,"count":11},{"query":"up{job=\"infra\"}","timeRangeSeconds":0,"sumDurationSeconds":0.018,"count":2},{"query":"rate(pg_db_active_time[15m])","timeRangeSeconds":0,"sumDurationSeconds":0.017,"count":10},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.017,"count":14},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.017,"count":8},{"query":"max by (query) (pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"sumDurationSeconds":0.017,"count":1},{"query":"pgbouncer_database_pool_size{datname!=\"pgbouncer\"} + pgbouncer_database_reserve_pool{datname!=\"pgbouncer\"}","timeRangeSeconds":0,"sumDurationSeconds":0.015,"count":6},{"query":"max by (query) (pg:query:call_rate1m{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"sumDurationSeconds":0.014,"count":1},{"query":"sum without (type, client_api_version) (increase(etcd_server_client_requests_total{job=\"etcd\"}[1m]))","timeRangeSeconds":0,"sumDurationSeconds":0.012,"count":3},{"query":"max by (query) (pg_query_exec_time{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"sumDurationSeconds":0.012,"count":1},{"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,"sumDurationSeconds":0.012,"count":1},{"query":"rate(pg_query_exec_time{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-4426219414945232276\"}[1m]) /\n rate(pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-4426219414945232276\"}[1m])","timeRangeSeconds":3600,"sumDurationSeconds":0.011,"count":2}],"topByAvgMemoryUsage":[{"query":"pg:table:scan_rate1m{ins=\"pg-meta-1\", datname=\"meta\"}","timeRangeSeconds":3600,"avgMemoryBytes":277816,"count":1},{"query":"pg:table:scan_rate1m{ins=\"pg-meta-1\", datname=\"pgweb\"}","timeRangeSeconds":3600,"avgMemoryBytes":276616,"count":1},{"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":14},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"avgMemoryBytes":113792,"count":6},{"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:scan_rate1m{ins=\"pg-meta-1\", datname=\"pgweb\"})","timeRangeSeconds":0,"avgMemoryBytes":72136,"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_size_bytes{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgMemoryBytes":70104,"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 (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:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"avgMemoryBytes":46736,"count":1},{"query":"max by (query) (pg:query:call_rate1m{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"avgMemoryBytes":46736,"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":"ALERTS{cls=\"pg-meta\", alertstate=\"firing\"}","timeRangeSeconds":3600,"avgMemoryBytes":37608,"count":1},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"avgMemoryBytes":32512,"count":11},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"avgMemoryBytes":32512,"count":8},{"query":"ALERTS{cls=\"pg-meta\", alertstate=\"pending\"} ","timeRangeSeconds":3600,"avgMemoryBytes":25072,"count":1}]}