supabase-postgres.git / summary / log / commit / refs

commit    56fa7aceadeaf4549065b3a5c1a56ae4cfbeea52
Author:   Paul Cioanca <paul.cioanca@supabase.io>
Commit:   GitHub <noreply@github.com>
Date:     Tue May 14 08:44:46 2024 +0000

    chore: add metric for pending WAL files to be archived (#970)


 docker/all-in-one/opt/postgres_exporter/queries.yml | 9 +++++++++
 1 file changed, 9 insertions(+)

diff --git a/docker/all-in-one/opt/postgres_exporter/queries.yml b/docker/all-in-one/opt/postgres_exporter/queries.yml
index 83cfeed4..fe065247 100644
--- a/docker/all-in-one/opt/postgres_exporter/queries.yml
+++ b/docker/all-in-one/opt/postgres_exporter/queries.yml
@@ -170,6 +170,15 @@ pg_stat_statements:
         usage: "COUNTER"
         description: "Total time spent, in seconds"
 
+pg_ls_archive_statusdir:
+  master: true
+  cache_seconds: 60
+  query: "select count(*) as wal_pending_count from pg_ls_archive_statusdir() where name like '%.ready'"
+  metrics:
+    - wal_pending_count:
+        usage: "COUNTER"
+        description: "Number of not yet archived WAL files"
+         
 auth_users:
   master: true
   cache_seconds: 60


[parent: 014029aa5046]