Enable postgres prometheus exporter

1 files changed, 16 insertions, 0 deletions

diff --git a/host/Rory-nginx/services/postgres.nix b/host/Rory-nginx/services/postgres.nix
index 68b822b..38a8ef8 100755
--- a/host/Rory-nginx/services/postgres.nix
+++ b/host/Rory-nginx/services/postgres.nix
@@ -80,4 +80,20 @@
     };
   };
 
+  services.prometheus.exporters.postgres = {
+    enable = true;
+    port = 9187;
+    extraFlags = [
+      "--collector.database_wraparound"
+      "--collector.long_running_transactions"
+      "--collector.postmaster"
+      "--collector.process_idle"
+      "--collector.stat_activity_autovacuum"
+      "--collector.stat_statements"
+      #"--collector.stat_wal_receiver" #we dont have WAL receivers
+      "--collector.statio_user_indexes"
+      "--collector.xlog_location"
+    ];
+  };
+
 }