I had used the sql-exporter for getting hang job on Camunda at production. Uses db postgresql. I view hang job on Camunda for debugging.

Prometheus-config for sql-exporter has the type:

global:
  scrape_interval: 15s # By default, scrape targets every 15 seconds.
  evaluation_interval: 15s # By default, scrape targets every 15 seconds.

# Load and evaluate rules in this file every 'evaluation_interval' seconds.
rule_files:
  # - "first.rules"
  # - "second.rules"

# A scrape configuration containing exactly one endpoint to scrape:
# Here it's Prometheus itself.
scrape_configs:
  # The job name is added as a label `job=` to any timeseries scraped from this config.
  - job_name: "prometheus"

    # Override the global default and scrape targets from this job every 5 seconds.
    scrape_interval: 55s
    scrape_timeout: 5s

    static_configs:
      - targets: ["localhost:9090"]
        labels:
          stand: "PROD"
          service_name: "prometheus"
  - job_name: 'sql_exporter'
    scrape_interval: 60s
    metrics_path: /metrics
    static_configs:
    - targets: ['sql_exporter_worker:9237']

Which is the scrape interval to use in global and job for detail debugging information in Grafana?