PostgreSQLExporterScrapingLimit #

Meaning #

Alert is triggered when Prometheus takes too long to fetch the PostgreSQL exporter metrics

Impact #

The monitoring system is degraded. PostgreSQL exporter does not collect PostgreSQL metrics, alerts cannot be triggered.

Diagnosis #

1. Check CPU and IOPS usage of the PostgreSQL server

   An overloaded server may have difficulty collecting metrics.

2. Check prometheus-postgresql-exporter logs

Mitigation #

1. Identify and kill heavy queries

   How terminate a query?

   SELECT
       pg_terminate_backend(pid),
       usename,
       datname,
       application_name,
       client_addr,
       client_port,
       state,
       wait_event_type,
       wait_event,
       state_change,
       query
   FROM pg_stat_activity
   WHERE pid = <replace_with_pid>;
   

Additional resources #

n/a