dar::backup::exclude:
  - srv/softwareheritage/postgres

# that's a mirror of the load on the host...
icinga2::host::vars:
  load: high

prometheus::sql::exporter::extra_config:
  - name: "SoftwareHeritageIndexerCounters"
    interval: '1h'
    connections:
    - 'postgres://postgres@:5434/softwareheritage-indexer?sslmode=disable'
    queries:
    - name: "swh_indexer_count"
      help: "Indexer count per type"
      labels:
        - "mimetype"
        - "fossology_license"
      values:
        - "count_mimetype"
        - "count_fossology_license"
      query:  |
               select 'mimetype',
                      (select count(*) from content_mimetype) as count_mimetype,
                      'fossology_license',
                      (select count(*) from content_fossology_license) as count_fossology_license;

dar::backup::exclude:
  - srv/softwareheritage/postgres

# that's a mirror of the load on the host...
icinga2::host::vars:
  load: high

prometheus::sql::exporter::extra_config:
  - name: "SoftwareHeritageIndexerCounters"
    interval: '1d'
    connections:
    - 'postgres://postgres@:5434/softwareheritage-indexer?sslmode=disable'
    queries:
    - name: "swh_indexer_count"
      help: "Indexer count per type"
      labels:
        - "mimetype"
        - "fossology_license"
      values:
        - "count_mimetype"
        - "count_fossology_license"
      query:  |
               select 'mimetype',
                      (select count(*) from content_mimetype) as count_mimetype,
                      'fossology_license',
                      (select count(*) from content_fossology_license) as count_fossology_license;

Reduce indexer counter frequency to 1 day
grafana: Reduce indexer counter frequency to 1 day

They do not run much currently so no need to refresh that frequently
