{"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":8},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"count":6},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"count":2},{"query":"max(pg:ins:space_usage{job=\"pgsql\"})","timeRangeSeconds":2570400,"count":1},{"query":"increase(pg_checkpointer_timed{ins=\"pg-meta-1\"}[15s]) > 0","timeRangeSeconds":3600,"count":1},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"count":1},{"query":"pgbouncer:db:pool_current_conn / pgbouncer:db:pool_size","timeRangeSeconds":0,"count":1},{"query":"sum(pg:cls:num_backends{job=\"pgsql\"})","timeRangeSeconds":2570400,"count":1},{"query":"max(pg:ins:conn_usage{job=\"pgsql\"})","timeRangeSeconds":2570400,"count":1},{"query":"sum(etcd_server_id{job=\"etcd\", cls=\"etcd\"}) by (cls) / count(etcd_server_id{job=\"etcd\", cls=\"etcd\"}) by (cls)\n","timeRangeSeconds":2588400,"count":1},{"query":"pg:cls:load5{job=\"pgsql\"} != -1","timeRangeSeconds":2588400,"count":1},{"query":"pgbouncer_database_pool_size{datname!=\"pgbouncer\"} + pgbouncer_database_reserve_pool{datname!=\"pgbouncer\"}","timeRangeSeconds":0,"count":1},{"query":"pg:db:conn_usage > 0.70","timeRangeSeconds":0,"count":1},{"query":"pg:env:xact_commit_rate1m{job=\"pgsql\"}","timeRangeSeconds":2570400,"count":1},{"query":"cls:pressure1{job=\"pgsql\"}","timeRangeSeconds":2588400,"count":1},{"query":"sum without (device) (node:dev:network_tx_bytes_rate1m{device!~\"lo|bond.*\"})","timeRangeSeconds":0,"count":1},{"query":"sum without(datname) (pg:db:xact_rollback_rate1m)","timeRangeSeconds":0,"count":1},{"query":"sum by (ins,instance) (haproxy_backend_current_sessions{cls=\"pg-meta\", proxy!=\"stats\"})","timeRangeSeconds":0,"count":1},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"count":1}],"topByAvgDuration":[{"query":"rate(pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-1625100286364369430\"}[1m])","timeRangeSeconds":3600,"avgDurationSeconds":0.010,"count":1},{"query":"rate(pg_query_exec_time{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-1625100286364369430\"}[1m]) /\n rate(pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-1625100286364369430\"}[1m])","timeRangeSeconds":3600,"avgDurationSeconds":0.008,"count":1},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.005,"count":1},{"query":"pg:env:cpu_usage{job=\"pgsql\"}","timeRangeSeconds":2570400,"avgDurationSeconds":0.005,"count":1},{"query":"sum without(datname) (pg:db:xact_rollback_rate1m)","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":1},{"query":"sum without (device) (node:dev:network_tx_pps1m{device!~\"lo|bond.*\"})","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":1},{"query":"sum without (device) (node:dev:network_tx_bytes_rate1m{device!~\"lo|bond.*\"})","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":1},{"query":"sum(etcd_server_id{job=\"etcd\", cls=\"etcd\"}) by (cls) / count(etcd_server_id{job=\"etcd\", cls=\"etcd\"}) by (cls)\n","timeRangeSeconds":2588400,"avgDurationSeconds":0.003,"count":1},{"query":"pg:db:ixact_backends > 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":"pg:env:xact_commit_rate1m{job=\"pgsql\"}","timeRangeSeconds":2570400,"avgDurationSeconds":0.002,"count":1},{"query":"node_filesystem_free_bytes{fstype!~\"(n|root|tmp)fs.*\"}","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"pgbouncer:db:pool_current_conn / pgbouncer:db:pool_size","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"max(pg:ins:space_usage{job=\"pgsql\"})","timeRangeSeconds":2570400,"avgDurationSeconds":0.002,"count":1},{"query":"cls:pressure1{job=\"pgsql\"}","timeRangeSeconds":2588400,"avgDurationSeconds":0.002,"count":1},{"query":"pg:env:xact_rollback_rate1m{job=\"pgsql\"}","timeRangeSeconds":2570400,"avgDurationSeconds":0.002,"count":1},{"query":"sum by (ins,instance) (haproxy_backend_current_sessions{cls=\"pg-meta\", proxy!=\"stats\"})","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"sum(pg:cls:num_backends{job=\"pgsql\"})","timeRangeSeconds":2570400,"avgDurationSeconds":0.001,"count":1},{"query":"max(pg:ins:conn_usage{job=\"pgsql\"})","timeRangeSeconds":2570400,"avgDurationSeconds":0.001,"count":1},{"query":"pg:db:ixact_time_rate1m / (pg:db:active_time_rate1m + pg:db:ixact_time_rate1m)","timeRangeSeconds":0,"avgDurationSeconds":0.001,"count":1}],"topBySumDuration":[{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"sumDurationSeconds":0.116,"count":60},{"query":"rate(pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-1625100286364369430\"}[1m])","timeRangeSeconds":3600,"sumDurationSeconds":0.010,"count":1},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.010,"count":8},{"query":"rate(pg_query_exec_time{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-1625100286364369430\"}[1m]) /\n rate(pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-1625100286364369430\"}[1m])","timeRangeSeconds":3600,"sumDurationSeconds":0.008,"count":1},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"sumDurationSeconds":0.007,"count":6},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.005,"count":1},{"query":"pg:env:cpu_usage{job=\"pgsql\"}","timeRangeSeconds":2570400,"sumDurationSeconds":0.005,"count":1},{"query":"sum without(datname) (pg:db:xact_rollback_rate1m)","timeRangeSeconds":0,"sumDurationSeconds":0.003,"count":1},{"query":"sum without (device) (node:dev:network_tx_pps1m{device!~\"lo|bond.*\"})","timeRangeSeconds":0,"sumDurationSeconds":0.003,"count":1},{"query":"sum without (device) (node:dev:network_tx_bytes_rate1m{device!~\"lo|bond.*\"})","timeRangeSeconds":0,"sumDurationSeconds":0.003,"count":1},{"query":"sum(etcd_server_id{job=\"etcd\", cls=\"etcd\"}) by (cls) / count(etcd_server_id{job=\"etcd\", cls=\"etcd\"}) by (cls)\n","timeRangeSeconds":2588400,"sumDurationSeconds":0.003,"count":1},{"query":"pg:db:ixact_backends > 1","timeRangeSeconds":0,"sumDurationSeconds":0.002,"count":1},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"sumDurationSeconds":0.002,"count":2},{"query":"pg:env:xact_commit_rate1m{job=\"pgsql\"}","timeRangeSeconds":2570400,"sumDurationSeconds":0.002,"count":1},{"query":"node_filesystem_free_bytes{fstype!~\"(n|root|tmp)fs.*\"}","timeRangeSeconds":0,"sumDurationSeconds":0.002,"count":1},{"query":"pgbouncer:db:pool_current_conn / pgbouncer:db:pool_size","timeRangeSeconds":0,"sumDurationSeconds":0.002,"count":1},{"query":"max(pg:ins:space_usage{job=\"pgsql\"})","timeRangeSeconds":2570400,"sumDurationSeconds":0.002,"count":1},{"query":"cls:pressure1{job=\"pgsql\"}","timeRangeSeconds":2588400,"sumDurationSeconds":0.002,"count":1},{"query":"pg:env:xact_rollback_rate1m{job=\"pgsql\"}","timeRangeSeconds":2570400,"sumDurationSeconds":0.002,"count":1},{"query":"sum by (ins,instance) (haproxy_backend_current_sessions{cls=\"pg-meta\", proxy!=\"stats\"})","timeRangeSeconds":0,"sumDurationSeconds":0.002,"count":1}],"topByAvgMemoryUsage":[{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"avgMemoryBytes":130048,"count":8},{"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":1},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"avgMemoryBytes":32512,"count":1},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"avgMemoryBytes":32512,"count":2},{"query":"pg:cls:load5{job=\"pgsql\"} != -1","timeRangeSeconds":2588400,"avgMemoryBytes":12520,"count":1},{"query":"sum(etcd_server_id{job=\"etcd\", cls=\"etcd\"}) by (cls) / count(etcd_server_id{job=\"etcd\", cls=\"etcd\"}) by (cls)\n","timeRangeSeconds":2588400,"avgMemoryBytes":12520,"count":1},{"query":"cls:pressure1{job=\"pgsql\"}","timeRangeSeconds":2588400,"avgMemoryBytes":12520,"count":1},{"query":"sum without (device) (node:dev:network_tx_bytes_rate1m{device!~\"lo|bond.*\"})","timeRangeSeconds":0,"avgMemoryBytes":7112,"count":1},{"query":"sum without (device) (node:dev:network_tx_pps1m{device!~\"lo|bond.*\"})","timeRangeSeconds":0,"avgMemoryBytes":7112,"count":1},{"query":"rate(pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-1625100286364369430\"}[1m])","timeRangeSeconds":3600,"avgMemoryBytes":6776,"count":1},{"query":"rate(pg_query_exec_time{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-1625100286364369430\"}[1m]) /\n rate(pg_query_calls{ins=\"pg-meta-1\", datname=\"postgres\", query=\"-1625100286364369430\"}[1m])","timeRangeSeconds":3600,"avgMemoryBytes":6776,"count":1},{"query":"pg:db:ixact_time_rate5m / (pg:db:active_time_rate5m + pg:db:ixact_time_rate5m)","timeRangeSeconds":0,"avgMemoryBytes":5080,"count":1},{"query":"pg:db:ixact_time_rate1m / (pg:db:active_time_rate1m + pg:db:ixact_time_rate1m)","timeRangeSeconds":0,"avgMemoryBytes":5080,"count":1},{"query":"sum without(datname) (pg:db:xact_rollback_rate1m)","timeRangeSeconds":0,"avgMemoryBytes":5080,"count":1},{"query":"pg:db:conn_usage > 0.70","timeRangeSeconds":0,"avgMemoryBytes":5080,"count":1},{"query":"sum by (ins,instance) (haproxy_backend_current_sessions{cls=\"pg-meta\", proxy!=\"stats\"})","timeRangeSeconds":0,"avgMemoryBytes":4064,"count":1},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"avgMemoryBytes":4064,"count":6},{"query":"pg:db:ixact_backends > 1","timeRangeSeconds":0,"avgMemoryBytes":3048,"count":1},{"query":"max(pg:ins:space_usage{job=\"pgsql\"})","timeRangeSeconds":2570400,"avgMemoryBytes":2920,"count":1}]}