From 7681d83680e3c75830b00f0ba129e5b324ed05ea Mon Sep 17 00:00:00 2001 From: Tom Hughes Date: Tue, 2 May 2023 21:43:34 +0100 Subject: [PATCH] Add postgres metric for active WAL segments --- .../postgresql/templates/default/postgres_queries.yml.erb | 8 ++++++++ 1 file changed, 8 insertions(+) diff --git a/cookbooks/postgresql/templates/default/postgres_queries.yml.erb b/cookbooks/postgresql/templates/default/postgres_queries.yml.erb index 37d854f77..daf3fa5a1 100644 --- a/cookbooks/postgresql/templates/default/postgres_queries.yml.erb +++ b/cookbooks/postgresql/templates/default/postgres_queries.yml.erb @@ -135,3 +135,11 @@ pg_unfrozen_ids: - mxid_age: usage: "GAUGE" description: "Age of the oldest unfrozen multixact ID in this database" + +pg_wal: + query: "SELECT count(*) AS segment_count FROM pg_ls_waldir() WHERE name ~ '^[0-9A-Z]{24}$'" + master: true + metrics: + - segment_count: + usage: "GAUGE" + description: "Number of WAL segments" -- 2.39.5