{"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":40},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"count":35},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"count":14},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"count":12},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"count":11},{"query":"up{job=\"infra\"}","timeRangeSeconds":0,"count":2},{"query":"sum by (ins,instance) (haproxy_backend_current_sessions{cls=\"pg-meta\", proxy!=\"stats\"})","timeRangeSeconds":0,"count":2},{"query":"sum by (relname) (pg:table:scan_rate1m{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"count":2},{"query":"pgbouncer_database_pool_size{datname!=\"pgbouncer\"}","timeRangeSeconds":0,"count":2},{"query":"sum by (relname) (pg_table_size_bytes{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"count":2},{"query":"rate(node_schedstat_waiting_seconds_total[1m])","timeRangeSeconds":0,"count":2},{"query":"min by (ins,ip) (up{job=\"pgsql\", cls=\"pg-meta\"})","timeRangeSeconds":0,"count":2},{"query":"sum by (relname) (pg_table_n_live_tup{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"count":2},{"query":"sum(pg_size_bytes{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":3600,"count":1},{"query":"rate(pg_query_calls{ins=\"pg-meta-1\", datname=\"meta\", query=\"-1681750311364119013\"}[5m])","timeRangeSeconds":3600,"count":1},{"query":"pg:db:conn_usage > 0.70","timeRangeSeconds":0,"count":1},{"query":"rate(pg_db_xact_commit{ins=\"pg-meta-1\", datname=\"meta\"}[5m])","timeRangeSeconds":3600,"count":1},{"query":"pg_db_numbackends{ins=\"pg-meta-1\",datname=\"postgres\"}","timeRangeSeconds":3600,"count":1},{"query":"pg:db:tup_modified_rate1m{ins=\"pg-meta-1\", datname=\"postgres\"}","timeRangeSeconds":3600,"count":1}],"topByAvgDuration":[{"query":"rate(pg_query_calls{ins=\"pg-meta-1\", datname=\"meta\", query!=\"-1681750311364119013\"}[5m])","timeRangeSeconds":3600,"avgDurationSeconds":0.018,"count":1},{"query":"rate(pg_db_xact_commit{ins=\"pg-meta-1\", datname=\"meta\"}[5m])","timeRangeSeconds":3600,"avgDurationSeconds":0.011,"count":1},{"query":"pg:table:scan_rate1m{ins=\"pg-meta-1\", datname=\"meta\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.010,"count":1},{"query":"max by (query) (pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgDurationSeconds":0.009,"count":1},{"query":"minio_s3_traffic_sent_bytes{ins=\"minio-1\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.008,"count":1},{"query":"rate(pg_query_exec_time{ins=\"pg-meta-1\", datname=\"postgres\", query=\"393550323916470202\"}[1m]) /\n rate(pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\", query=\"393550323916470202\"}[1m])","timeRangeSeconds":3600,"avgDurationSeconds":0.008,"count":1},{"query":"max by (query) (pg_query_wal_bytes{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgDurationSeconds":0.007,"count":1},{"query":"max(minio_cluster_bucket_total{ins=\"minio-1\"})","timeRangeSeconds":3600,"avgDurationSeconds":0.007,"count":1},{"query":"1 - (minio_cluster_capacity_usable_free_bytes{ins=\"minio-1\"} / minio_cluster_capacity_usable_total_bytes{ins=\"minio-1\"})","timeRangeSeconds":3600,"avgDurationSeconds":0.007,"count":1},{"query":"rate(pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\", query=\"393550323916470202\"}[1m])","timeRangeSeconds":3600,"avgDurationSeconds":0.006,"count":1},{"query":"pg:db:active_time_rate1m{ins=\"pg-meta-1\", datname=\"postgres\"}\n/ pg:db:num_backends{ins=\"pg-meta-1\", datname=\"postgres\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.005,"count":1},{"query":"minio_s3_traffic_received_bytes{ins=\"minio-1\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.005,"count":1},{"query":"max by (query) (pg_query_wal_bytes{ins=\"pg-meta-1\", datname=\"postgres\"})","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":1},{"query":"sum by (server,api) (increase(minio_s3_requests_total{ins=\"minio-1\"}[4m0s]))","timeRangeSeconds":3600,"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":"pg:db:xact_commit_rate1m{ins=\"pg-meta-1\", datname=\"postgres\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.004,"count":1},{"query":"group by (job, cls, ins, ip) (up{cls!=\"\", ins!=\"\", job=\u0027pgsql\u0027})","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":1},{"query":"sum(minio_cluster_usage_object_total{ins=\"minio-1\"})","timeRangeSeconds":3600,"avgDurationSeconds":0.003,"count":1},{"query":"rate(minio_node_process_cpu_total_seconds{ins=\"minio-1\"}[1m])","timeRangeSeconds":3600,"avgDurationSeconds":0.003,"count":1},{"query":"sum by (server,api) (increase(minio_s3_requests_errors_total{ins=\"minio-1\"}[4m0s]))","timeRangeSeconds":3600,"avgDurationSeconds":0.003,"count":1}],"topBySumDuration":[{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"sumDurationSeconds":0.162,"count":60},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"sumDurationSeconds":0.054,"count":40},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.045,"count":35},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.019,"count":11},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"sumDurationSeconds":0.018,"count":12},{"query":"rate(pg_query_calls{ins=\"pg-meta-1\", datname=\"meta\", query!=\"-1681750311364119013\"}[5m])","timeRangeSeconds":3600,"sumDurationSeconds":0.018,"count":1},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.017,"count":14},{"query":"rate(pg_db_xact_commit{ins=\"pg-meta-1\", datname=\"meta\"}[5m])","timeRangeSeconds":3600,"sumDurationSeconds":0.011,"count":1},{"query":"pg:table:scan_rate1m{ins=\"pg-meta-1\", datname=\"meta\"}","timeRangeSeconds":3600,"sumDurationSeconds":0.010,"count":1},{"query":"max by (query) (pg:query:rt_1m{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"sumDurationSeconds":0.009,"count":1},{"query":"minio_s3_traffic_sent_bytes{ins=\"minio-1\"}","timeRangeSeconds":3600,"sumDurationSeconds":0.008,"count":1},{"query":"rate(pg_query_exec_time{ins=\"pg-meta-1\", datname=\"postgres\", query=\"393550323916470202\"}[1m]) /\n rate(pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\", query=\"393550323916470202\"}[1m])","timeRangeSeconds":3600,"sumDurationSeconds":0.008,"count":1},{"query":"max by (query) (pg_query_wal_bytes{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"sumDurationSeconds":0.007,"count":1},{"query":"max(minio_cluster_bucket_total{ins=\"minio-1\"})","timeRangeSeconds":3600,"sumDurationSeconds":0.007,"count":1},{"query":"1 - (minio_cluster_capacity_usable_free_bytes{ins=\"minio-1\"} / minio_cluster_capacity_usable_total_bytes{ins=\"minio-1\"})","timeRangeSeconds":3600,"sumDurationSeconds":0.007,"count":1},{"query":"rate(pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\", query=\"393550323916470202\"}[1m])","timeRangeSeconds":3600,"sumDurationSeconds":0.006,"count":1},{"query":"rate(node_schedstat_waiting_seconds_total[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.005,"count":2},{"query":"sum by (relname) (pg:table:scan_rate1m{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"sumDurationSeconds":0.005,"count":2},{"query":"pg:db:active_time_rate1m{ins=\"pg-meta-1\", datname=\"postgres\"}\n/ pg:db:num_backends{ins=\"pg-meta-1\", datname=\"postgres\"}","timeRangeSeconds":3600,"sumDurationSeconds":0.005,"count":1},{"query":"minio_s3_traffic_received_bytes{ins=\"minio-1\"}","timeRangeSeconds":3600,"sumDurationSeconds":0.005,"count":1}],"topByAvgMemoryUsage":[{"query":"rate(pg_query_calls{ins=\"pg-meta-1\", datname=\"meta\", query!=\"-1681750311364119013\"}[5m])","timeRangeSeconds":3600,"avgMemoryBytes":601224,"count":1},{"query":"pg:query:call_rate1m{ins=\"pg-meta-1\", datname=\"postgres\"}","timeRangeSeconds":3600,"avgMemoryBytes":311696,"count":1},{"query":"pg:table:scan_rate1m{ins=\"pg-meta-1\", datname=\"meta\"}","timeRangeSeconds":3600,"avgMemoryBytes":277816,"count":1},{"query":"max by (range) (minio_cluster_objects_size_distribution{ins=\"minio-1\"})","timeRangeSeconds":3600,"avgMemoryBytes":137896,"count":1},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"avgMemoryBytes":130048,"count":35},{"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":113792,"count":14},{"query":"sum by (relname) (pg_table_size_bytes{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgMemoryBytes":70104,"count":2},{"query":"pg:db:xact_commit_rate1m{ins=\"pg-meta-1\"}","timeRangeSeconds":3600,"avgMemoryBytes":62680,"count":1},{"query":"pg_db_numbackends{ins=\"pg-meta-1\"}","timeRangeSeconds":3600,"avgMemoryBytes":62680,"count":1},{"query":"max by (query) (pg:query:rt_1m{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_wal_bytes{ins=\"pg-meta-1\", datname=\"postgres\"})","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":"sum by (relname) (pg_table_n_live_tup{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgMemoryBytes":41656,"count":2},{"query":"sum by (relname) (pg:table:scan_rate1m{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgMemoryBytes":41656,"count":2},{"query":"max by (query) (pg_query_exec_time{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgMemoryBytes":40640,"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:call_rate1m{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}]}