{"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":13},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"count":7},{"query":"pg:db:ixact_backends > 1","timeRangeSeconds":0,"count":2},{"query":"pg:db:conn_usage > 0.70","timeRangeSeconds":0,"count":2},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"count":2},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"count":2},{"query":"rate(pg_db_xact_commit[5m])","timeRangeSeconds":0,"count":1},{"query":"up{job=\"infra\"}","timeRangeSeconds":0,"count":1},{"query":"sum by (relname) (pg_table_n_live_tup{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"count":1},{"query":"rate(pg_table_idx_scan{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pglog.sample12\"}[5m])","timeRangeSeconds":3600,"count":1},{"query":"rate(pg_table_seq_scan{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pglog.sample12\"}[1m])","timeRangeSeconds":3600,"count":1},{"query":"pgbouncer_database_pool_size{datname!=\"pgbouncer\"} + pgbouncer_database_reserve_pool{datname!=\"pgbouncer\"}","timeRangeSeconds":0,"count":1},{"query":"rate(pg_db_xact_commit[15m])","timeRangeSeconds":0,"count":1},{"query":"count without (cpu) (node:cpu:usage)","timeRangeSeconds":0,"count":1},{"query":"pg_table_tuples{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pglog.sample12\"}","timeRangeSeconds":3600,"count":1},{"query":"rate(pg_table_tup_read{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pglog.sample12\"}[1m])","timeRangeSeconds":3600,"count":1},{"query":"sum by (datname) (pg_activity_count{ins=\"pg-meta-1\"})","timeRangeSeconds":0,"count":1},{"query":"sum by (datname) (pg_size_bytes{ins=\"pg-meta-1\", datname!~\"wal|log\"})","timeRangeSeconds":0,"count":1},{"query":"sum by (relname) (pg_table_size_bytes{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"count":1}],"topByAvgDuration":[{"query":"sum by (ins,instance) (haproxy_backend_current_sessions{cls=\"pg-meta\", proxy!=\"stats\"})","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":1},{"query":"pg_table_tuples{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pglog.sample12\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.003,"count":1},{"query":"pg:db:blk_read_time_seconds_rate1m + pg:db:blk_write_time_seconds_rate1m","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":1},{"query":"pg_table_relid{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pglog.sample12\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.003,"count":1},{"query":"sum by (relname) (pg_table_size_bytes{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":1},{"query":"pg_table_n_tup_mod{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pglog.sample12\"}\n/( 1 + pg_table_tup_read{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pglog.sample12\"})","timeRangeSeconds":3600,"avgDurationSeconds":0.003,"count":1},{"query":"sum by (relname) (pg:table:scan_rate1m{ins=\"pg-meta-1\", datname=\"meta\"})","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":"sum without (type, client_api_version) (increase(etcd_server_client_requests_total{job=\"etcd\"}[1m]))","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"count without (cpu) (node:cpu:usage)","timeRangeSeconds":0,"avgDurationSeconds":0.002,"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.002,"count":1},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":2},{"query":"rate(pg_db_xact_commit[15m])","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"sum by (datname) (pg_activity_count{ins=\"pg-meta-1\"})","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":"rate(node_network_receive_packets_total[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"rate(pg_db_xact_commit[5m])","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"rate(pg_table_seq_scan{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pglog.sample12\"}[1m])","timeRangeSeconds":3600,"avgDurationSeconds":0.002,"count":1},{"query":"rate(pg_table_n_tup_mod{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pglog.sample12\"}[1m])","timeRangeSeconds":3600,"avgDurationSeconds":0.002,"count":1},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":2}],"topBySumDuration":[{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"sumDurationSeconds":0.105,"count":60},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.019,"count":13},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"sumDurationSeconds":0.009,"count":7},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.004,"count":2},{"query":"sum by (ins,instance) (haproxy_backend_current_sessions{cls=\"pg-meta\", proxy!=\"stats\"})","timeRangeSeconds":0,"sumDurationSeconds":0.003,"count":1},{"query":"pg_table_tuples{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pglog.sample12\"}","timeRangeSeconds":3600,"sumDurationSeconds":0.003,"count":1},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.003,"count":2},{"query":"pg:db:ixact_backends > 1","timeRangeSeconds":0,"sumDurationSeconds":0.003,"count":2},{"query":"pg:db:conn_usage > 0.70","timeRangeSeconds":0,"sumDurationSeconds":0.003,"count":2},{"query":"pg:db:blk_read_time_seconds_rate1m + pg:db:blk_write_time_seconds_rate1m","timeRangeSeconds":0,"sumDurationSeconds":0.003,"count":1},{"query":"pg_table_relid{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pglog.sample12\"}","timeRangeSeconds":3600,"sumDurationSeconds":0.003,"count":1},{"query":"sum by (relname) (pg_table_size_bytes{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"sumDurationSeconds":0.003,"count":1},{"query":"pg_table_n_tup_mod{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pglog.sample12\"}\n/( 1 + pg_table_tup_read{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pglog.sample12\"})","timeRangeSeconds":3600,"sumDurationSeconds":0.003,"count":1},{"query":"sum by (relname) (pg:table:scan_rate1m{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"sumDurationSeconds":0.002,"count":1},{"query":"sum by (relname) (pg_table_n_live_tup{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"sumDurationSeconds":0.002,"count":1},{"query":"sum without (type, client_api_version) (increase(etcd_server_client_requests_total{job=\"etcd\"}[1m]))","timeRangeSeconds":0,"sumDurationSeconds":0.002,"count":1},{"query":"count without (cpu) (node:cpu:usage)","timeRangeSeconds":0,"sumDurationSeconds":0.002,"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.002,"count":1},{"query":"rate(pg_db_xact_commit[15m])","timeRangeSeconds":0,"sumDurationSeconds":0.002,"count":1},{"query":"sum by (datname) (pg_activity_count{ins=\"pg-meta-1\"})","timeRangeSeconds":0,"sumDurationSeconds":0.002,"count":1}],"topByAvgMemoryUsage":[{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"avgMemoryBytes":130048,"count":13},{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"avgMemoryBytes":130048,"count":60},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"avgMemoryBytes":91440,"count":2},{"query":"sum by (relname) (pg_table_size_bytes{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgMemoryBytes":50800,"count":1},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"avgMemoryBytes":32512,"count":1},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"avgMemoryBytes":32512,"count":2},{"query":"sum by (relname) (pg_table_n_live_tup{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgMemoryBytes":21336,"count":1},{"query":"sum by (relname) (pg:table:scan_rate1m{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgMemoryBytes":21336,"count":1},{"query":"sum by (datname) (pg_activity_count{ins=\"pg-meta-1\"})","timeRangeSeconds":0,"avgMemoryBytes":18288,"count":1},{"query":"up{job=\"infra\"}","timeRangeSeconds":0,"avgMemoryBytes":8128,"count":1},{"query":"rate(node_network_receive_packets_total[1m])","timeRangeSeconds":0,"avgMemoryBytes":8128,"count":1},{"query":"pg_table_relid{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pglog.sample12\"}","timeRangeSeconds":3600,"avgMemoryBytes":6776,"count":1},{"query":"rate(pg_table_seq_scan{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pglog.sample12\"}[1m])","timeRangeSeconds":3600,"avgMemoryBytes":6776,"count":1},{"query":"pg_table_tuples{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pglog.sample12\"}","timeRangeSeconds":3600,"avgMemoryBytes":6776,"count":1},{"query":"pg_table_n_tup_mod{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pglog.sample12\"}\n/( 1 + pg_table_tup_read{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pglog.sample12\"})","timeRangeSeconds":3600,"avgMemoryBytes":6776,"count":1},{"query":"rate(pg_table_idx_scan{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pglog.sample12\"}[5m])","timeRangeSeconds":3600,"avgMemoryBytes":6776,"count":1},{"query":"rate(pg_table_n_tup_mod{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pglog.sample12\"}[1m])","timeRangeSeconds":3600,"avgMemoryBytes":6776,"count":1},{"query":"rate(pg_table_tup_read{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pglog.sample12\"}[1m])","timeRangeSeconds":3600,"avgMemoryBytes":6776,"count":1},{"query":"rate(pg_db_xact_commit[15m])","timeRangeSeconds":0,"avgMemoryBytes":5080,"count":1},{"query":"pg:db:blk_read_time_seconds_rate1m + pg:db:blk_write_time_seconds_rate1m","timeRangeSeconds":0,"avgMemoryBytes":5080,"count":1}]}