{"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":75},{"query":"sum by (job) (node:cls:cpu_usage * node:cls:cpu_count) / sum by (job) (node:cls:cpu_count)","timeRangeSeconds":0,"count":60},{"query":"sum(patroni_failsafe_mode_is_active{}) > 0","timeRangeSeconds":0,"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,"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,"count":60},{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"count":60},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"count":60},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"count":60},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"count":60},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"count":60},{"query":"histogram_quantile(0.95, rate(etcd_network_peer_round_trip_time_seconds_bucket{job=\"etcd\"}[5m]))","timeRangeSeconds":0,"count":60},{"query":"pg:db:ixact_time_rate1m / (pg:db:active_time_rate1m + pg:db:ixact_time_rate1m)","timeRangeSeconds":0,"count":58},{"query":"node:ins:cpu_count + on(ip) group_right() pg_up * 0","timeRangeSeconds":0,"count":58},{"query":"pg:db:ixact_time_rate5m / (pg:db:active_time_rate5m + pg:db:ixact_time_rate5m)","timeRangeSeconds":0,"count":57},{"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,"count":56},{"query":"pg:db:ixact_time_rate15m / (pg:db:active_time_rate15m + pg:db:ixact_time_rate15m)","timeRangeSeconds":0,"count":55},{"query":"node:dev:disk_mwrites_rate1m / (node:dev:disk_writes_rate1m + node:dev:disk_mwrites_rate1m)","timeRangeSeconds":0,"count":52},{"query":"sum without (datname) (pg_lock_count)","timeRangeSeconds":0,"count":52},{"query":"1 - node:fs:avail_bytes / node:fs:size_bytes","timeRangeSeconds":0,"count":50},{"query":"node:dev:disk_read_time_rate1m + node:dev:disk_write_time_rate1m","timeRangeSeconds":0,"count":48}],"topByAvgDuration":[{"query":"up{job=\"etcd\"}","timeRangeSeconds":0,"avgDurationSeconds":0.044,"count":1},{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"avgDurationSeconds":0.011,"count":60},{"query":"up{job=\"infra\"}","timeRangeSeconds":0,"avgDurationSeconds":0.009,"count":16},{"query":"max by (job, cls) (pg:ins:slot_retained_bytes)","timeRangeSeconds":0,"avgDurationSeconds":0.008,"count":4},{"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.007,"count":60},{"query":"rate(pg_bgwriter_buffers_clean[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.006,"count":4},{"query":"pgbouncer:ins:query_time_rate5m / on(ins) group_left pg:ins:cpu_count or (0 * pgbouncer_up - 1)","timeRangeSeconds":0,"avgDurationSeconds":0.006,"count":4},{"query":"sum by (job, cls) (pg:ins:tup_deleted_rate1m)","timeRangeSeconds":0,"avgDurationSeconds":0.006,"count":2},{"query":"count by (job, cls) (max by (cls, ins) (pg_in_recovery{}) == 0)","timeRangeSeconds":0,"avgDurationSeconds":0.005,"count":2},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.005,"count":60},{"query":"rate(pg_db_session_time[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.005,"count":1},{"query":"rate(node_netstat_TcpExt_ListenDrops[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.005,"count":1},{"query":"sum without(datname) (pg:db:ixact_time_rate15m)","timeRangeSeconds":0,"avgDurationSeconds":0.005,"count":4},{"query":"avg_over_time(node:ins:cpu_usage[15m])","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":3},{"query":"abs(node_timex_offset_seconds)","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":3},{"query":"rate(node_disk_read_bytes_total{device=~\"[a-z0-9A-Z-_]+\"}[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":3},{"query":"pgbouncer:ins:query_time_rate15m / on(ins) group_left pg:ins:cpu_count or (0 * pgbouncer_up - 1)","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":3},{"query":"sum without (list) (pgbouncer_list_items{list=\"login_clients\"})","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":2},{"query":"deriv(node:fs:avail_bytes[1h])","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":4},{"query":"pgbouncer_database_reserve_pool{datname!=\"pgbouncer\"}","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":6}],"topBySumDuration":[{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"sumDurationSeconds":0.643,"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.438,"count":60},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.313,"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.210,"count":60},{"query":"node:ins:cpu_count + on(ip) group_right() pg_up * 0","timeRangeSeconds":0,"sumDurationSeconds":0.198,"count":58},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"sumDurationSeconds":0.198,"count":60},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"sumDurationSeconds":0.195,"count":60},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.174,"count":60},{"query":"sum(patroni_failsafe_mode_is_active{}) > 0","timeRangeSeconds":0,"sumDurationSeconds":0.163,"count":60},{"query":"node:ins:cpu_usage_1m + on(ip) group_right() pg_up * 0","timeRangeSeconds":0,"sumDurationSeconds":0.158,"count":75},{"query":"up{job=\"infra\"}","timeRangeSeconds":0,"sumDurationSeconds":0.142,"count":16},{"query":"sum by (job) (node:cls:cpu_usage * node:cls:cpu_count) / sum by (job) (node:cls:cpu_count)","timeRangeSeconds":0,"sumDurationSeconds":0.142,"count":60},{"query":"histogram_quantile(0.95, rate(etcd_network_peer_round_trip_time_seconds_bucket{job=\"etcd\"}[5m]))","timeRangeSeconds":0,"sumDurationSeconds":0.138,"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.134,"count":56},{"query":"pgbouncer_database_pool_size{datname!=\"pgbouncer\"} + pgbouncer_database_reserve_pool{datname!=\"pgbouncer\"}","timeRangeSeconds":0,"sumDurationSeconds":0.123,"count":35},{"query":"etcd_up \u003c 1","timeRangeSeconds":0,"sumDurationSeconds":0.120,"count":32},{"query":"pg:db:ixact_time_rate5m / (pg:db:active_time_rate5m + pg:db:ixact_time_rate5m)","timeRangeSeconds":0,"sumDurationSeconds":0.107,"count":57},{"query":"pg:ins:lag_bytes > 1048576 or pg:ins:lag_seconds > 1","timeRangeSeconds":0,"sumDurationSeconds":0.106,"count":39},{"query":"sum without (type, client_api_version) (increase(etcd_server_client_requests_total{job=\"etcd\"}[1m]))","timeRangeSeconds":0,"sumDurationSeconds":0.103,"count":37},{"query":"pg:db:ixact_time_rate1m / (pg:db:active_time_rate1m + pg:db:ixact_time_rate1m)","timeRangeSeconds":0,"sumDurationSeconds":0.101,"count":58}],"topByAvgMemoryUsage":[{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"avgMemoryBytes":390144,"count":60},{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"avgMemoryBytes":390144,"count":60},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"avgMemoryBytes":130048,"count":60},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"avgMemoryBytes":130048,"count":60},{"query":"histogram_quantile(0.95, rate(etcd_network_peer_round_trip_time_seconds_bucket{job=\"etcd\"}[5m]))","timeRangeSeconds":0,"avgMemoryBytes":103632,"count":60},{"query":"sum without (mode) (pg_lock_count)","timeRangeSeconds":0,"avgMemoryBytes":73152,"count":40},{"query":"sum without (datname) (pg_lock_count)","timeRangeSeconds":0,"avgMemoryBytes":73152,"count":52},{"query":"histogram_quantile(0.95, rate(etcd_disk_backend_commit_duration_seconds_bucket{job=\"etcd\"}[5m]))","timeRangeSeconds":0,"avgMemoryBytes":45720,"count":43},{"query":"sum without (mode) (pg_lock_count{mode!~\"AccessShareLock|RowShareLock|RowExclusiveLock\"})","timeRangeSeconds":0,"avgMemoryBytes":45720,"count":21},{"query":"histogram_quantile(0.95, rate(etcd_disk_wal_fsync_duration_seconds_bucket{job=\"etcd\"}[5m]))","timeRangeSeconds":0,"avgMemoryBytes":45720,"count":45},{"query":"sum by (cls,proxy) (haproxy_server_status{state=\"UP\", proxy!=\u0027stats\u0027}) > bool 0","timeRangeSeconds":0,"avgMemoryBytes":33528,"count":15},{"query":"sum by (ins,proxy) (haproxy_server_status{state=\"UP\", proxy!=\u0027stats\u0027}) > bool 0","timeRangeSeconds":0,"avgMemoryBytes":33528,"count":14},{"query":"sum by (job, cls, mode) (pg:ins:locks)","timeRangeSeconds":0,"avgMemoryBytes":24384,"count":19},{"query":"sum without(mode) (pg:ins:locks)","timeRangeSeconds":0,"avgMemoryBytes":24384,"count":12},{"query":"sum without(datname) (pg_size_bytes)","timeRangeSeconds":0,"avgMemoryBytes":21336,"count":3},{"query":"sum without(state) (pg_activity_count{state=~\"idle in.*\"})","timeRangeSeconds":0,"avgMemoryBytes":18288,"count":5},{"query":"sum without (mode) (pg_lock_count{mode=~\"RowShareLock|RowExclusiveLock\"})","timeRangeSeconds":0,"avgMemoryBytes":18288,"count":6},{"query":"rate(node_schedstat_waiting_seconds_total[1m])","timeRangeSeconds":0,"avgMemoryBytes":16256,"count":32},{"query":"avg without (cpu) (node:cpu:sched_wait_rate1m)","timeRangeSeconds":0,"avgMemoryBytes":16256,"count":13},{"query":"avg_over_time(node:cpu:usage[1m])","timeRangeSeconds":0,"avgMemoryBytes":16256,"count":28}]}