nixos/shared/postgres-collectors.nix


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
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";
        }
      ];
    }
  ];
}