{"topN":"20","maxLifetime":"10m0s","search.queryStats.lastQueriesCount":20000,"search.queryStats.minQueryDuration":"1ms","search.queryStats.minQueryMemoryUsage":"1024","topByCount":[{"query":"node:ins:cpu_usage_1m + on(ip) group_right() pg_up * 0","timeRangeSeconds":0,"count":109},{"query":"pgbouncer_database_pool_size{datname!=\"pgbouncer\"} + pgbouncer_database_reserve_pool{datname!=\"pgbouncer\"}","timeRangeSeconds":0,"count":60},{"query":"max without (instance) (pg:ins:load5 > ignoring(instance) pgbouncer:ins:load5 or pgbouncer:ins:load5)","timeRangeSeconds":0,"count":60},{"query":"sum by (job) (node:cls:cpu_usage * node:cls:cpu_count) / sum by (job) (node:cls:cpu_count)","timeRangeSeconds":0,"count":60},{"query":"pg:db:ixact_time_rate5m / (pg:db:active_time_rate5m + pg:db:ixact_time_rate5m)","timeRangeSeconds":0,"count":60},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"count":60},{"query":"max without (instance) (pg:ins:load1 > ignoring(instance) pgbouncer:ins:load1 or pgbouncer:ins:load1)","timeRangeSeconds":0,"count":60},{"query":"redis:env:cmd_time / redis:env:cmd_qps","timeRangeSeconds":0,"count":60},{"query":"node:dev:disk_mreads_rate1m / (node:dev:disk_reads_rate1m + node:dev:disk_mreads_rate1m)","timeRangeSeconds":0,"count":60},{"query":"pg:db:ixact_time_rate15m / (pg:db:active_time_rate15m + pg:db:ixact_time_rate15m)","timeRangeSeconds":0,"count":60},{"query":"sum without (mode) (pg_lock_count{mode!~\"AccessShareLock|RowShareLock|RowExclusiveLock\"})","timeRangeSeconds":0,"count":60},{"query":"pg:cls:load15 > pgbouncer:cls:load15 or pgbouncer:cls:load15","timeRangeSeconds":0,"count":60},{"query":"node:dev:disk_read_time_rate1m + node:dev:disk_write_time_rate1m","timeRangeSeconds":0,"count":60},{"query":"node:cls:disk_read_bytes_rate1m + node:cls:disk_write_bytes_rate1m","timeRangeSeconds":0,"count":60},{"query":"max by (id, ins, instance, cls, job) (\n  label_replace(redis_up, \"id\", \"$1\", \"ins\", \"(.+)\") OR\n  label_replace(redis_up, \"id\", \"$1\", \"instance\", \"(.+)\")\n)\n","timeRangeSeconds":0,"count":60},{"query":"node:dev:network_tx_bytes_rate1m + node:dev:network_rx_bytes_rate1m","timeRangeSeconds":0,"count":60},{"query":"sum by (job,cmd) (redis:ins:cmd_time)","timeRangeSeconds":0,"count":60},{"query":"sum(patroni_failsafe_mode_is_active{}) > 0","timeRangeSeconds":0,"count":60},{"query":"sum without (mode) (pg_lock_count)","timeRangeSeconds":0,"count":60},{"query":"sum by (cls, job) (node_load1) / node:cls:cpu_count","timeRangeSeconds":0,"count":60}],"topByAvgDuration":[{"query":"count(ALERTS{alertstate=\"firing\"}) or on() vector(0)","timeRangeSeconds":3600,"avgDurationSeconds":0.057,"count":1},{"query":"count(ALERTS{alertstate=\"firing\"}) by (alertname, severity)","timeRangeSeconds":3600,"avgDurationSeconds":0.056,"count":1},{"query":"cls:pressure5{job=\"pgsql\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.045,"count":1},{"query":"redis:cls:cpu_usage{job=\"redis\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.043,"count":1},{"query":"avg by (cls) (rate(minio_system_process_cpu_total_seconds{job=\"minio\"}[1m]))","timeRangeSeconds":3600,"avgDurationSeconds":0.035,"count":1},{"query":"rate(pg_db_active_time{ins=\"pg-center-1\", datname=\"template0\"}[5m]) /\nrate(pg_db_xact_commit{ins=\"pg-center-1\", datname=\"template0\"}[5m])","timeRangeSeconds":21600,"avgDurationSeconds":0.028,"count":1},{"query":"node:cls:cpu_usage{job=\"node\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.027,"count":1},{"query":"sum(etcd_up{job=\"etcd\"}) by (cls) / count(etcd_up{job=\"etcd\"}) by (cls)","timeRangeSeconds":3600,"avgDurationSeconds":0.025,"count":1},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.018,"count":60},{"query":"rate(pg_db_active_time{ins=\"pg-meta-1\", datname=\"discourse\"}[5m]) /\nrate(pg_db_xact_commit{ins=\"pg-meta-1\", datname=\"discourse\"}[5m])","timeRangeSeconds":3600,"avgDurationSeconds":0.018,"count":1},{"query":"sum by (job, cls) (pg:ins:xact_commit_rate1m)","timeRangeSeconds":0,"avgDurationSeconds":0.018,"count":1},{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"avgDurationSeconds":0.017,"count":60},{"query":"sum by (job, cls) (pg:ins:xact_total_rate1m)","timeRangeSeconds":0,"avgDurationSeconds":0.016,"count":1},{"query":"rate(node_disk_write_time_seconds_total{device=~\"[a-z0-9A-Z-_]+\"}[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.014,"count":1},{"query":"increase(pg_query_exec_time{ins=\"pg-meta-1\", datname=\"discourse\"}[1h]) / increase(pg_query_calls{ins=\"pg-meta-1\", datname=\"discourse\"}[1h])","timeRangeSeconds":3600,"avgDurationSeconds":0.013,"count":1},{"query":"rate(pg_query_sblk_hit{ins=\"pg-center-1\", datname=\"center\", query=\"1627145536710649302\"}[5m]) * 8192\n/\nrate(pg_query_calls{ins=\"pg-center-1\", datname=\"center\", query=\"1627145536710649302\"}[5m])","timeRangeSeconds":3600,"avgDurationSeconds":0.013,"count":1},{"query":"node_memory_MemTotal_bytes -\n(node_memory_KernelStack_bytes +\nnode_memory_VmallocUsed_bytes +\nnode_memory_HardwareCorrupted_bytes +\nnode_memory_PageTables_bytes +\nnode_memory_Slab_bytes +\nnode_memory_PageTables_bytes) - \nnode_memory_Buffers_bytes -\n(node_memory_Hugepagesize_bytes * node_memory_HugePages_Total) -\n(node_memory_Cached_bytes - node_memory_Mapped_bytes ) -\nnode_memory_MemFree_bytes\n","timeRangeSeconds":0,"avgDurationSeconds":0.012,"count":60},{"query":"avg_over_time(pg:query:call_rate1m{ins=\"pg-center-1\", datname=\"center\", query=\"1627145536710649302\"}[15m]) - stddev_over_time(pg:query:call_rate1m{ins=\"pg-center-1\", datname=\"center\", query=\"1627145536710649302\"}[15m])","timeRangeSeconds":3600,"avgDurationSeconds":0.012,"count":1},{"query":"rate(pg_lsn{ins=\"pg-meta-1\"}[5m])","timeRangeSeconds":3600,"avgDurationSeconds":0.012,"count":1},{"query":"rate(pg_query_wal_bytes{ins=\"pg-meta-1\", datname=\"discourse\", query!=\"\"}[5m])","timeRangeSeconds":3600,"avgDurationSeconds":0.012,"count":1}],"topBySumDuration":[{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"sumDurationSeconds":1.087,"count":60},{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"sumDurationSeconds":1.010,"count":60},{"query":"node_memory_MemTotal_bytes -\n(node_memory_KernelStack_bytes +\nnode_memory_VmallocUsed_bytes +\nnode_memory_HardwareCorrupted_bytes +\nnode_memory_PageTables_bytes +\nnode_memory_Slab_bytes +\nnode_memory_PageTables_bytes) - \nnode_memory_Buffers_bytes -\n(node_memory_Hugepagesize_bytes * node_memory_HugePages_Total) -\n(node_memory_Cached_bytes - node_memory_Mapped_bytes ) -\nnode_memory_MemFree_bytes\n","timeRangeSeconds":0,"sumDurationSeconds":0.728,"count":60},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.434,"count":60},{"query":"redis:ins:cmd_time / redis:ins:cmd_qps","timeRangeSeconds":0,"sumDurationSeconds":0.408,"count":60},{"query":"node_memory_KernelStack_bytes +\nnode_memory_VmallocUsed_bytes +\nnode_memory_HardwareCorrupted_bytes +\nnode_memory_PageTables_bytes +\nnode_memory_Slab_bytes +\nnode_memory_PageTables_bytes\n","timeRangeSeconds":0,"sumDurationSeconds":0.403,"count":60},{"query":"sum without (cmd) (redis:ins:cmd_time) / sum without (cmd) (redis:ins:cmd_qps)","timeRangeSeconds":0,"sumDurationSeconds":0.306,"count":60},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.229,"count":60},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"sumDurationSeconds":0.228,"count":60},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"sumDurationSeconds":0.223,"count":60},{"query":"sum by (job,cls,cmd) (redis:ins:cmd_time)","timeRangeSeconds":0,"sumDurationSeconds":0.204,"count":60},{"query":"sum without (machine, release, version, sysname, domainname) (\n  label_replace(node_uname_info, \"id\", \"$1\", \"nodename\", \"(.+)\") OR\n  label_replace(node_uname_info, \"id\", \"$1\", \"instance\", \"(.+)\\\\:\\\\d+\") OR\n  label_replace(node_uname_info, \"id\", \"$1\", \"ins\", \"(.+)\")\n)\n","timeRangeSeconds":0,"sumDurationSeconds":0.201,"count":59},{"query":"pg:db:ixact_time_rate1m / (pg:db:active_time_rate1m + pg:db:ixact_time_rate1m)","timeRangeSeconds":0,"sumDurationSeconds":0.193,"count":60},{"query":"sum by (job,cmd) (redis:ins:cmd_time)","timeRangeSeconds":0,"sumDurationSeconds":0.184,"count":60},{"query":"pg:db:ixact_time_rate5m / (pg:db:active_time_rate5m + pg:db:ixact_time_rate5m)","timeRangeSeconds":0,"sumDurationSeconds":0.183,"count":60},{"query":"node:ins:cpu_usage_1m + on(ip) group_right() pg_up * 0","timeRangeSeconds":0,"sumDurationSeconds":0.180,"count":109},{"query":"sum by (job,cls,cmd) (redis:ins:cmd_qps)","timeRangeSeconds":0,"sumDurationSeconds":0.178,"count":60},{"query":"rate(redis_commands_total[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.178,"count":60},{"query":"sum by (job) (node:cls:cpu_usage * node:cls:cpu_count) / sum by (job) (node:cls:cpu_count)","timeRangeSeconds":0,"sumDurationSeconds":0.178,"count":60},{"query":"pg:db:ixact_time_rate15m / (pg:db:active_time_rate15m + pg:db:ixact_time_rate15m)","timeRangeSeconds":0,"sumDurationSeconds":0.176,"count":60}],"topByAvgMemoryUsage":[{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"avgMemoryBytes":1553464,"count":60},{"query":"sum by (job,cls,severity,alertname) (ALERTS{alertstate=\"firing\"})","timeRangeSeconds":3600,"avgMemoryBytes":745400,"count":1},{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"avgMemoryBytes":521208,"count":60},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"avgMemoryBytes":521208,"count":60},{"query":"increase(pg_query_exec_time{ins=\"pg-meta-1\", datname=\"discourse\"}[1h]) / increase(pg_query_calls{ins=\"pg-meta-1\", datname=\"discourse\"}[1h])","timeRangeSeconds":3600,"avgMemoryBytes":313400,"count":1},{"query":"sum by (query) (increase(pg_query_exec_time{ins=\"pg-meta-1\", datname=\"discourse\"}[1h]))","timeRangeSeconds":3600,"avgMemoryBytes":313400,"count":1},{"query":"sum without (datname) (pg_lock_count)","timeRangeSeconds":0,"avgMemoryBytes":178816,"count":60},{"query":"sum without (mode) (pg_lock_count)","timeRangeSeconds":0,"avgMemoryBytes":178816,"count":60},{"query":"rate(pg_query_wal_bytes{ins=\"pg-meta-1\", datname=\"discourse\", query!=\"\"}[5m])","timeRangeSeconds":3600,"avgMemoryBytes":169400,"count":1},{"query":"count(ALERTS{alertstate=\"firing\"}) by (alertname, severity)","timeRangeSeconds":3600,"avgMemoryBytes":169400,"count":1},{"query":"sum by (job,cls,cmd) (redis:ins:cmd_qps)","timeRangeSeconds":0,"avgMemoryBytes":168656,"count":60},{"query":"sum by (job,cls,cmd) (redis:ins:cmd_time)","timeRangeSeconds":0,"avgMemoryBytes":168656,"count":60},{"query":"rate(redis_commands_duration_seconds_total[1m])","timeRangeSeconds":0,"avgMemoryBytes":168656,"count":60},{"query":"rate(redis_commands_total[1m])","timeRangeSeconds":0,"avgMemoryBytes":168656,"count":60},{"query":"sum by (job,cmd) (redis:ins:cmd_time)","timeRangeSeconds":0,"avgMemoryBytes":168656,"count":60},{"query":"sum without (cmd) (redis:ins:cmd_time) / sum without (cmd) (redis:ins:cmd_qps)","timeRangeSeconds":0,"avgMemoryBytes":168656,"count":60},{"query":"redis:ins:cmd_time / redis:ins:cmd_qps","timeRangeSeconds":0,"avgMemoryBytes":168656,"count":60},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"avgMemoryBytes":121920,"count":60},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"avgMemoryBytes":121920,"count":60},{"query":"sum without (mode) (pg_lock_count{mode!~\"AccessShareLock|RowShareLock|RowExclusiveLock\"})","timeRangeSeconds":0,"avgMemoryBytes":111760,"count":60}]}