Skip to main content
Sumo Logic

PostgreSQL Alerts

This page lists the Alerts for PostgreSQL

Sumo Logic provides out of the box alerts available via Sumo Logic monitors. These alerts are built based on logs and metrics datasets and have preset thresholds based on industry best practices and recommendations.

Sumo Logic provides the following out-of-the-box alerts for PostgreSQL:

 

Alert Name Alert Description and conditions Alert Condition Recover Condition
PostgreSQL - Instance Down This alert fires when the Postgres instance is down >=1 < 1
PostgreSQL - TooManyConnections This alert fires when we detect that a PostgreSQL instance has too many (90% of allowed) connections) >= 90 < 90
PostgreSQL - SlowQueries This alert fires when we detect that the PostgreSQL instance is executing slow queries >= 1 < 1
PostgreSQL - Commit Rate Low This alert fires when we detect that Postgres seems to be processing very few transactions. commit rate < 10 commit rate >= 10
PostgreSQL - High Rate of Statement Timeout This alert fires when we detect Postgres transactions show a high rate of statement timeouts timeout rate > 3 timeout rate < 3
PostgreSQL - High Rate Deadlock This alert fires when we detect deadlocks in a Postgres instance deadlock rate >=1 deadlock rate <1
PostgreSQL - High Replication Lag This alert fires when we detect that the Postgres Replication lag (in bytes) is high. > 1000000000 bytes < 1000000000 bytes
PostgreSQL - SSL Compression Active This alert fires when we detect database connections with SSL compression are enabled. This may add significant jitter in replication delay. Replicas should turn off SSL compression via `sslcompression=0` in `recovery.conf` > 0 <= 0
PostgreSQL - Too Many Locks Acquired This alert fires when we detect that there are too many locks acquired on the database. If this alert happens frequently, you may need to increase the postgres setting max_locks_per_transaction. > 20 percent of max allowed locks assuming default max connection = 100 and max_locks per transaction = 64

< 20 percent of max allowed locks

PostgreSQL - Access from Highly Malicious Sources This alert will fire when a Postgres instance is accessed from known malicious IP addresses. > 0 <= 0