{"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":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"count":9},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"count":6},{"query":"sum by (job, cls) (group by (job, cls, ins, ip) (up{cls!=\"\", ins!=\"\", job=\u0027pgsql\u0027}))","timeRangeSeconds":0,"count":2},{"query":"max by (query) (pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"count":2},{"query":"up{job=\"infra\"}","timeRangeSeconds":0,"count":2},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"count":2},{"query":"rate(pg_db_xact_rollback[15m])","timeRangeSeconds":0,"count":2},{"query":"sum(up{cls=\"vmetrics\"})","timeRangeSeconds":3600,"count":1},{"query":"rate(pg_db_xact_rollback[1m])","timeRangeSeconds":0,"count":1},{"query":"pgbouncer_database_paused{datname!=\"pgbouncer\"}","timeRangeSeconds":0,"count":1},{"query":"rate(pg_db_xact_total[15m])","timeRangeSeconds":0,"count":1},{"query":"sum(up{cls=\"nginx\"})","timeRangeSeconds":3600,"count":1},{"query":"sum(etcd_up{job=\"etcd\"}) by (cls) / count(etcd_up{job=\"etcd\"}) by (cls)","timeRangeSeconds":3600,"count":1},{"query":"histogram_quantile(0.95, rate(etcd_disk_wal_fsync_duration_seconds_bucket{job=\"etcd\"}[5m]))","timeRangeSeconds":0,"count":1},{"query":"sum(up{cls=\"vlogs\"})","timeRangeSeconds":3600,"count":1},{"query":"increase(pg_query_exec_time{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-4426219414945232276\"}[5m]) /\n increase(pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-4426219414945232276\"}[5m])","timeRangeSeconds":3600,"count":1},{"query":"count(ALERTS{alertstate=\"firing\"}) or on() vector(0)","timeRangeSeconds":3600,"count":1},{"query":"pgbouncer_database_pool_size{datname!=\"pgbouncer\"} + pgbouncer_database_reserve_pool{datname!=\"pgbouncer\"}","timeRangeSeconds":0,"count":1},{"query":"sum without (mode) (pg_lock_count{mode!~\"AccessShareLock|RowShareLock|RowExclusiveLock\"})","timeRangeSeconds":0,"count":1}],"topByAvgDuration":[{"query":"sum(up{cls=\"alertmanager\"})","timeRangeSeconds":3600,"avgDurationSeconds":0.004,"count":1},{"query":"sum(up{cls=\"vmetrics\"})","timeRangeSeconds":3600,"avgDurationSeconds":0.004,"count":1},{"query":"sum(up{cls=\"nginx\"})","timeRangeSeconds":3600,"avgDurationSeconds":0.004,"count":1},{"query":"avg by (cls) (rate(minio_node_process_cpu_total_seconds{job=\"minio\"}[1m]))","timeRangeSeconds":3600,"avgDurationSeconds":0.004,"count":1},{"query":"cls:pressure5{job=\"pgsql\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.004,"count":1},{"query":"sum(up{cls=\"vlogs\"})","timeRangeSeconds":3600,"avgDurationSeconds":0.004,"count":1},{"query":"pg:db:conn_usage > 0.70","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"pg:query:call_rate1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-4426219414945232276\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.002,"count":1},{"query":"count(ALERTS{alertstate=\"firing\"}) or on() vector(0)","timeRangeSeconds":3600,"avgDurationSeconds":0.002,"count":1},{"query":"up{job=\"infra\"}","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":2},{"query":"pgbouncer_database_paused{datname!=\"pgbouncer\"}","timeRangeSeconds":0,"avgDurationSeconds":0.002,"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.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=\"postgres\", query=\"-4426219414945232276\"}[5m]) /\navg_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-4426219414945232276\"}[5m])","timeRangeSeconds":3600,"avgDurationSeconds":0.002,"count":1},{"query":"rate(pg_db_xact_rollback[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"node:dev:network_tx_bytes_rate1m + node:dev:network_rx_bytes_rate1m","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"stddev_over_time(pg:query:call_rate1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-4426219414945232276\"}[5m]) /\navg_over_time(pg:query:call_rate1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-4426219414945232276\"}[5m])","timeRangeSeconds":3600,"avgDurationSeconds":0.002,"count":1},{"query":"pgbouncer:db:pool_current_conn / pgbouncer:db:pool_size","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"sum by (job, cls) (group by (job, cls, ins, ip) (up{cls!=\"\", ins!=\"\", job=\u0027pgsql\u0027}))","timeRangeSeconds":0,"avgDurationSeconds":0.001,"count":2},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.001,"count":6}],"topBySumDuration":[{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"sumDurationSeconds":0.112,"count":60},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.012,"count":9},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.009,"count":6},{"query":"sum(up{cls=\"alertmanager\"})","timeRangeSeconds":3600,"sumDurationSeconds":0.004,"count":1},{"query":"up{job=\"infra\"}","timeRangeSeconds":0,"sumDurationSeconds":0.004,"count":2},{"query":"sum(up{cls=\"vmetrics\"})","timeRangeSeconds":3600,"sumDurationSeconds":0.004,"count":1},{"query":"sum(up{cls=\"nginx\"})","timeRangeSeconds":3600,"sumDurationSeconds":0.004,"count":1},{"query":"avg by (cls) (rate(minio_node_process_cpu_total_seconds{job=\"minio\"}[1m]))","timeRangeSeconds":3600,"sumDurationSeconds":0.004,"count":1},{"query":"cls:pressure5{job=\"pgsql\"}","timeRangeSeconds":3600,"sumDurationSeconds":0.004,"count":1},{"query":"sum(up{cls=\"vlogs\"})","timeRangeSeconds":3600,"sumDurationSeconds":0.004,"count":1},{"query":"sum by (job, cls) (group by (job, cls, ins, ip) (up{cls!=\"\", ins!=\"\", job=\u0027pgsql\u0027}))","timeRangeSeconds":0,"sumDurationSeconds":0.003,"count":2},{"query":"max by (query) (pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"sumDurationSeconds":0.002,"count":2},{"query":"pg:db:conn_usage > 0.70","timeRangeSeconds":0,"sumDurationSeconds":0.002,"count":1},{"query":"pg:query:call_rate1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-4426219414945232276\"}","timeRangeSeconds":3600,"sumDurationSeconds":0.002,"count":1},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"sumDurationSeconds":0.002,"count":2},{"query":"rate(pg_db_xact_rollback[15m])","timeRangeSeconds":0,"sumDurationSeconds":0.002,"count":2},{"query":"count(ALERTS{alertstate=\"firing\"}) or on() vector(0)","timeRangeSeconds":3600,"sumDurationSeconds":0.002,"count":1},{"query":"pgbouncer_database_paused{datname!=\"pgbouncer\"}","timeRangeSeconds":0,"sumDurationSeconds":0.002,"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.002,"count":1},{"query":"stddev_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-4426219414945232276\"}[5m]) /\navg_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-4426219414945232276\"}[5m])","timeRangeSeconds":3600,"sumDurationSeconds":0.002,"count":1}],"topByAvgMemoryUsage":[{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"avgMemoryBytes":134112,"count":6},{"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":9},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"avgMemoryBytes":32512,"count":2},{"query":"sum without (mode) (pg_lock_count{mode!~\"AccessShareLock|RowShareLock|RowExclusiveLock\"})","timeRangeSeconds":0,"avgMemoryBytes":25400,"count":1},{"query":"max by (query) (pg:query:call_rate1m{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgMemoryBytes":16256,"count":1},{"query":"max by (query) (pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgMemoryBytes":15240,"count":2},{"query":"histogram_quantile(0.95, rate(etcd_disk_wal_fsync_duration_seconds_bucket{job=\"etcd\"}[5m]))","timeRangeSeconds":0,"avgMemoryBytes":15240,"count":1},{"query":"avg by (cls) (rate(minio_node_process_cpu_total_seconds{job=\"minio\"}[1m]))","timeRangeSeconds":3600,"avgMemoryBytes":12536,"count":1},{"query":"cls:pressure5{job=\"pgsql\"}","timeRangeSeconds":3600,"avgMemoryBytes":12536,"count":1},{"query":"sum(etcd_up{job=\"etcd\"}) by (cls) / count(etcd_up{job=\"etcd\"}) by (cls)","timeRangeSeconds":3600,"avgMemoryBytes":12536,"count":1},{"query":"up{job=\"infra\"}","timeRangeSeconds":0,"avgMemoryBytes":8128,"count":2},{"query":"count(ALERTS{alertstate=\"firing\"}) or on() vector(0)","timeRangeSeconds":3600,"avgMemoryBytes":7792,"count":1},{"query":"rate(pg_db_xact_rollback[1m])","timeRangeSeconds":0,"avgMemoryBytes":7112,"count":1},{"query":"rate(pg_db_xact_rollback[15m])","timeRangeSeconds":0,"avgMemoryBytes":7112,"count":2},{"query":"sum without(datname) (pg:db:tup_deleted_rate1m)","timeRangeSeconds":0,"avgMemoryBytes":7112,"count":1},{"query":"pg:db:conn_usage > 0.70","timeRangeSeconds":0,"avgMemoryBytes":7112,"count":1},{"query":"rate(pg_db_xact_total[15m])","timeRangeSeconds":0,"avgMemoryBytes":7112,"count":1},{"query":"increase(pg_query_exec_time{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-4426219414945232276\"}[15m]) /\n increase(pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-4426219414945232276\"}[15m])","timeRangeSeconds":3600,"avgMemoryBytes":6776,"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,"avgMemoryBytes":6776,"count":1}]}