NIP: Postgres connections high
Alert: NipPostgresConnectionsHigh ยท Severity: Warning
What this means
Active connections >80% of max_connections for 3+ minutes.
Fix
- Grafana / Prometheus:
pg_stat_activity_count,pg_settings_max_connections. - On server:
docker exec inward_dev-db-1 psql -U $USER -d $DB -c "SELECT count(*), state FROM pg_stat_activity GROUP BY 2;" - Look for idle-in-transaction or connection leaks from web/celery.
- Escalate to app team before raising
max_connectionsblindly.
Escalate if
New transfers fail with "too many connections".