Runbook: ExporterDown Alert

Alert Details

  • Alert Name: ExporterDown
  • Expression: pg_up == 0

Description

Alert is triggered when the SQL exporter don’t report being up.

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

Possible Causes

  1. prostgresql host down

Troubleshooting Steps

1. Look at SQL exporter logs.

The error messages (level=error) should explain why the exporter can’t scrape metrics.

Usually, the exporter can’t connect to the PostgreSQL server due to network restrictions, authentication failure, missing permissions or timeout.

PostgreSQL required permissions

The SQL exporter needs pg_monitor role and LOGIN options.

2. Look at PostgreSQL connection logs

You’ll get an error message if PostgreSQL exporter connections are rejected by PostgreSQL.

3. Check memory usage

Sometimes, when target number is too high, the pod can be OOMKilled.

Additional resources