D4635.diff
No OneTemporary
Actions

Size

1 KB

Subscribers

None

D4635.diff
View Options

	diff --git a/site-modules/profile/files/prometheus/sql/config/queries.yml b/site-modules/profile/files/prometheus/sql/config/queries.yml
	--- a/site-modules/profile/files/prometheus/sql/config/queries.yml
	+++ b/site-modules/profile/files/prometheus/sql/config/queries.yml
	@@ -222,6 +222,7 @@
	COALESCE(analyze_count, 0)::float AS analyze_count,
	COALESCE(autoanalyze_count, 0)::float AS autoanalyze_count
	FROM pg_stat_user_tables FULL JOIN (VALUES(0)) filler(i) ON TRUE
	+ WHERE schemaname not like 'pg_temp%'

	- name: "pg_statio_user_tables"
	help: "IO statistics"
	@@ -245,6 +246,7 @@
	COALESCE(idx_blks_read::float, 0) AS idx_blks_read,
	COALESCE(idx_blks_hit::float, 0) AS idx_blks_hit
	FROM pg_statio_user_tables FULL JOIN (VALUES(0)) filler(i) ON TRUE
	+ WHERE schemaname not like 'pg_temp%'

	- name: "BufferAccess"
	help: "buffer access statistics"
	@@ -269,6 +271,7 @@
	+ COALESCE(tidx_blks_hit, 0)
	+ COALESCE(tidx_blks_read, 0)) * 8192::bigint as reads
	FROM pg_statio_user_tables FULL JOIN (VALUES(0)) filler(i) ON TRUE
	+ WHERE schemaname not like 'pg_temp%'
	GROUP BY 1, 2, 3

	- name: "Maintenancecounters"
	@@ -289,3 +292,4 @@
	COALESCE(SUM(analyze_count), 0) analyze_count,
	COALESCE(SUM(autoanalyze_count), 0) autoanalyze_count
	FROM pg_stat_user_tables
	+ WHERE schemaname not like 'pg_temp%'