{"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":14},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"count":6},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"count":4},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"count":4},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"count":3},{"query":"pgbouncer_database_pool_size{datname!=\"pgbouncer\"} + pgbouncer_database_reserve_pool{datname!=\"pgbouncer\"}","timeRangeSeconds":0,"count":2},{"query":"rate(pg_table_idx_scan{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.db_engine\"}[5m])","timeRangeSeconds":3600,"count":2},{"query":"histogram_quantile(0.95, rate(etcd_disk_backend_commit_duration_seconds_bucket{job=\"etcd\"}[5m]))","timeRangeSeconds":0,"count":2},{"query":"pgbouncer:db:pool_current_conn / pgbouncer:db:pool_size","timeRangeSeconds":0,"count":1},{"query":"pgbouncer_database_reserve_pool{datname!=\"pgbouncer\"}","timeRangeSeconds":0,"count":1},{"query":"pg_table_size_bytes{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.db_engine\"}","timeRangeSeconds":3600,"count":1},{"query":"(pg_db_conn_limit != -1 ) or (0 * pg_db_conn_limit + on(cls, ins) group_left pg_setting_max_connections)","timeRangeSeconds":0,"count":1},{"query":"histogram_quantile(0.95, rate(etcd_disk_wal_fsync_duration_seconds_bucket{job=\"etcd\"}[5m]))","timeRangeSeconds":0,"count":1},{"query":"min by (ins,ip) (up{job=\"pgsql\", cls=\"pg-meta\"})","timeRangeSeconds":0,"count":1},{"query":"pg_table_relid{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.db_engine\"}","timeRangeSeconds":3600,"count":1},{"query":"rate(pg_table_n_tup_mod{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.db_engine\"}[1m])","timeRangeSeconds":3600,"count":1},{"query":"pg_table_tuples{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.db_engine\"}","timeRangeSeconds":3600,"count":1},{"query":"pg:table:scan_rate1m{ins=\"pg-meta-1\", datname=\"meta\"}","timeRangeSeconds":3600,"count":1},{"query":"pgbouncer_database_current_connections{datname!=\"pgbouncer\"}","timeRangeSeconds":0,"count":1}],"topByAvgDuration":[{"query":"rate(pg_table_tup_read{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.db_engine\"}[1m])","timeRangeSeconds":3600,"avgDurationSeconds":0.011,"count":1},{"query":"pg_table_size_bytes{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.db_engine\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.010,"count":1},{"query":"pg_table_tuples{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.db_engine\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.010,"count":1},{"query":"pg_table_n_tup_mod{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.db_engine\"}\n/( 1 + pg_table_tup_read{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.db_engine\"})","timeRangeSeconds":3600,"avgDurationSeconds":0.009,"count":1},{"query":"rate(pg_table_n_tup_mod{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.db_engine\"}[1m])","timeRangeSeconds":3600,"avgDurationSeconds":0.009,"count":1},{"query":"pg_table_ncols{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.db_engine\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.008,"count":1},{"query":"pg_table_age{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.db_engine\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.007,"count":1},{"query":"sum by (ins,instance) (haproxy_backend_current_sessions{cls=\"pg-meta\", proxy!=\"stats\"})","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":1},{"query":"sum by (relname) (pg:table:scan_rate1m{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":1},{"query":"rate(pg_table_seq_scan{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.db_engine\"}[5m])","timeRangeSeconds":3600,"avgDurationSeconds":0.003,"count":1},{"query":"min by (ins,ip) (up{job=\"pgsql\", cls=\"pg-meta\"})","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":1},{"query":"sum by (relname) (pg_table_size_bytes{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"avg_over_time(node:cpu:usage[15m])","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"histogram_quantile(0.95, rate(etcd_disk_wal_fsync_duration_seconds_bucket{job=\"etcd\"}[5m]))","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"pgbouncer_database_reserve_pool{datname!=\"pgbouncer\"}","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":14},{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":60},{"query":"(pg_db_conn_limit != -1 ) or (0 * pg_db_conn_limit + on(cls, ins) group_left pg_setting_max_connections)","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"sum by (relname) (pg_table_n_live_tup{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"histogram_quantile(0.95, rate(etcd_disk_backend_commit_duration_seconds_bucket{job=\"etcd\"}[5m]))","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":2}],"topBySumDuration":[{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"sumDurationSeconds":0.116,"count":60},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.027,"count":14},{"query":"rate(pg_table_tup_read{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.db_engine\"}[1m])","timeRangeSeconds":3600,"sumDurationSeconds":0.011,"count":1},{"query":"pg_table_size_bytes{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.db_engine\"}","timeRangeSeconds":3600,"sumDurationSeconds":0.010,"count":1},{"query":"pg_table_tuples{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.db_engine\"}","timeRangeSeconds":3600,"sumDurationSeconds":0.010,"count":1},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.009,"count":6},{"query":"pg_table_n_tup_mod{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.db_engine\"}\n/( 1 + pg_table_tup_read{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.db_engine\"})","timeRangeSeconds":3600,"sumDurationSeconds":0.009,"count":1},{"query":"rate(pg_table_n_tup_mod{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.db_engine\"}[1m])","timeRangeSeconds":3600,"sumDurationSeconds":0.009,"count":1},{"query":"pg_table_ncols{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.db_engine\"}","timeRangeSeconds":3600,"sumDurationSeconds":0.008,"count":1},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.007,"count":4},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"sumDurationSeconds":0.007,"count":4},{"query":"pg_table_age{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.db_engine\"}","timeRangeSeconds":3600,"sumDurationSeconds":0.007,"count":1},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"sumDurationSeconds":0.004,"count":3},{"query":"histogram_quantile(0.95, rate(etcd_disk_backend_commit_duration_seconds_bucket{job=\"etcd\"}[5m]))","timeRangeSeconds":0,"sumDurationSeconds":0.004,"count":2},{"query":"rate(pg_table_idx_scan{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.db_engine\"}[5m])","timeRangeSeconds":3600,"sumDurationSeconds":0.003,"count":2},{"query":"sum by (ins,instance) (haproxy_backend_current_sessions{cls=\"pg-meta\", proxy!=\"stats\"})","timeRangeSeconds":0,"sumDurationSeconds":0.003,"count":1},{"query":"sum by (relname) (pg:table:scan_rate1m{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"sumDurationSeconds":0.003,"count":1},{"query":"rate(pg_table_seq_scan{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.db_engine\"}[5m])","timeRangeSeconds":3600,"sumDurationSeconds":0.003,"count":1},{"query":"pgbouncer_database_pool_size{datname!=\"pgbouncer\"} + pgbouncer_database_reserve_pool{datname!=\"pgbouncer\"}","timeRangeSeconds":0,"sumDurationSeconds":0.003,"count":2},{"query":"min by (ins,ip) (up{job=\"pgsql\", cls=\"pg-meta\"})","timeRangeSeconds":0,"sumDurationSeconds":0.003,"count":1}],"topByAvgMemoryUsage":[{"query":"pg:table:scan_rate1m{ins=\"pg-meta-1\", datname=\"meta\"}","timeRangeSeconds":3600,"avgMemoryBytes":264264,"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":109728,"count":6},{"query":"sum by (relname) (pg_table_size_bytes{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgMemoryBytes":68072,"count":1},{"query":"sum by (relname) (pg:table:scan_rate1m{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgMemoryBytes":39624,"count":1},{"query":"sum by (relname) (pg_table_n_live_tup{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgMemoryBytes":39624,"count":1},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"avgMemoryBytes":32512,"count":4},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"avgMemoryBytes":32512,"count":4},{"query":"- node:dev:disk_write_bytes_rate1m{ip=\"10.31.13.3\"}","timeRangeSeconds":3600,"avgMemoryBytes":29816,"count":1},{"query":"avg_over_time(node:ins:cpu_usage{job=\"node\"}[1m])","timeRangeSeconds":10800,"avgMemoryBytes":18296,"count":1},{"query":"histogram_quantile(0.95, rate(etcd_disk_wal_fsync_duration_seconds_bucket{job=\"etcd\"}[5m]))","timeRangeSeconds":0,"avgMemoryBytes":15240,"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":"pg_table_ncols{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.db_engine\"}","timeRangeSeconds":3600,"avgMemoryBytes":12536,"count":1},{"query":"rate(pg_table_n_tup_mod{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.db_engine\"}[1m])","timeRangeSeconds":3600,"avgMemoryBytes":12536,"count":1},{"query":"pg_table_relid{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.db_engine\"}","timeRangeSeconds":3600,"avgMemoryBytes":12536,"count":1},{"query":"rate(pg_table_seq_scan{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.db_engine\"}[5m])","timeRangeSeconds":3600,"avgMemoryBytes":12536,"count":1},{"query":"pg_table_age{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.db_engine\"}","timeRangeSeconds":3600,"avgMemoryBytes":12536,"count":1},{"query":"pg_table_size_bytes{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.db_engine\"}","timeRangeSeconds":3600,"avgMemoryBytes":12536,"count":1},{"query":"rate(pg_table_tup_read{ins=\"pg-meta-1\", datname=\"meta\", relname=\"dbrank.db_engine\"}[1m])","timeRangeSeconds":3600,"avgMemoryBytes":12536,"count":1}]}