Runbook: ConnectionThresholdReached Alert

Alert Details

• Alert Name: ConnectionThresholdReached
• Expression: sum without (datname, datid) (pg_stat_database_numbackends{datname!~"template.*"}) / (sum without (server) (pg_settings_max_connections)) * 100 >= 80

Description

This alert triggers when the currently established connections to a database host is equal or higher than 80% of the possible maximum connections of the server.

Possible Causes

• number of connected clients is at near the limit
• High Infrastructure load

Troubleshooting Steps

1. Reduce number of clients

2. Increase max_connections (check memory first!)