{"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_table_tbl_scan[1m])","timeRangeSeconds":0,"count":6},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"count":4},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"count":4},{"query":"rate(node_schedstat_waiting_seconds_total[1m])","timeRangeSeconds":0,"count":2},{"query":"pg:db:xact_commit_rate1m{ins=\"pg-meta-1\", datname=\"meta\"}","timeRangeSeconds":10800,"count":1},{"query":"stddev_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[5m]) /\navg_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[5m])","timeRangeSeconds":43200,"count":1},{"query":"max by (query) (pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"count":1},{"query":"pg:db:conn_usage{ins=\"pg-meta-1\", datname=\"meta\"}","timeRangeSeconds":10800,"count":1},{"query":"pg:db:xact_commit_rate1m{ins=\"pg-meta-1\"}","timeRangeSeconds":10800,"count":1},{"query":"sum without(datname) (pg:db:xact_rollback_rate1m)","timeRangeSeconds":0,"count":1},{"query":"max by (query) (pg:query:call_rate1m{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"count":1},{"query":"rate(pg_db_xact_commit[15m])","timeRangeSeconds":0,"count":1},{"query":"sum(rate(pg_db_temp_bytes{ins=\"pg-meta-1\", datname=\"meta\"}[5m]))","timeRangeSeconds":10800,"count":1},{"query":"sum by (datname) (pg_size_bytes{ins=\"pg-meta-1\", datname!~\"wal|log\"})","timeRangeSeconds":0,"count":1},{"query":"pg:db:age{ins=\"pg-meta-1\"}","timeRangeSeconds":10800,"count":1},{"query":"pg:db:xact_rollback_rate1m{ins=\"pg-meta-1\", datname=\"meta\"}","timeRangeSeconds":10800,"count":1},{"query":"pgbouncer_database_pool_size{datname!=\"pgbouncer\"} + pgbouncer_database_reserve_pool{datname!=\"pgbouncer\"}","timeRangeSeconds":0,"count":1},{"query":"max by (query) (pg_query_wal_bytes{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"count":1},{"query":"max by (datname, query) (pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\"}) > 0","timeRangeSeconds":0,"count":1}],"topByAvgDuration":[{"query":"sum by (ip) (haproxy_backend_current_sessions{cls=\"pg-meta\"})","timeRangeSeconds":0,"avgDurationSeconds":0.010,"count":1},{"query":"sum(node:fs:size_bytes{cls=\"pg-meta\", fstype!~\"fuse.juicefs\"}) by (ip) / 1073741824","timeRangeSeconds":0,"avgDurationSeconds":0.009,"count":1},{"query":"count by (ip) (up{cls=\"pg-meta\"})","timeRangeSeconds":0,"avgDurationSeconds":0.006,"count":1},{"query":"pgbouncer_database_reserve_pool{datname!=\"pgbouncer\"}","timeRangeSeconds":0,"avgDurationSeconds":0.006,"count":1},{"query":"pg_db_numbackends{ins=\"pg-meta-1\",datname=\"meta\"}","timeRangeSeconds":10800,"avgDurationSeconds":0.005,"count":1},{"query":"increase(pg_query_exec_time{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[1m]) /\n increase(pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[1m])","timeRangeSeconds":43200,"avgDurationSeconds":0.005,"count":1},{"query":"stddev_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[5m]) /\navg_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[5m])","timeRangeSeconds":43200,"avgDurationSeconds":0.004,"count":1},{"query":"sum by (relname) (pg_table_idx_scan{ins=\"pg-meta-1\", datname=\"meta\"}) \n+ sum by (relname) (pg_table_seq_scan{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":1},{"query":"increase(pg_query_exec_time{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[5m]) /\n increase(pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[5m])","timeRangeSeconds":43200,"avgDurationSeconds":0.004,"count":1},{"query":"avg_over_time(node:cpu:usage[5m])","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":1},{"query":"sum by (ins,proxy) (haproxy_server_status{state=\"UP\", proxy!=\u0027stats\u0027}) > bool 0","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":1},{"query":"rate(pg_query_exec_time{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[1m]) /\n rate(pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[1m])","timeRangeSeconds":43200,"avgDurationSeconds":0.003,"count":1},{"query":"sum by (datname) (pg_activity_count{ins=\"pg-meta-1\"})","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":1},{"query":"max by (query) (pg_query_exec_time{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"rate(pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[1m])","timeRangeSeconds":43200,"avgDurationSeconds":0.002,"count":1},{"query":"max by (datname, query) (pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\"}) > 0","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"max(node:fs:space_usage{cls=\"pg-meta\"})","timeRangeSeconds":10800,"avgDurationSeconds":0.002,"count":1},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":4},{"query":"max by (query) (pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\"})","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}],"topBySumDuration":[{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"sumDurationSeconds":0.111,"count":60},{"query":"sum by (ip) (haproxy_backend_current_sessions{cls=\"pg-meta\"})","timeRangeSeconds":0,"sumDurationSeconds":0.010,"count":1},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.009,"count":4},{"query":"sum(node:fs:size_bytes{cls=\"pg-meta\", fstype!~\"fuse.juicefs\"}) by (ip) / 1073741824","timeRangeSeconds":0,"sumDurationSeconds":0.009,"count":1},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.009,"count":6},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.006,"count":4},{"query":"count by (ip) (up{cls=\"pg-meta\"})","timeRangeSeconds":0,"sumDurationSeconds":0.006,"count":1},{"query":"pgbouncer_database_reserve_pool{datname!=\"pgbouncer\"}","timeRangeSeconds":0,"sumDurationSeconds":0.006,"count":1},{"query":"pg_db_numbackends{ins=\"pg-meta-1\",datname=\"meta\"}","timeRangeSeconds":10800,"sumDurationSeconds":0.005,"count":1},{"query":"increase(pg_query_exec_time{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[1m]) /\n increase(pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[1m])","timeRangeSeconds":43200,"sumDurationSeconds":0.005,"count":1},{"query":"stddev_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[5m]) /\navg_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[5m])","timeRangeSeconds":43200,"sumDurationSeconds":0.004,"count":1},{"query":"sum by (relname) (pg_table_idx_scan{ins=\"pg-meta-1\", datname=\"meta\"}) \n+ sum by (relname) (pg_table_seq_scan{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"sumDurationSeconds":0.004,"count":1},{"query":"increase(pg_query_exec_time{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[5m]) /\n increase(pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[5m])","timeRangeSeconds":43200,"sumDurationSeconds":0.004,"count":1},{"query":"avg_over_time(node:cpu:usage[5m])","timeRangeSeconds":0,"sumDurationSeconds":0.003,"count":1},{"query":"sum by (ins,proxy) (haproxy_server_status{state=\"UP\", proxy!=\u0027stats\u0027}) > bool 0","timeRangeSeconds":0,"sumDurationSeconds":0.003,"count":1},{"query":"rate(pg_query_exec_time{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[1m]) /\n rate(pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[1m])","timeRangeSeconds":43200,"sumDurationSeconds":0.003,"count":1},{"query":"rate(node_schedstat_waiting_seconds_total[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.003,"count":2},{"query":"sum by (datname) (pg_activity_count{ins=\"pg-meta-1\"})","timeRangeSeconds":0,"sumDurationSeconds":0.003,"count":1},{"query":"max by (query) (pg_query_exec_time{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"sumDurationSeconds":0.002,"count":1},{"query":"rate(pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-6324036696618024559\"}[1m])","timeRangeSeconds":43200,"sumDurationSeconds":0.002,"count":1}],"topByAvgMemoryUsage":[{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"avgMemoryBytes":134112,"count":6},{"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":4},{"query":"pg:db:age{ins=\"pg-meta-1\"}","timeRangeSeconds":10800,"avgMemoryBytes":128072,"count":1},{"query":"pg:table:scan_rate1m{ins=\"pg-meta-1\", datname=\"meta\"}","timeRangeSeconds":10800,"avgMemoryBytes":81816,"count":1},{"query":"pg:query:call_rate1m{ins=\"pg-meta-1\", datname=\"meta\"}","timeRangeSeconds":10800,"avgMemoryBytes":66232,"count":1},{"query":"pg:db:ixact_backends{datname!~\"template0|template1\"}","timeRangeSeconds":3600,"avgMemoryBytes":62680,"count":1},{"query":"pg:db:xact_commit_rate1m{ins=\"pg-meta-1\"}","timeRangeSeconds":10800,"avgMemoryBytes":47432,"count":1},{"query":"max by (query) (pg:query:rt_1m{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 (query) (pg:query:call_rate1m{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_exec_time{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":1},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"avgMemoryBytes":32512,"count":4},{"query":"sum by (datname) (pg_activity_count{ins=\"pg-meta-1\"})","timeRangeSeconds":0,"avgMemoryBytes":30480,"count":1},{"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 (relname) (pg_table_idx_scan{ins=\"pg-meta-1\", datname=\"meta\"}) \n+ sum by (relname) (pg_table_seq_scan{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgMemoryBytes":21336,"count":1},{"query":"max by (datname, query) (pg_query_calls{ins=\"pg-meta-1\", datname=\"meta\"}) > 0","timeRangeSeconds":0,"avgMemoryBytes":17272,"count":1}]}