Runbook: MaxConnectionsReached Alert

Alert Details

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

Description

Alert is triggered when the number of connected clients is at the limit of possible connections.

Possible Causes

• number of connected clients is at the limit of possible connections

Troubleshooting Steps

1. Reduce number of clients

2. Increase max_connections (check memory first!)

• AWS->services->aurora and rds-> paramaeter group -> $database -> paramaters -> max_connections