{"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":24},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"count":16},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"count":10},{"query":"pgbouncer_database_pool_size{datname!=\"pgbouncer\"} + pgbouncer_database_reserve_pool{datname!=\"pgbouncer\"}","timeRangeSeconds":0,"count":10},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"count":7},{"query":"pg:db:ixact_time_rate15m / (pg:db:active_time_rate15m + pg:db:ixact_time_rate15m)","timeRangeSeconds":0,"count":4},{"query":"pg:db:ixact_time_rate5m / (pg:db:active_time_rate5m + pg:db:ixact_time_rate5m)","timeRangeSeconds":0,"count":3},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"count":2},{"query":"pg:db:ixact_time_rate1m / (pg:db:active_time_rate1m + pg:db:ixact_time_rate1m)","timeRangeSeconds":0,"count":2},{"query":"avg by (cls, job) (node:cpu:usage)","timeRangeSeconds":0,"count":2},{"query":"sum without(datname) (pg:db:xact_total_rate1m)","timeRangeSeconds":0,"count":2},{"query":"histogram_quantile(0.95, rate(etcd_disk_backend_commit_duration_seconds_bucket{job=\"etcd\"}[5m]))","timeRangeSeconds":0,"count":2},{"query":"sum without (mode) (pg_lock_count{mode!~\"AccessShareLock|RowShareLock|RowExclusiveLock\"})","timeRangeSeconds":0,"count":2},{"query":"sum by (datname) (pg_activity_count{cls=\"pg-meta\"})","timeRangeSeconds":0,"count":1},{"query":"avg without (cpu) (node:cpu:sched_wait_rate1m)","timeRangeSeconds":0,"count":1},{"query":"sum(node:fs:size_bytes{cls=\"pg-meta\", fstype!~\"fuse.juicefs\"}) by (ip) / 1073741824","timeRangeSeconds":0,"count":1},{"query":"sum(rate(pg_db_tup_deleted{ins=\"pg-meta-1\"}[5m]))","timeRangeSeconds":43200,"count":1},{"query":"sum by (ins,datname) (pg_db_numbackends{cls=\"pg-meta\", datname!~\"wal|log|template\\\\d\"})","timeRangeSeconds":43200,"count":1},{"query":"histogram_quantile(0.95, rate(etcd_disk_wal_fsync_duration_seconds_bucket{job=\"etcd\"}[5m]))","timeRangeSeconds":0,"count":1}],"topByAvgDuration":[{"query":"sum(rate(pg_db_tup_updated{ins=\"pg-meta-1\"}[5m]))","timeRangeSeconds":43200,"avgDurationSeconds":0.014,"count":1},{"query":"sum by (ins,instance) (haproxy_backend_current_sessions{cls=\"pg-meta\", proxy!=\"stats\"})","timeRangeSeconds":0,"avgDurationSeconds":0.011,"count":1},{"query":"sum by (datname) (pg:db:xact_commit_rate1m{cls=\"pg-meta\"})","timeRangeSeconds":0,"avgDurationSeconds":0.008,"count":1},{"query":"max by (datname) (pg:db:age{cls=\"pg-meta\"})","timeRangeSeconds":0,"avgDurationSeconds":0.008,"count":1},{"query":"sum by (datname) (pg_activity_count{cls=\"pg-meta\"})","timeRangeSeconds":0,"avgDurationSeconds":0.006,"count":1},{"query":"sum(rate(pg_db_tup_deleted{ins=\"pg-meta-1\"}[5m]))","timeRangeSeconds":43200,"avgDurationSeconds":0.004,"count":1},{"query":"sum(rate(pg_db_tup_inserted{ins=\"pg-meta-1\"}[5m]))","timeRangeSeconds":43200,"avgDurationSeconds":0.003,"count":1},{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":60},{"query":"max by (ins) (pg_activity_max_tx_duration{cls=\"pg-meta\", ins=\"pg-meta-1\", state=\"active\"})","timeRangeSeconds":43200,"avgDurationSeconds":0.003,"count":1},{"query":"max by (datname,host) (pgbouncer_database_pool_size{cls=\"pg-meta\", datname!=\"pgbouncer\"} + pgbouncer_database_reserve_pool{cls=\"pg-meta\", datname!=\"pgbouncer\"})","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":1},{"query":"rate(pg_db_tup_deleted[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":1},{"query":"avg without (cpu) (node:cpu:usage)","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":1},{"query":"node:dev:network_tx_bytes_rate1m + node:dev:network_rx_bytes_rate1m","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"sum without (type, client_api_version) (increase(etcd_server_client_requests_total{job=\"etcd\"}[1m]))","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"sum(pg:db:xact_rollback_rate1m{cls=\"pg-meta\", datname=\"meta_2\"})","timeRangeSeconds":43200,"avgDurationSeconds":0.002,"count":1},{"query":"sum(node:fs:size_bytes{cls=\"pg-meta\", fstype!~\"fuse.juicefs\"}) by (ip) / 1073741824","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"sum without (datname) (pg_lock_count)","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"sum by (ins,datname) (pg_db_numbackends{cls=\"pg-meta\", datname!~\"wal|log|template\\\\d\"})","timeRangeSeconds":43200,"avgDurationSeconds":0.002,"count":1},{"query":"sum without (device) (node:dev:network_rx_pps1m{device!~\"lo|bond.*\"})","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"up{job=\"infra\"}","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1}],"topBySumDuration":[{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"sumDurationSeconds":0.169,"count":60},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.029,"count":24},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.018,"count":16},{"query":"sum(rate(pg_db_tup_updated{ins=\"pg-meta-1\"}[5m]))","timeRangeSeconds":43200,"sumDurationSeconds":0.014,"count":1},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"sumDurationSeconds":0.012,"count":7},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"sumDurationSeconds":0.012,"count":10},{"query":"pgbouncer_database_pool_size{datname!=\"pgbouncer\"} + pgbouncer_database_reserve_pool{datname!=\"pgbouncer\"}","timeRangeSeconds":0,"sumDurationSeconds":0.012,"count":10},{"query":"sum by (ins,instance) (haproxy_backend_current_sessions{cls=\"pg-meta\", proxy!=\"stats\"})","timeRangeSeconds":0,"sumDurationSeconds":0.011,"count":1},{"query":"sum by (datname) (pg:db:xact_commit_rate1m{cls=\"pg-meta\"})","timeRangeSeconds":0,"sumDurationSeconds":0.008,"count":1},{"query":"max by (datname) (pg:db:age{cls=\"pg-meta\"})","timeRangeSeconds":0,"sumDurationSeconds":0.008,"count":1},{"query":"sum by (datname) (pg_activity_count{cls=\"pg-meta\"})","timeRangeSeconds":0,"sumDurationSeconds":0.006,"count":1},{"query":"pg:db:ixact_time_rate15m / (pg:db:active_time_rate15m + pg:db:ixact_time_rate15m)","timeRangeSeconds":0,"sumDurationSeconds":0.005,"count":4},{"query":"sum(rate(pg_db_tup_deleted{ins=\"pg-meta-1\"}[5m]))","timeRangeSeconds":43200,"sumDurationSeconds":0.004,"count":1},{"query":"avg by (cls, job) (node:cpu:usage)","timeRangeSeconds":0,"sumDurationSeconds":0.004,"count":2},{"query":"pg:db:ixact_time_rate5m / (pg:db:active_time_rate5m + pg:db:ixact_time_rate5m)","timeRangeSeconds":0,"sumDurationSeconds":0.003,"count":3},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.003,"count":2},{"query":"sum(rate(pg_db_tup_inserted{ins=\"pg-meta-1\"}[5m]))","timeRangeSeconds":43200,"sumDurationSeconds":0.003,"count":1},{"query":"max by (ins) (pg_activity_max_tx_duration{cls=\"pg-meta\", ins=\"pg-meta-1\", state=\"active\"})","timeRangeSeconds":43200,"sumDurationSeconds":0.003,"count":1},{"query":"max by (datname,host) (pgbouncer_database_pool_size{cls=\"pg-meta\", datname!=\"pgbouncer\"} + pgbouncer_database_reserve_pool{cls=\"pg-meta\", datname!=\"pgbouncer\"})","timeRangeSeconds":0,"sumDurationSeconds":0.003,"count":1},{"query":"rate(pg_db_tup_deleted[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.003,"count":1}],"topByAvgMemoryUsage":[{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"avgMemoryBytes":134112,"count":16},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"avgMemoryBytes":130048,"count":24},{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"avgMemoryBytes":130048,"count":60},{"query":"sum without (datname) (pg_lock_count)","timeRangeSeconds":0,"avgMemoryBytes":40640,"count":1},{"query":"max by (ins) (pg_activity_max_tx_duration{cls=\"pg-meta\", ins=\"pg-meta-1\", state=\"active\"})","timeRangeSeconds":43200,"avgMemoryBytes":33880,"count":1},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"avgMemoryBytes":32512,"count":7},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"avgMemoryBytes":32512,"count":2},{"query":"sum by (datname) (pg_activity_count{cls=\"pg-meta\"})","timeRangeSeconds":0,"avgMemoryBytes":30480,"count":1},{"query":"sum without (mode) (pg_lock_count{mode!~\"AccessShareLock|RowShareLock|RowExclusiveLock\"})","timeRangeSeconds":0,"avgMemoryBytes":25400,"count":2},{"query":"sum by (ins,datname) (pg_db_numbackends{cls=\"pg-meta\", datname!~\"wal|log|template\\\\d\"})","timeRangeSeconds":43200,"avgMemoryBytes":16600,"count":1},{"query":"sum(rate(pg_db_tup_deleted{ins=\"pg-meta-1\"}[5m]))","timeRangeSeconds":43200,"avgMemoryBytes":15584,"count":1},{"query":"sum(rate(pg_db_tup_updated{ins=\"pg-meta-1\"}[5m]))","timeRangeSeconds":43200,"avgMemoryBytes":15584,"count":1},{"query":"sum(rate(pg_db_tup_inserted{ins=\"pg-meta-1\"}[5m]))","timeRangeSeconds":43200,"avgMemoryBytes":15584,"count":1},{"query":"histogram_quantile(0.95, rate(etcd_disk_backend_commit_duration_seconds_bucket{job=\"etcd\"}[5m]))","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":"count by (ip) (up{cls=\"pg-meta\"})","timeRangeSeconds":0,"avgMemoryBytes":9144,"count":1},{"query":"up{job=\"infra\"}","timeRangeSeconds":0,"avgMemoryBytes":8128,"count":1},{"query":"pg:db:ixact_time_rate1m / (pg:db:active_time_rate1m + pg:db:ixact_time_rate1m)","timeRangeSeconds":0,"avgMemoryBytes":7112,"count":2},{"query":"rate(pg_db_tup_deleted[1m])","timeRangeSeconds":0,"avgMemoryBytes":7112,"count":1},{"query":"max by (datname) (pg_db_is_template{cls=\"pg-meta\", ins=\"pg-meta-1\"})","timeRangeSeconds":0,"avgMemoryBytes":7112,"count":1}]}