{"topN":"20","maxLifetime":"10m0s","search.queryStats.lastQueriesCount":20000,"search.queryStats.minQueryDuration":"1ms","topByCount":[{"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":"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":56},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"count":52},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"count":31},{"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":31},{"query":"sum by (job) (node:cls:cpu_usage * node:cls:cpu_count) / sum by (job) (node:cls:cpu_count)","timeRangeSeconds":0,"count":24},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"count":17},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"count":16},{"query":"time() - node_boot_time_seconds","timeRangeSeconds":0,"count":6},{"query":"avg_over_time(node:cpu:usage[1m])","timeRangeSeconds":0,"count":5},{"query":"pg:db:age > 0.80","timeRangeSeconds":0,"count":4},{"query":"sum(patroni_failsafe_mode_is_active{}) > 0","timeRangeSeconds":0,"count":4},{"query":"sum(kafka:topic:msg_rate1m) without (topic)","timeRangeSeconds":0,"count":4},{"query":"sum by (job) (node:ins:cpu_count)","timeRangeSeconds":0,"count":3},{"query":"up{instance=~\".*:9100\"}","timeRangeSeconds":0,"count":3},{"query":"(pg_db_conn_limit != -1 ) or (0 * pg_db_conn_limit + on(cls, ins) group_left pg_setting_max_connections)","timeRangeSeconds":0,"count":3},{"query":"node:ins:cpu_count + on(ip) group_right() pg_up * 0","timeRangeSeconds":0,"count":3},{"query":"sum without (partition) (rate(kafka_topic_partition_current_offset{}[1m]))","timeRangeSeconds":0,"count":3},{"query":"max by (ip)(node:fs:space_usage)+ on(ip) group_right() pg_up * 0","timeRangeSeconds":0,"count":3}],"topByAvgDuration":[{"query":"rate(pg_table_tup_read{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pigsty.host_var\"}[1m])","timeRangeSeconds":3600,"avgDurationSeconds":0.026,"count":1},{"query":"pg_table_ncols{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pigsty.host_var\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.018,"count":1},{"query":"pg_table_age{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pigsty.host_var\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.018,"count":1},{"query":"pg_table_tuples{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pigsty.host_var\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.014,"count":1},{"query":"rate(pg_table_seq_scan{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pigsty.host_var\"}[5m])","timeRangeSeconds":3600,"avgDurationSeconds":0.013,"count":1},{"query":"min by (ins,ip) (pg_in_recovery{cls=\"pg-meta\"})","timeRangeSeconds":0,"avgDurationSeconds":0.011,"count":1},{"query":"count(ALERTS{alertstate=\"firing\"}) by (alertname, severity)","timeRangeSeconds":10800,"avgDurationSeconds":0.010,"count":1},{"query":"sum by (job, cls) (pg:ins:xact_commit_rate5m)","timeRangeSeconds":0,"avgDurationSeconds":0.010,"count":1},{"query":"sum by (ins,instance) (haproxy_backend_current_sessions{cls=\"pg-meta\", proxy!=\"stats\"})","timeRangeSeconds":0,"avgDurationSeconds":0.008,"count":1},{"query":"sum by (ins) (pg:ins:xact_total_rate1m{cls=\"pg-meta\"})","timeRangeSeconds":0,"avgDurationSeconds":0.008,"count":1},{"query":"pg_table_n_tup_mod{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pigsty.host_var\"}\n/( 1 + pg_table_tup_read{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pigsty.host_var\"})","timeRangeSeconds":3600,"avgDurationSeconds":0.007,"count":1},{"query":"pg_table_size_bytes{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pigsty.host_var\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.006,"count":1},{"query":"pg:cls:partition != 1","timeRangeSeconds":0,"avgDurationSeconds":0.006,"count":2},{"query":"sum by (relname) (pg_table_size_bytes{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgDurationSeconds":0.005,"count":1},{"query":"rate(pg_table_idx_scan{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pigsty.host_var\"}[5m])","timeRangeSeconds":3600,"avgDurationSeconds":0.005,"count":1},{"query":"sum by (relname) (pg_table_n_live_tup{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgDurationSeconds":0.005,"count":1},{"query":"pg_table_relid{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pigsty.host_var\"}","timeRangeSeconds":3600,"avgDurationSeconds":0.005,"count":1},{"query":"sum by (relname) (pg:table:scan_rate1m{ins=\"pg-meta-1\", datname=\"meta\"})","timeRangeSeconds":0,"avgDurationSeconds":0.005,"count":1},{"query":"max by (ip)(node:fs:space_usage)+ on(ip) group_right() pg_up * 0","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":3},{"query":"sum by (job, cls) (pg:ins:cpu_usage_1m * pg:ins:cpu_count) / pg:cls:cpu_count","timeRangeSeconds":0,"avgDurationSeconds":0.004,"count":1}],"topBySumDuration":[{"query":"rate(pg_query_exec_time[1m]) / pg:query:call_rate1m","timeRangeSeconds":0,"sumDurationSeconds":0.203,"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.150,"count":60},{"query":"1 - node:cpu:idle_time_irate1m / node:cpu:total_time_irate1m","timeRangeSeconds":0,"sumDurationSeconds":0.076,"count":52},{"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.071,"count":56},{"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.060,"count":31},{"query":"rate(pg_query_calls[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.060,"count":31},{"query":"sum without (mode) (node:cpu:time_irate1m)","timeRangeSeconds":0,"sumDurationSeconds":0.037,"count":16},{"query":"irate(node_cpu_seconds_total[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.036,"count":17},{"query":"sum by (job) (node:cls:cpu_usage * node:cls:cpu_count) / sum by (job) (node:cls:cpu_count)","timeRangeSeconds":0,"sumDurationSeconds":0.029,"count":24},{"query":"rate(pg_table_tup_read{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pigsty.host_var\"}[1m])","timeRangeSeconds":3600,"sumDurationSeconds":0.026,"count":1},{"query":"pg_table_ncols{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pigsty.host_var\"}","timeRangeSeconds":3600,"sumDurationSeconds":0.018,"count":1},{"query":"pg_table_age{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pigsty.host_var\"}","timeRangeSeconds":3600,"sumDurationSeconds":0.018,"count":1},{"query":"avg_over_time(node:cpu:usage[1m])","timeRangeSeconds":0,"sumDurationSeconds":0.015,"count":5},{"query":"pg_table_tuples{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pigsty.host_var\"}","timeRangeSeconds":3600,"sumDurationSeconds":0.014,"count":1},{"query":"max by (ip)(node:fs:space_usage)+ on(ip) group_right() pg_up * 0","timeRangeSeconds":0,"sumDurationSeconds":0.013,"count":3},{"query":"rate(pg_table_seq_scan{ins=\"pg-meta-1\", datname=\"meta\", relname=\"pigsty.host_var\"}[5m])","timeRangeSeconds":3600,"sumDurationSeconds":0.013,"count":1},{"query":"up{instance=~\".*:9100\"}","timeRangeSeconds":0,"sumDurationSeconds":0.011,"count":3},{"query":"pg:cls:partition != 1","timeRangeSeconds":0,"sumDurationSeconds":0.011,"count":2},{"query":"min by (ins,ip) (pg_in_recovery{cls=\"pg-meta\"})","timeRangeSeconds":0,"sumDurationSeconds":0.011,"count":1},{"query":"count(ALERTS{alertstate=\"firing\"}) by (alertname, severity)","timeRangeSeconds":10800,"sumDurationSeconds":0.010,"count":1}]}