From: Tom Hughes <tom@compton.nu>
Date: Tue, 2 May 2023 20:43:34 +0000 (+0100)
Subject: Add postgres metric for active WAL segments
X-Git-Url: https://git.openstreetmap.org./chef.git/commitdiff_plain/7681d83680e3c75830b00f0ba129e5b324ed05ea

Add postgres metric for active WAL segments
---

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"