{"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":51},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"count":29},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"count":13},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"count":13},{"query":"deriv(node:fs:avail_bytes[1h])","timeRangeSeconds":0,"count":12},{"query":"deriv(pg_db_age[1h])","timeRangeSeconds":0,"count":12},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"count":10},{"query":"pg:db:ixact_time_rate1m / (pg:db:active_time_rate1m + pg:db:ixact_time_rate1m)","timeRangeSeconds":0,"count":8},{"query":"pg:db:age > 0.80","timeRangeSeconds":0,"count":6},{"query":"pg:db:conn_usage > 0.70","timeRangeSeconds":0,"count":3},{"query":"histogram_quantile(0.95, rate(etcd_disk_wal_fsync_duration_seconds_bucket{job=\"etcd\"}[5m]))","timeRangeSeconds":0,"count":3},{"query":"sum without(datname) (pg:db:xact_commit_rate1m)","timeRangeSeconds":0,"count":3},{"query":"pgbouncer_database_pool_size{datname!=\"pgbouncer\"} + pgbouncer_database_reserve_pool{datname!=\"pgbouncer\"}","timeRangeSeconds":0,"count":3},{"query":"sum without (type, client_api_version) (increase(etcd_server_client_requests_total{job=\"etcd\"}[1m]))","timeRangeSeconds":0,"count":2},{"query":"sum without (mode) (node:cpu:time_irate1m{mode=\"idle\"})","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) (pg_db_datid{ins=\"pg-meta-1\"})","timeRangeSeconds":0,"count":2},{"query":"min by (ins,ip) (up{job=\"pgsql\", cls=\"pg-meta\"})","timeRangeSeconds":0,"count":2},{"query":"node_filesystem_free_bytes{fstype!~\"(n|root|tmp)fs.*\"}","timeRangeSeconds":0,"count":2}],"topByAvgDuration":[{"query":"sum by (relname) (pg:table:scan_rate1m{ins=\"pg-meta-1\", datname=\"pgweb\"})","timeRangeSeconds":0,"avgDurationSeconds":0.027,"count":1},{"query":"max by (relname) (pg_table_size_bytes{ins=\"pg-meta-1\", datname=\"pgweb\"})","timeRangeSeconds":0,"avgDurationSeconds":0.026,"count":1},{"query":"max by (relname) (pg_table_n_live_tup{ins=\"pg-meta-1\", datname=\"pgweb\"})","timeRangeSeconds":0,"avgDurationSeconds":0.025,"count":1},{"query":"sum by (relname) (rate(pg_table_tup_read{ins=\"pg-meta-1\", datname=\"pgweb\"}[1m]))","timeRangeSeconds":0,"avgDurationSeconds":0.020,"count":1},{"query":"max by (relname, relid) (pg_table_relid{ins=\"pg-meta-1\"})","timeRangeSeconds":0,"avgDurationSeconds":0.018,"count":1},{"query":"sum by (relname) (pg_table_seq_scan{ins=\"pg-meta-1\", datname=\"pgweb\"})","timeRangeSeconds":0,"avgDurationSeconds":0.013,"count":1},{"query":"max by (datname) (pg_db_datid{ins=\"pg-meta-1\"})","timeRangeSeconds":0,"avgDurationSeconds":0.011,"count":2},{"query":"sum by (ins,instance) (haproxy_backend_current_sessions{cls=\"pg-meta\", proxy!=\"stats\"})","timeRangeSeconds":0,"avgDurationSeconds":0.011,"count":2},{"query":"nginx_connections_writing{ins=\"nginx-1\"}","timeRangeSeconds":43200,"avgDurationSeconds":0.009,"count":1},{"query":"sum by (relname) (rate(pg_table_n_tup_mod{ins=\"pg-meta-1\", datname=\"pgweb\"}[1m]))","timeRangeSeconds":0,"avgDurationSeconds":0.009,"count":1},{"query":"nginx_connections_reading{ins=\"nginx-1\"}","timeRangeSeconds":43200,"avgDurationSeconds":0.008,"count":1},{"query":"min by (ins,ip) (up{job=\"pgsql\", cls=\"pg-meta\"})","timeRangeSeconds":0,"avgDurationSeconds":0.008,"count":2},{"query":"max by (relname) (pg_table_n_dead_tup{ins=\"pg-meta-1\", datname=\"pgweb\"})","timeRangeSeconds":0,"avgDurationSeconds":0.008,"count":1},{"query":"rate(pg_table_idx_tup_fetch{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pgext.bin\"}[1m])","timeRangeSeconds":3600,"avgDurationSeconds":0.008,"count":1},{"query":"sum by (relname) (\n    pg:table:scan_rate1m{cls=\"pg-meta\", datname=\"pgweb\"}\n)","timeRangeSeconds":10800,"avgDurationSeconds":0.007,"count":1},{"query":"nginx_connections_waiting{ins=\"nginx-1\"}","timeRangeSeconds":43200,"avgDurationSeconds":0.007,"count":1},{"query":"irate(nginx_http_requests_total{ins=\"nginx-1\"}[5m])","timeRangeSeconds":43200,"avgDurationSeconds":0.007,"count":1},{"query":"irate(nginx_connections_accepted{ins=\"nginx-1\"}[5m])","timeRangeSeconds":43200,"avgDurationSeconds":0.007,"count":1},{"query":"nginx_connections_active{ins=\"nginx-1\"}","timeRangeSeconds":43200,"avgDurationSeconds":0.006,"count":1},{"query":"irate(node_disk_read_time_seconds_total{ip=~\"10.31.13.3\", device=~\u0027sda\u0027}[1m]) /\nirate(node_disk_reads_completed_total{ip=\"10.31.13.3\", device=~\u0027sda\u0027}[1m])","timeRangeSeconds":3600,"avgDurationSeconds":0.006,"count":1}],"topBySumDuration":[{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"sumDurationSeconds":0.141,"count":60},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"sumDurationSeconds":0.089,"count":51},{"query":"deriv(node:fs:avail_bytes[1h])","timeRangeSeconds":0,"sumDurationSeconds":0.065,"count":12},{"query":"deriv(pg_db_age[1h])","timeRangeSeconds":0,"sumDurationSeconds":0.052,"count":12},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.035,"count":29},{"query":"sum by (relname) (pg:table:scan_rate1m{ins=\"pg-meta-1\", datname=\"pgweb\"})","timeRangeSeconds":0,"sumDurationSeconds":0.027,"count":1},{"query":"max by (relname) (pg_table_size_bytes{ins=\"pg-meta-1\", datname=\"pgweb\"})","timeRangeSeconds":0,"sumDurationSeconds":0.026,"count":1},{"query":"max by (relname) (pg_table_n_live_tup{ins=\"pg-meta-1\", datname=\"pgweb\"})","timeRangeSeconds":0,"sumDurationSeconds":0.025,"count":1},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"sumDurationSeconds":0.025,"count":13},{"query":"max by (datname) (pg_db_datid{ins=\"pg-meta-1\"})","timeRangeSeconds":0,"sumDurationSeconds":0.021,"count":2},{"query":"sum by (ins,instance) (haproxy_backend_current_sessions{cls=\"pg-meta\", proxy!=\"stats\"})","timeRangeSeconds":0,"sumDurationSeconds":0.021,"count":2},{"query":"sum by (relname) (rate(pg_table_tup_read{ins=\"pg-meta-1\", datname=\"pgweb\"}[1m]))","timeRangeSeconds":0,"sumDurationSeconds":0.020,"count":1},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.020,"count":13},{"query":"max by (relname, relid) (pg_table_relid{ins=\"pg-meta-1\"})","timeRangeSeconds":0,"sumDurationSeconds":0.018,"count":1},{"query":"min by (ins,ip) (up{job=\"pgsql\", cls=\"pg-meta\"})","timeRangeSeconds":0,"sumDurationSeconds":0.016,"count":2},{"query":"sum by (relname) (pg_table_seq_scan{ins=\"pg-meta-1\", datname=\"pgweb\"})","timeRangeSeconds":0,"sumDurationSeconds":0.013,"count":1},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.012,"count":10},{"query":"sum without (type, client_api_version) (increase(etcd_server_client_requests_total{job=\"etcd\"}[1m]))","timeRangeSeconds":0,"sumDurationSeconds":0.012,"count":2},{"query":"pg:db:ixact_time_rate1m / (pg:db:active_time_rate1m + pg:db:ixact_time_rate1m)","timeRangeSeconds":0,"sumDurationSeconds":0.011,"count":8},{"query":"pg:db:conn_usage > 0.70","timeRangeSeconds":0,"sumDurationSeconds":0.011,"count":3}],"topByAvgMemoryUsage":[{"query":"sum by (relname) (\n    rate(pg_table_tup_read{cls=\"pg-meta\", datname=\"pgweb\"}[1m])\n)","timeRangeSeconds":10800,"avgMemoryBytes":481096,"count":1},{"query":"sum by (relname) (\n    pg:table:scan_rate1m{cls=\"pg-meta\", datname=\"pgweb\"}\n)","timeRangeSeconds":10800,"avgMemoryBytes":481096,"count":1},{"query":"pg:table:scan_rate1m{ins=\"pg-meta-1\", datname=\"meta\"}","timeRangeSeconds":3600,"avgMemoryBytes":218776,"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":29},{"query":"max by (relname, relid) (pg_table_relid{ins=\"pg-meta-1\"})","timeRangeSeconds":0,"avgMemoryBytes":113792,"count":1},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"avgMemoryBytes":113792,"count":10},{"query":"pg:db:active_time_rate1m{ins=\"pg-meta-1\", datname!~\u0027rdsadmin|polardb_admin|template\\\\d\u0027}","timeRangeSeconds":3600,"avgMemoryBytes":89448,"count":1},{"query":"max by (relname) (pg_table_size_bytes{ins=\"pg-meta-1\", datname=\"pgweb\"})","timeRangeSeconds":0,"avgMemoryBytes":73152,"count":1},{"query":"max by (relname) (pg_table_size_bytes{cls=\"pg-meta\", datname=\"pgweb\"})","timeRangeSeconds":0,"avgMemoryBytes":73152,"count":1},{"query":"sum by (relname) (pg_table_seq_scan{ins=\"pg-meta-1\", datname=\"pgweb\"})","timeRangeSeconds":0,"avgMemoryBytes":72136,"count":1},{"query":"sum by (relname) (rate(pg_table_tup_read{ins=\"pg-meta-1\", datname=\"pgweb\"}[1m]))","timeRangeSeconds":0,"avgMemoryBytes":72136,"count":1},{"query":"max 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:scan_rate1m{ins=\"pg-meta-1\", datname=\"pgweb\"})","timeRangeSeconds":0,"avgMemoryBytes":72136,"count":1},{"query":"max by (relname) (pg_table_n_dead_tup{ins=\"pg-meta-1\", datname=\"pgweb\"})","timeRangeSeconds":0,"avgMemoryBytes":72136,"count":1},{"query":"sum by (relname) (rate(pg_table_n_tup_mod{ins=\"pg-meta-1\", datname=\"pgweb\"}[1m]))","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":"increase(pg_db_temp_bytes{ins=\"pg-meta-1\"}[5m])","timeRangeSeconds":3600,"avgMemoryBytes":62680,"count":1},{"query":"sum by (relname) (pg:table:scan_rate1m{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgMemoryBytes":41656,"count":1},{"query":"sum by (relname) (pg_table_n_live_tup{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgMemoryBytes":41656,"count":1}]}