From e3c0b6d6091bec87edf709c9d444c825045c8d3d Mon Sep 17 00:00:00 2001
From: Martin Fischer <martin@push-f.com>
Date: Thu, 18 Sep 2025 08:45:19 +0200
Subject: refactor: make db-size collector reusable

---
 nixos/shared/postgres-collectors.nix | 22 ++++++++++++++++++++++
 1 file changed, 22 insertions(+)
 create mode 100644 nixos/shared/postgres-collectors.nix

(limited to 'nixos/shared/postgres-collectors.nix')

diff --git a/nixos/shared/postgres-collectors.nix b/nixos/shared/postgres-collectors.nix
new file mode 100644
index 0000000..fd44cb0
--- /dev/null
+++ b/nixos/shared/postgres-collectors.nix
@@ -0,0 +1,22 @@
+# collectors for the prometheus-sql-exporter
+{ config, lib, pkgs, ... }:
+
+{
+  collectorNames = ["db-sizes"];
+
+  collectors = [
+    {
+      collector_name = "db-sizes";
+      metrics = [
+        {
+          metric_name = "pg_db_size_bytes";
+          help = "disk space used by the database";
+          type = "gauge";
+          key_labels = ["database_name"];
+          values = ["size"];
+          query = "SELECT datname AS database_name, pg_database_size(datname) as size from pg_database";
+        }
+      ];
+    }
+  ];
+}
-- 
cgit v1.2.3