Alerts (PostgreSQL)

The Management Pack for PostgreSQL pulls PostgreSQL database health indicators and displays them in vRealize Operations as alerts. See the table below for the list of alerts available in the Management Pack.

Alerts List

Name	Description	Recommendation
Max Written Clean (Per Second) is Higher than Normal	The number of times the background writer has overwritten the maximum number of buffers (when a checkpoint is performed) is much higher than normal.	Consider increasing the value of “bgwriter_lru_maxpages” in postgresql.conf to increase performance.
Tablespace Size is Higher than Normal	The size of your Database is much higher than normal	Consider running a VACUUM to recover disk space.
Database Size is Higher than Normal	The size of your Database is much higher than normal	Consider running a VACUUM to recover disk space.
Table Size is Higher than Normal	The size of your Table is much higher than normal	Consider running a VACUUM to recover disk space.
Temp Files Created is Higher than Normal	The number of temporary files created is higher than normal. This can cause slower performance and I/O contention.	Consider increasing the “work_mem” in the postgresql.conf file.
Dead Rows is Higher than Normal	The dead rows for this table are higher than normal.	To clear the dead rows, consider running “VACUUM FULL” or “CLUSTER” during a maintenance window.
Queries Cancelled are Higher than Normal	The number of queries that are being cancelled is higher than normal.	Consider enabling “hot_standby_feedback” in the postgresql.conf file to avoid cancelled queries. Warning: This could create bloat in the primary database.