# 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";
        }
      ];
    }
  ];
}