Rules

The following is a summary of rules and advisories available out-of-the-box with the PostgreSQL cartridge. Default threshold values can be changed or scoped to specific values, generally through registry variables. These rules can be copied, modified, disabled, or customized in a wide variety of ways. For more information, refer to Working with Alarms.

This section describes the following rules and advisories:


Rules

Approaching Connection Limit

Alerts if the connection count is approaching capacity.

Backend Write Percentage High

Alerts if the backend write percentage is too high.

DB Running Out of Disk Space

Alerts if the average growth of the tablespaces will cause the database server to fill up in the near term.

High Average Response Time for Statement

Alert if the average wait time for a statement is significantly longer than its historical average.

High Percentage of Queries Waiting

Alerts if the percentage of queries in a waiting state is too high.

Index Bloat

Alerts if the total index size for a table is too large compared to the total table size.

Logical Replication Slot in Conflicted State

Alerts if logical replication slot has become conflicted.

Low Buffer Hit Percentage – Database

Alerts if the buffer hit percentage has been too low recently.

Low Buffer Hit Percentage – Table

Alerts if the buffer hit percentage has been too low recently.

Low Percent of Checkpoints Required

Alerts if a low percentage of checkpoints that are being performed are actually required.

PostgreSQL Server Availability

Alerts if the agent has not been able to connect to the PostgreSQL database server.

Potential Deadlock Issue

Alerts if there are any ungranted locks older than the deadlock timeout setting.

Replication Lag

Alerts if the difference in WAL segments between your primary’s sent_location and standby server’s replay_location is too great.

Replication Slot Approaching WAL Reservation Limit

Alerts if safe_wal_size is approaching 0, assuming max_slot_wal_keep_size is not unlimited.

Replication Slot Count at Maximum

Alerts with warning if replication slot count is at max_replication_slots or less than PG_SlotCountAvailableWarn percentage, whichever is greater.

Replication Slot Trx Exceeding logical_decoding_work_mem

Alerts if a significant percentage of transaction data for a logical replication slot is exceeding available memory.

Replication Slot WAL Status

Alerts if WAL Status of replication slot is not in reserved state.

Slow Connection

Alerts if it has been taking too long to establish a connection to the PostgreSQL server.


Advisories

Autoanalyze Monitoring

Checks for tables that may be experiencing auto analyze issues.

Autovacuum Memory Tuning

Checks for adequate memory allocation to autovacuum process based on largest table size.

Autovacuum Monitoring

Checks for tables that may be experiencing autovacuuming issues.

Backend Buffer Writes

Checks for a high percentage of buffer writes by backends.

Connection Optimization

Checks for average connection usage close to max_connections.

High Frequency Query Tuning

Shows 10 most frequently executed queries in the last week.

Possible Need for Indexes

Checks for large tables that would possibly benefit from creating indexes.

Slow Query Tuning

Shows 10 slowest queries by average time executed in the last week.

Tuning Memory Allocation For Caching

Checks for high number of pending I/O requests.

Tuning Memory Allocation For Sorting

Checks for queries writing to temporary disk files.