{"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":18},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"count":7},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"count":6},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"count":6},{"query":"pgbouncer_database_pool_size{datname!=\"pgbouncer\"} + pgbouncer_database_reserve_pool{datname!=\"pgbouncer\"}","timeRangeSeconds":0,"count":4},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"count":2},{"query":"sum by (ins,instance) (haproxy_backend_current_sessions{cls=\"pg-meta\", proxy!=\"stats\"})","timeRangeSeconds":0,"count":2},{"query":"max by (datname, query) (pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\"}) > 0","timeRangeSeconds":0,"count":1},{"query":"node:ins:stdload5{ip=\"10.31.13.3\"}","timeRangeSeconds":3600,"count":1},{"query":"sum by (datname) (pg:db:xact_commit_rate1m{ins=\"pg-meta-1\"})","timeRangeSeconds":0,"count":1},{"query":"pg:db:conn_usage{ins=\"pg-meta-1\"}","timeRangeSeconds":3600,"count":1},{"query":"max by (query) (pg:query:call_rate1m{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"count":1},{"query":"group by (job, cls, ins, ip) (up{cls!=\"\", ins!=\"\", job=\u0027pgsql\u0027})","timeRangeSeconds":0,"count":1},{"query":"node:ins:stdload15{ip=\"10.31.13.3\"}","timeRangeSeconds":3600,"count":1},{"query":"node:dev:network_tx_bytes_rate1m + node:dev:network_rx_bytes_rate1m","timeRangeSeconds":0,"count":1},{"query":"rate(pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-8614649825449602022\"}[1m])","timeRangeSeconds":3600,"count":1},{"query":"max by (query) (pg_query_exec_time{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"count":1},{"query":"pg:db:blks_hit_1m / pg:db:blks_access_1m","timeRangeSeconds":0,"count":1},{"query":"max by (query) (pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"count":1}],"topByAvgDuration":[{"query":"max by (query) (pg_query_exec_time{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"avgDurationSeconds":0.009,"count":1},{"query":"max by (query) (pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"avgDurationSeconds":0.008,"count":1},{"query":"sum by (datname) (pg:db:xact_commit_rate1m{ins=\"pg-meta-1\"})","timeRangeSeconds":0,"avgDurationSeconds":0.008,"count":1},{"query":"max by (query) (pg:query:call_rate1m{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"avgDurationSeconds":0.005,"count":1},{"query":"pg:db:ixact_time_rate5m / (pg:db:active_time_rate5m + pg:db:ixact_time_rate5m)","timeRangeSeconds":0,"avgDurationSeconds":0.005,"count":1},{"query":"max by (datname) (1 - pg_db_is_template{ins=\"pg-meta-1\"} + pg_db_allow_conn{ins=\"pg-meta-1\"} * 2)","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":1},{"query":"max by (datname, query) (pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\"}) > 0","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":1},{"query":"sum by (datname) (pg_activity_count{ins=\"pg-meta-1\"})","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":1},{"query":"max by (query) (pg_query_wal_bytes{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":1},{"query":"node:ins:stdload15{ip=\"10.31.13.3\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.003,"count":1},{"query":"avg_over_time(node:cpu:usage[15m])","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":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":60},{"query":"avg_over_time(node:cpu:usage[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"group by (job, cls, ins, ip) (up{cls!=\"\", ins!=\"\", job=\u0027pgsql\u0027})","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"max by (datname) (pg:db:age{ins=\"pg-meta-1\"})","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":6},{"query":"sum without(datname) (pg_size_bytes)","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"sum without (mode) (pg_lock_count{mode!~\"AccessShareLock|RowShareLock|RowExclusiveLock\"})","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":2}],"topBySumDuration":[{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"sumDurationSeconds":0.129,"count":60},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.024,"count":18},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.011,"count":6},{"query":"max by (query) (pg_query_exec_time{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"sumDurationSeconds":0.009,"count":1},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"sumDurationSeconds":0.009,"count":6},{"query":"max by (query) (pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"sumDurationSeconds":0.008,"count":1},{"query":"sum by (datname) (pg:db:xact_commit_rate1m{ins=\"pg-meta-1\"})","timeRangeSeconds":0,"sumDurationSeconds":0.008,"count":1},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.007,"count":7},{"query":"max by (query) (pg:query:call_rate1m{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"sumDurationSeconds":0.005,"count":1},{"query":"pgbouncer_database_pool_size{datname!=\"pgbouncer\"} + pgbouncer_database_reserve_pool{datname!=\"pgbouncer\"}","timeRangeSeconds":0,"sumDurationSeconds":0.005,"count":4},{"query":"pg:db:ixact_time_rate5m / (pg:db:active_time_rate5m + pg:db:ixact_time_rate5m)","timeRangeSeconds":0,"sumDurationSeconds":0.005,"count":1},{"query":"max by (datname) (1 - pg_db_is_template{ins=\"pg-meta-1\"} + pg_db_allow_conn{ins=\"pg-meta-1\"} * 2)","timeRangeSeconds":0,"sumDurationSeconds":0.004,"count":1},{"query":"max by (datname, query) (pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\"}) > 0","timeRangeSeconds":0,"sumDurationSeconds":0.004,"count":1},{"query":"sum by (datname) (pg_activity_count{ins=\"pg-meta-1\"})","timeRangeSeconds":0,"sumDurationSeconds":0.004,"count":1},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"sumDurationSeconds":0.003,"count":2},{"query":"max by (query) (pg_query_wal_bytes{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"sumDurationSeconds":0.003,"count":1},{"query":"node:ins:stdload15{ip=\"10.31.13.3\"}","timeRangeSeconds":3600,"sumDurationSeconds":0.003,"count":1},{"query":"avg_over_time(node:cpu:usage[15m])","timeRangeSeconds":0,"sumDurationSeconds":0.002,"count":1},{"query":"sum by (ins,instance) (haproxy_backend_current_sessions{cls=\"pg-meta\", proxy!=\"stats\"})","timeRangeSeconds":0,"sumDurationSeconds":0.002,"count":2},{"query":"node:dev:network_tx_bytes_rate1m + node:dev:network_rx_bytes_rate1m","timeRangeSeconds":0,"sumDurationSeconds":0.002,"count":1}],"topByAvgMemoryUsage":[{"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":18},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"avgMemoryBytes":113792,"count":7},{"query":"pg:db:conn_usage{ins=\"pg-meta-1\"}","timeRangeSeconds":3600,"avgMemoryBytes":62680,"count":1},{"query":"max by (query) (pg:query:call_rate1m{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"avgMemoryBytes":45720,"count":1},{"query":"max by (query) (pg_query_exec_time{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"avgMemoryBytes":45720,"count":1},{"query":"max by (query) (pg_query_wal_bytes{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"avgMemoryBytes":45720,"count":1},{"query":"max by (datname, query) (pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\"}) > 0","timeRangeSeconds":0,"avgMemoryBytes":45720,"count":1},{"query":"max by (query) (pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"avgMemoryBytes":45720,"count":1},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"avgMemoryBytes":32512,"count":6},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"avgMemoryBytes":32512,"count":6},{"query":"node:ins:stdload15{ip=\"10.31.13.3\"}","timeRangeSeconds":3600,"avgMemoryBytes":29816,"count":1},{"query":"node:ins:stdload5{ip=\"10.31.13.3\"}","timeRangeSeconds":3600,"avgMemoryBytes":29816,"count":1},{"query":"sum by (datname) (pg_activity_count{ins=\"pg-meta-1\"})","timeRangeSeconds":0,"avgMemoryBytes":18288,"count":1},{"query":"histogram_quantile(0.95, rate(etcd_disk_backend_commit_duration_seconds_bucket{job=\"etcd\"}[5m]))","timeRangeSeconds":0,"avgMemoryBytes":15240,"count":1},{"query":"sum without (mode) (pg_lock_count{mode!~\"AccessShareLock|RowShareLock|RowExclusiveLock\"})","timeRangeSeconds":0,"avgMemoryBytes":15240,"count":1},{"query":"sum without(datname) (pg_size_bytes)","timeRangeSeconds":0,"avgMemoryBytes":7112,"count":1},{"query":"rate(pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-8614649825449602022\"}[1m])","timeRangeSeconds":3600,"avgMemoryBytes":6776,"count":1},{"query":"node:dev:network_tx_bytes_rate1m + node:dev:network_rx_bytes_rate1m","timeRangeSeconds":0,"avgMemoryBytes":6096,"count":1},{"query":"max by (datname) (pg:db:age{ins=\"pg-meta-1\"})","timeRangeSeconds":0,"avgMemoryBytes":5080,"count":1}]}