{"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":45},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"count":39},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"count":18},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"count":6},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"count":3},{"query":"pg:db:ixact_time_rate1m / (pg:db:active_time_rate1m + pg:db:ixact_time_rate1m)","timeRangeSeconds":0,"count":2},{"query":"stddev_over_time(pg:query:call_rate1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"816852380068164872\"}[5m]) /\navg_over_time(pg:query:call_rate1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"816852380068164872\"}[5m])","timeRangeSeconds":3600,"count":1},{"query":"max by (query) (pg:query:call_rate1m{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"count":1},{"query":"sum without (fstype, device, mountpoint) (node:fs:inode_used{fstype!~\"fuse.juicefs\"}) /\nsum without (fstype, device, mountpoint) (node:fs:inode_total{fstype!~\"fuse.juicefs\"})\n","timeRangeSeconds":0,"count":1},{"query":"sum without (mode) (pg_lock_count{mode!~\"AccessShareLock|RowShareLock|RowExclusiveLock\"})","timeRangeSeconds":0,"count":1},{"query":"max by (datname, query) (pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\"}) > 0","timeRangeSeconds":0,"count":1},{"query":"pg:ins:xact_commit_rate1m{ins=\"pg-meta-1\"}","timeRangeSeconds":3600,"count":1},{"query":"stddev_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"816852380068164872\"}[5m]) /\navg_over_time(pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\", query=\"816852380068164872\"}[5m])","timeRangeSeconds":3600,"count":1},{"query":"increase(pg_query_exec_time{ins=\"pg-meta-1\", datname=\"postgres\", query=\"816852380068164872\"}[1m]) /\n increase(pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\", query=\"816852380068164872\"}[1m])","timeRangeSeconds":3600,"count":1},{"query":"max by (query) (pg_query_exec_time{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"count":1},{"query":"sum by (datname) (pg:db:xact_commit_rate1m{ins=\"pg-meta-1\"})","timeRangeSeconds":0,"count":1},{"query":"pg:db:xact_commit_rate1m{ins=\"pg-meta-1\"}","timeRangeSeconds":3600,"count":1},{"query":"max by (datname) (pg_db_datid{ins=\"pg-meta-1\"})","timeRangeSeconds":0,"count":1},{"query":"avg without (cpu) (node:cpu:usage)","timeRangeSeconds":0,"count":1}],"topByAvgDuration":[{"query":"max by (query) (pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"avgDurationSeconds":0.014,"count":1},{"query":"max by (query) (pg_query_exec_time{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"avgDurationSeconds":0.012,"count":1},{"query":"max by (query) (pg_query_wal_bytes{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"avgDurationSeconds":0.008,"count":1},{"query":"max by (datname, query) (pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\"}) > 0","timeRangeSeconds":0,"avgDurationSeconds":0.008,"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.007,"count":1},{"query":"max by (query) (pg:query:call_rate1m{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"avgDurationSeconds":0.005,"count":1},{"query":"max by (query) (pg_query_wal_bytes{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgDurationSeconds":0.004,"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 (query) (pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":1},{"query":"node:ins:tcp_retranssegs_rate1m{ip=\"10.31.13.3\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.003,"count":1},{"query":"sum by (datname) (pg_activity_count{ins=\"pg-meta-1\"})","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":1},{"query":"pg:table:scan_rate1m{ins=\"pg-meta-1\", datname=\"meta\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.003,"count":1},{"query":"node:ins:tcp_retrans_ratio1m{ip=\"10.31.13.3\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.003,"count":1},{"query":"pg_db_numbackends{ins=\"pg-meta-1\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.003,"count":1},{"query":"max by (datname) (pg_db_datid{ins=\"pg-meta-1\"})","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":1},{"query":"1 - (node:fs:inode_free / node:fs:inode_total)","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":1},{"query":"node:fs:inode_total - node:fs:inode_free","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":1},{"query":"pg:db:active_time_rate1m{ins=\"pg-meta-1\", datname=\"meta\"}\n/ pg:db:num_backends{ins=\"pg-meta-1\", datname=\"meta\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.003,"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":"pg:db:blks_hit_ratio1m{ins=\"pg-meta-1\", datname=\"meta\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.002,"count":1}],"topBySumDuration":[{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"sumDurationSeconds":0.138,"count":60},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"sumDurationSeconds":0.056,"count":45},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.046,"count":39},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.022,"count":18},{"query":"max by (query) (pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"sumDurationSeconds":0.014,"count":1},{"query":"max by (query) (pg_query_exec_time{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"sumDurationSeconds":0.012,"count":1},{"query":"max by (query) (pg_query_wal_bytes{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"sumDurationSeconds":0.008,"count":1},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"sumDurationSeconds":0.008,"count":6},{"query":"max by (datname, query) (pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\"}) > 0","timeRangeSeconds":0,"sumDurationSeconds":0.008,"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.007,"count":1},{"query":"max by (query) (pg:query:call_rate1m{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"sumDurationSeconds":0.005,"count":1},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.005,"count":3},{"query":"max by (query) (pg_query_wal_bytes{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"sumDurationSeconds":0.004,"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 (query) (pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"sumDurationSeconds":0.004,"count":1},{"query":"node:ins:tcp_retranssegs_rate1m{ip=\"10.31.13.3\"}","timeRangeSeconds":3600,"sumDurationSeconds":0.003,"count":1},{"query":"sum by (datname) (pg_activity_count{ins=\"pg-meta-1\"})","timeRangeSeconds":0,"sumDurationSeconds":0.003,"count":1},{"query":"pg:table:scan_rate1m{ins=\"pg-meta-1\", datname=\"meta\"}","timeRangeSeconds":3600,"sumDurationSeconds":0.003,"count":1},{"query":"node:ins:tcp_retrans_ratio1m{ip=\"10.31.13.3\"}","timeRangeSeconds":3600,"sumDurationSeconds":0.003,"count":1},{"query":"pg_db_numbackends{ins=\"pg-meta-1\"}","timeRangeSeconds":3600,"sumDurationSeconds":0.003,"count":1}],"topByAvgMemoryUsage":[{"query":"pg:table:scan_rate1m{ins=\"pg-meta-1\", datname=\"meta\"}","timeRangeSeconds":3600,"avgMemoryBytes":159736,"count":1},{"query":"pg:query:call_rate1m{ins=\"pg-meta-1\", datname=\"meta\"}","timeRangeSeconds":3600,"avgMemoryBytes":155840,"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":39},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"avgMemoryBytes":113792,"count":18},{"query":"max by (query) (pg_query_wal_bytes{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"avgMemoryBytes":46736,"count":1},{"query":"max by (query) (pg:query:call_rate1m{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"avgMemoryBytes":46736,"count":1},{"query":"max by (datname, query) (pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\"}) > 0","timeRangeSeconds":0,"avgMemoryBytes":46736,"count":1},{"query":"max by (query) (pg_query_exec_time{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"avgMemoryBytes":46736,"count":1},{"query":"max by (query) (pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"avgMemoryBytes":44704,"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":41656,"count":1},{"query":"sum by (relname) (pg_table_n_live_tup{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgMemoryBytes":41656,"count":1},{"query":"max by (query) (pg_query_wal_bytes{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgMemoryBytes":40640,"count":1},{"query":"max by (query) (pg_query_exec_time{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgMemoryBytes":40640,"count":1},{"query":"max by (datname, query) (pg_query_calls{ins=\"pg-meta-1\", datname=\"meta\"}) > 0","timeRangeSeconds":0,"avgMemoryBytes":40640,"count":1},{"query":"max by (query) (pg:query:call_rate1m{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgMemoryBytes":40640,"count":1},{"query":"pg_db_numbackends{ins=\"pg-meta-1\"}","timeRangeSeconds":3600,"avgMemoryBytes":33880,"count":1},{"query":"pg:db:xact_commit_rate1m{ins=\"pg-meta-1\"}","timeRangeSeconds":3600,"avgMemoryBytes":33880,"count":1},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"avgMemoryBytes":32512,"count":3},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"avgMemoryBytes":32512,"count":6}]}