{"topN":"20","maxLifetime":"10m0s","search.queryStats.lastQueriesCount":20000,"search.queryStats.minQueryDuration":"1ms","search.queryStats.minQueryMemoryUsage":"1024","topByCount":[{"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_calls[1m])","timeRangeSeconds":0,"count":60},{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"count":60},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"count":60},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"count":58},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"count":49},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"count":47},{"query":"sum(patroni_failsafe_mode_is_active{}) > 0","timeRangeSeconds":0,"count":36},{"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":35},{"query":"pg_up \u003c 1","timeRangeSeconds":0,"count":15},{"query":"pgbouncer_up \u003c 1","timeRangeSeconds":0,"count":15},{"query":"node:dev:disk_read_time_rate1m + node:dev:disk_write_time_rate1m","timeRangeSeconds":0,"count":13},{"query":"pgbouncer_exporter_agent_up \u003c 1","timeRangeSeconds":0,"count":10},{"query":"pg_exporter_agent_up \u003c 1","timeRangeSeconds":0,"count":10},{"query":"pg:ins:lag_bytes > 1048576 or pg:ins:lag_seconds > 1","timeRangeSeconds":0,"count":8},{"query":"patroni_up \u003c 1","timeRangeSeconds":0,"count":8},{"query":"up{instance=~\".*:9598\"}","timeRangeSeconds":0,"count":7},{"query":"pg_uptime \u003c 300","timeRangeSeconds":0,"count":7},{"query":"node:dev:disk_read_time_rate1m / node:dev:disk_reads_rate1m","timeRangeSeconds":0,"count":6}],"topByAvgDuration":[{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"avgDurationSeconds":0.006,"count":60},{"query":"pg:ins:active_time_rate1m / pg:ins:cpu_count or (0 * pg_up - 1)","timeRangeSeconds":0,"avgDurationSeconds":0.006,"count":1},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.005,"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,"avgDurationSeconds":0.004,"count":60},{"query":"min(etcd_server_has_leader) by (cls) \u003c 1","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":2},{"query":"sum without (datname) (pg:db:db_size)","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":1},{"query":"infra_up \u003c 1","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":1},{"query":"clamp_min(max without (instance) (pg:ins:cpu_usage_5m > pg:ins:saturation5 or pg:ins:saturation5), 0)","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":1},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":60},{"query":"clamp_min(max without (instance) (pg:ins:cpu_usage_1m > pg:ins:saturation1 or pg:ins:saturation1), 0)","timeRangeSeconds":0,"avgDurationSeconds":0.003,"count":2},{"query":"node:dev:disk_read_bytes_rate1m / node:dev:disk_reads_rate1m","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"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,"avgDurationSeconds":0.002,"count":35},{"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,"avgDurationSeconds":0.002,"count":60},{"query":"count without (cpu) (node:cpu:usage)","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"node:dev:disk_read_bytes_rate1m + node:dev:disk_write_bytes_rate1m","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":5},{"query":"rate(node_schedstat_waiting_seconds_total[1m])","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":5},{"query":"avg_over_time(node:cpu:usage[5m])","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":2},{"query":"pg:ins:ixact_time_rate1m / (pg:ins:active_time_rate1m + pg:ins:ixact_time_rate1m)","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"max without (slot_name) (pg_slot_retained_bytes)","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":1},{"query":"node:ins:mem_avail \u003c 0.10","timeRangeSeconds":0,"avgDurationSeconds":0.002,"count":2}],"topBySumDuration":[{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"sumDurationSeconds":0.371,"count":60},{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.286,"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.269,"count":60},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.177,"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.140,"count":60},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"sumDurationSeconds":0.087,"count":58},{"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.083,"count":35},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.076,"count":47},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"sumDurationSeconds":0.068,"count":49},{"query":"sum(patroni_failsafe_mode_is_active{}) > 0","timeRangeSeconds":0,"sumDurationSeconds":0.059,"count":36},{"query":"pgbouncer_up \u003c 1","timeRangeSeconds":0,"sumDurationSeconds":0.025,"count":15},{"query":"pg_up \u003c 1","timeRangeSeconds":0,"sumDurationSeconds":0.020,"count":15},{"query":"node:dev:disk_read_time_rate1m + node:dev:disk_write_time_rate1m","timeRangeSeconds":0,"sumDurationSeconds":0.017,"count":13},{"query":"pgbouncer_exporter_agent_up \u003c 1","timeRangeSeconds":0,"sumDurationSeconds":0.013,"count":10},{"query":"pg_exporter_agent_up \u003c 1","timeRangeSeconds":0,"sumDurationSeconds":0.013,"count":10},{"query":"up{instance=~\".*:9598\"}","timeRangeSeconds":0,"sumDurationSeconds":0.012,"count":7},{"query":"node:dev:disk_read_bytes_rate1m + node:dev:disk_write_bytes_rate1m","timeRangeSeconds":0,"sumDurationSeconds":0.011,"count":5},{"query":"rate(node_schedstat_waiting_seconds_total[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.011,"count":5},{"query":"pg:ins:lag_bytes > 1048576 or pg:ins:lag_seconds > 1","timeRangeSeconds":0,"sumDurationSeconds":0.011,"count":8},{"query":"patroni_up \u003c 1","timeRangeSeconds":0,"sumDurationSeconds":0.010,"count":8}],"topByAvgMemoryUsage":[{"query":"rate(pg_table_tbl_scan[1m])","timeRangeSeconds":0,"avgMemoryBytes":743712,"count":60},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"avgMemoryBytes":322072,"count":60},{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"avgMemoryBytes":322072,"count":60},{"query":"histogram_quantile(0.95, rate(etcd_network_peer_round_trip_time_seconds_bucket{job=\"etcd\"}[5m]))","timeRangeSeconds":0,"avgMemoryBytes":103632,"count":2},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"avgMemoryBytes":97536,"count":47},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"avgMemoryBytes":97536,"count":49},{"query":"sum without (mode) (pg_lock_count)","timeRangeSeconds":0,"avgMemoryBytes":73152,"count":3},{"query":"sum without (mode) (pg_lock_count{mode!~\"AccessShareLock|RowShareLock|RowExclusiveLock\"})","timeRangeSeconds":0,"avgMemoryBytes":45720,"count":3},{"query":"up{job=\"infra\"}","timeRangeSeconds":0,"avgMemoryBytes":24384,"count":4},{"query":"sum by (job, cls, mode) (pg:ins:locks)","timeRangeSeconds":0,"avgMemoryBytes":24384,"count":1},{"query":"infra_up \u003c 1","timeRangeSeconds":0,"avgMemoryBytes":24384,"count":1},{"query":"sum without(datname) (pg:db:session_time_rate1m)","timeRangeSeconds":0,"avgMemoryBytes":15240,"count":1},{"query":"rate(pg_db_xact_total[15m])","timeRangeSeconds":0,"avgMemoryBytes":15240,"count":1},{"query":"sum without(datname) (pg:db:tup_inserted_rate1m)","timeRangeSeconds":0,"avgMemoryBytes":15240,"count":1},{"query":"increase(pg_db_temp_files[1m])","timeRangeSeconds":0,"avgMemoryBytes":15240,"count":1},{"query":"sum without (datname) (pg:db:db_size)","timeRangeSeconds":0,"avgMemoryBytes":15240,"count":1},{"query":"pg:db:conn_usage > 0.70","timeRangeSeconds":0,"avgMemoryBytes":15240,"count":2},{"query":"(2147483648 - pg_db_age) / pg:db:age_deriv1h","timeRangeSeconds":0,"avgMemoryBytes":15240,"count":1},{"query":"rate(pg_db_session_time[1m])","timeRangeSeconds":0,"avgMemoryBytes":15240,"count":1},{"query":"sum without(datname) (pg:db:xact_total_rate5m)","timeRangeSeconds":0,"avgMemoryBytes":15240,"count":1}]}