Alert Templates v7

An alert definition contains a system-defined or user-defined set of conditions that PEM compares to the system statistics; if the statistics deviate from the boundaries specified for that statistic, the alert triggers, and the PEM client displays a warning on the Alerts Overview page, and optionally sends a notification to a monitoring user.

The table below lists the system-defined alert templates that you can use to create an alert; please note that this list is subject to change, and may vary by system.

Within the table, the alerts are sorted by the target of the alert. The Template Name and Description columns identify and describe the behavior of the template. If the template Details column specifies Yes, metrics returned by the alert and alert parameters (if applicable) are accessible in the Alerts table on the Global Overview or Alerts dashboards:

Templates applicable on Agent

Template NameDescriptionDetails
Load Average (1 minute)1-minute system load average.
Load Average (5 minutes)5-minute system load average.
Load Average (15 minutes)15-minute system load average.
Load Average per CPU Core (1 minutes)1-minute system load average per CPU core.
Load Average per CPU Core (5 minutes)5-minute system load average per CPU core.
Load Average per CPU Core (15 minutes)15-minute system load average per CPU core.
CPU utilizationAverage CPU consumption.
Number of CPUs running higher than a thresholdNumber of CPUs running at greater than K% utilization.Yes
Free memory percentageFree memory as a percent of total system memory.
Memory used percentagePercentage of memory used.
Swap consumptionSwap space consumed (in megabytes).
Swap consumption percentagePercentage of swap area consumed.
Disk ConsumptionDisk space consumed (in megabytes).
Disk consumption percentagePercentage of disk consumed.
Disk AvailableDisk space available (in megabytes).
Disk busy percentagePercentage of disk busy.
Most used disk percentagePercentage used of the most utilized disk on the system.Yes
Total table bloat on hostThe total space wasted by tables on a host, in MB.
Highest table bloat on hostThe most space wasted by a table on a host, in MB.
Average table bloat on hostThe average space wasted by tables on host, in MB.
Table size on hostThe size of tables on host, in MB.
Database size on hostThe size of databases on host, in MB.
Number of ERRORS in the logfile on agent N in last X hoursThe number of ERRORS in the logfile on agent N in last X hours.
Number of WARNINGS in the logfile on agent N in last X hoursThe number of WARNINGS in the logfile on agent N in last X hours.
Number of WARNINGS or ERRORS in the logfile on agent N in last X hoursThe number of WARNINGS or ERRORS in the logfile on agent N in last X hours.
Package version mismatchCheck for package version mismatch as per catalog.Yes
Total materialized view bloat on hostThe total space wasted by materialized views on a host, in MB.
Highest materialized view bloat on hostThe most space wasted by a materialized view on a host, in MB.
Average materialized view bloat on hostThe average space wasted by materialized views on host, in MB.
Materialized view size on hostThe size of materialized views on host, in MB.
Agent DownSpecified agent is currently down.

Templates applicable on Server

Template NameDescriptionDetails
Total table bloat in serverThe total space wasted by tables in server, in MB.
Largest table (by multiple of unbloated size)Largest table in server, calculated as a multiple of its own estimated unbloated size; exclude tables smaller than N MB.
Highest table bloat in serverThe most space wasted by a table in server, in MB.Yes
Average table bloat in serverThe average space wasted by tables in server, in MB.
Table size in serverThe size of tables in server, in MB.Yes
Database size in serverThe size of databases in server, in MB.Yes
Number of WAL filesTotal number of Write Ahead Log files.
Number of prepared transactionsNumber of transactions in prepared state.
Total connectionsTotal number of connections in the server.Yes
Total connections as percentage of max_connectionsTotal number of connections in the server as a percentage of maximum connections allowed on server, settings.
Unused, non-superuser connectionsNumber of unused, non-superuser connections on the server, user_info, settings.
Unused, non-superuser connections as percentage of max_connectionsNumber of unused, non-superuser connections on the server as a percentage of max_connections, user_info, settings.
Ungranted locksNumber of ungranted locks in server.
Percentage of buffers written by backendsThe percentage of buffers written by backends vs. the total buffers written.
Percentage of buffers written by checkpointThe percentage of buffers written by the checkpoints vs. the total buffers written.
Buffers written per secondNumber of buffers written per second, over the last two probe cycles.
Buffers allocated per secondNumber of buffers allocated per second, over the last two probe cycles.
Connections in idle stateNumber of connections in server that are in idle state.Yes
Connections in idle-in-transaction stateNumber of connections in server that are in idle-in-transaction state.Yes
Connections in idle-in-transaction state,as percentage of max_connectionsNumber of connections in server that are in idle-in-transaction state, as a percentage of maximum connections allowed on server, settings
Long-running idle connectionsNumber of connections in the server that have been idle for more than N seconds.Yes
Long-running idle connections and idle transactionsNumber of connections in the server that have been idle or idle-in-transaction for more than N seconds.Yes
Long-running idle transactionsNumber of connections in the server that have been idle in transaction for more than N seconds.Yes
Long-running transactionsNumber of transactions in server that have been running for more than N seconds.Yes
Long-running queriesNumber of queries in server that have been running for more than N seconds. It does not include the long running vacuum or auto vacuum queries.Yes
Long-running vacuumsNumber of vacuum operations in server that have been running for more than N seconds.Yes
Long-running autovacuumsNumber of autovacuum operations in server that have been running for more than N seconds.Yes
Committed transactions percentagePercentage of transactions in the server that committed vs. that rolled-back over last N minutes.
Shared buffers hit percentagePercentage of block read requests in the server that were satisfied by shared buffers, over last N minutes.
Tuples insertedTuples inserted into server over last N minutes.
InfiniteCache buffers hit percentagePercentage of block read requests in the server that were satisfied by InfiniteCache, over last N minutes.
Tuples fetchedTuples fetched from server over last N minutes.
Tuples returnedTuples returned from server over last N minutes.
Dead TuplesNumber of estimated dead tuples in server.
Tuples updatedTuples updated in server over last N minutes.
Tuples deletedTuples deleted from server over last N minutes.
Tuples hot updatedTuples hot updated in server, over last N minutes.
Sequential ScansNumber of full table scans in server, over last N minutes.
Index ScansNumber of index scans in server, over last N minutes.
Hot update percentagePercentage of hot updates in the server over last N minutes.
Live TuplesNumber of estimated live tuples in server.
Dead tuples percentagePercentage of estimated dead tuples in server.
Last VacuumHours since last vacuum on the server.
Last AutoVacuumHours since last autovacuum on the server.
Last AnalyzeHours since last analyze on the server.
Last AutoAnalyzeHours since last autoanalyze on the server.
Percentage of buffers written by backends over last N minutesThe percentage of buffers written by backends vs. the total buffers written over last N minutes.
Table CountTotal number of tables in server.
Function CountTotal number of functions in server.
Sequence CountTotal number of sequences in server.
A user expires in N daysNumber of days before a user's validity expires.
Index size as a percentage of table sizeSize of the indexes in server, as a percentage of their tables' size.
Largest index by table-size percentageLargest index in server, calculated as percentage of its table's size, oc_index, table_size.
Number of ERRORS in the logfile on server M in the last X hoursThe number of ERRORS in the logfile on server M in last X hours.
Number of WARNINGS in the logfile on server M in the last X hoursThe number of WARNINGS in logfile on server M in the last X hours.
Number of WARNINGS or ERRORS in the logfile on server M in the last X hoursThe number of WARNINGS or ERRORS in the logfile on server M in the last X hours.
Number of attacks detected in the last N minutesThe number of SQL injection attacks occurred in the last N minutes.
Number of attacks detected in the last N minutes by usernameThe number of SQL injection attacks occurred in the last N minutes by username.
Number of replica servers lag behind the primary by write locationStreaming Replication: number of replica servers lag behind the primary by write location.Yes
Number of replica servers lag behind the primary by flush locationStreaming Replication: number of replica servers lag behind the primary by flush location.Yes
Number of replica servers lag behind the primary by replay locationStreaming Replication: number of replica servers lag behind the primary by replay location.Yes
Replica server lag behind the primary by write locationStreaming Replication: replica server lag behind the primary by write location in MB.Yes
Replica server lag behind the primary by flush locationStreaming Replication: replica server lag behind the primary by flush location in MB.Yes
Replica server lag behind the primary by WAL pagesStreaming Replication: replica server lag behind the primary by WAL pages.
Replica server lag behind the primary by WAL segmentsStreaming Replication: replica server lag behind the primary by WAL segments.
Replica server lag behind the primary by replay locationStreaming Replication: replica server lag behind the primary by replay location in MB.Yes
Replica server lag behind the primary by size (MB)Streaming Replication: replica server lag behind the primary by size in MB.Yes
Total materialized view bloat in serverThe total space wasted by materialized views in server, in MB.
Largest materialized view (by multiple of unbloated size)Largest materialized view in server, calculated as a multiple of its own estimated unbloated size; exclude materialized views smaller than N MB.
Highest materialized view bloat in serverThe most space wasted by a materialized view in server, in MB.
Average materialized view bloat in serverThe average space wasted by materialized views in server, in MB.
Materialized view size in serverThe size of materialized view in server, in MB.
View CountTotal number of views in server.
Materialized View CountTotal number of materialized views in server.
Audit config mismatchCheck for audit config parameter mismatchYes
Server DownSpecified server is currently inaccessible.
Number of WAL archives pendingStreaming Replication: number of WAL files pending to be replayed at replica.
Number of minutes lag of replica server from primary serverStreaming Replication: number of minutes replica node is lagging behind the primary node.
Log config mismatchCheck for log config parameter mismatch.Yes

Templates applicable on Database

Template NameDescriptionDetails
Total table bloat in databaseThe total space wasted by tables in database, in MB.
Largest table (by multiple of unbloated size)Largest table in database, calculated as a multiple of its own estimated unbloated size; exclude tables smaller than N MB.
Highest table bloat in databaseThe most space wasted by a table in database, in MB.
Average table bloat in databaseThe average space wasted by tables in database, in MB.
Table size in databaseThe size of tables in database, in MB.Yes
Database sizeThe size of the database, in MB.
Total connectionsTotal number of connections in the database.Yes
Total connections as percentage of max_connectionsTotal number of connections in the database as a percentage of maximum connections allowed on server, settings.
Ungranted locksNumber of ungranted locks in database.
Connections in idle stateNumber of connections in database that are in idle state.Yes
Connections in idle-in-transaction stateNumber of connections in database that are in idle-in-transaction state.Yes
Connections in idle-in-transaction state,as percentage of max_connectionsNumber of connections in database that are in idle-in-transaction state, as a percentage of maximum connections allowed on server, settings.
Long-running idle connectionsNumber of connections in the database that have been idle for more than N seconds.Yes
Long-running idle connections and idle transactionsNumber of connections in the database that have been idle or idle-in-transaction for more than N seconds.Yes
Long-running idle transactionsNumber of connections in the database that have been idle in transaction for more than N seconds.Yes
Long-running transactionsNumber of transactions in database that have been running for more than N seconds.Yes
Long-running queriesNumber of queries in database that have been running for more than N seconds. It does not include the long running vacuum or auto vacuum queries.Yes
Long-running vacuumsNumber of vacuum operations in database that have been running for more than N seconds.Yes
Long-running autovacuumsNumber of autovacuum operations in database that have been running for more than N seconds.Yes
Committed transactions percentagePercentage of transactions in the database that committed vs. that rolled-back over last N minutes.
Shared buffers hit percentagePercentage of block read requests in the database that were satisfied by shared buffers, over last N minutes.
InfiniteCache buffers hit percentagePercentage of block read requests in the database that were satisfied by InfiniteCache, over last N minutes.
Tuples fetchedTuples fetched from database over last N minutes.
Tuples returnedTuples returned from database over last N minutes.
Tuples insertedTuples inserted into database over last N minutes.
Tuples updatedTuples updated in database over last N minutes.
Tuples deletedTuples deleted from database over last N minutes.
Tuples hot updatedTuples hot updated in database, over last N minutes.
Sequential ScansNumber of full table scans in database, over last N minutes.
Index ScansNumber of index scans in database, over last N minutes.
Hot update percentagePercentage of hot updates in the database over last N minutes.
Live TuplesNumber of estimated live tuples in database.
Dead TuplesNumber of estimated dead tuples in database.
Dead tuples percentagePercentage of estimated dead tuples in database.
Last VacuumHours since last vacuum on the database.
Last AutoVacuumHours since last autovacuum on the database.
Last AnalyzeHours since last analyze on the database.
Last AutoAnalyzeHours since last autoanalyze on the database.
Table CountTotal number of tables in database.
Function CountTotal number of functions in database.
Sequence CountTotal number of sequences in database.
Index size as a percentage of table sizeSize of the indexes in database, as a percentage of their tables' size.
Largest index by table-size percentageLargest index in database, calculated as percentage of its table's size, oc_index, table_size
Database Frozen XIDThe age (in transactions before the current transaction) of the database's frozen transaction ID.
Number of attacks detected in the last N minutesThe number of SQL injection attacks occurred in the last N minutes.
Number of attacks detected in the last N minutes by usernameThe number of SQL injection attacks occurred in the last N minutes by username.
Queries that have been cancelled due to dropped tablespacesStreaming Replication: number of queries that have been cancelled due to dropped tablespaces.
Queries that have been cancelled due to lock timeoutsStreaming Replication: number of queries that have been cancelled due to lock timeouts.
Queries that have been cancelled due to old snapshotsStreaming Replication: number of queries that have been cancelled due to old snapshots.
Queries that have been cancelled due to pinned buffersStreaming Replication: number of queries that have been cancelled due to pinned buffers.
Queries that have been cancelled due to deadlocksStreaming Replication: number of queries that have been cancelled due to deadlocks.
Total events lagging in all slony clustersSlony Replication: total events lagging in all slony clusters.Yes
Events lagging in one slony clusterSlony Replication: events lagging in one slony cluster.
Lag time (minutes) in one slony clusterSlony Replication: lag time (minutes) in one slony cluster.
Total rows lagging in xdb single primary replicationxDB Replication: Total rows lagging in xdb single primary replicationYes
Total rows lagging in xdb multi primary replicationxDB Replication: Total rows lagging in xdb multi primary replicationYes
Total materialized view bloat in databaseThe total space wasted by materialized views in database, in MB.
Largest materialized view (by multiple of unbloated size)Largest materialized view in database, calculated as a multiple of its own estimated unbloated size; exclude materialized views smaller than N MB.
Highest materialized view bloat in databaseThe most space wasted by a materialized view in database, in MB.
Average materialized view bloat in databaseThe average space wasted by materialized views in database, in MB.
Materialized view size in databaseThe size of materialized view in database, in MB.
View CountTotal number of views in database.
Materialized View CountTotal number of materialized views in database.

Templates applicable on Schema

Template NameDescriptionDetails
Total table bloat in schemaThe total space wasted by tables in schema, in MB.Yes
Largest table (by multiple of unbloated size)Largest table in schema, calculated as a multiple of its own estimated unbloated size; exclude tables smaller than N MB.
Highest table bloat in schemaThe most space wasted by a table in schema, in MB.
Average table bloat in schemaThe average space wasted by tables in schema, in MB.
Table size in schemaThe size of tables in schema, in MB.Yes
Tuples insertedTuples inserted in schema over last N minutes.
Tuples updatedTuples updated in schema over last N minutes.
Tuples deletedTuples deleted from schema over last N minutes.
Tuples hot updatedTuples hot updated in schema, over last N minutes.
Sequential ScansNumber of full table scans in schema, over last N minutes.
Index ScansNumber of index scans in schema, over last N minutes.
Hot update percentagePercentage of hot updates in the schema over last N minutes.
Live TuplesNumber of estimated live tuples in schema.
Dead TuplesNumber of estimated dead tuples in schema.
Dead tuples percentagePercentage of estimated dead tuples in schema.
Last VacuumHours since last vacuum on the schema.
Last AutoVacuumHours since last autovacuum on the schema.
Last AnalyzeHours since last analyze on the schema.
Last AutoAnalyzeHours since last autoanalyze on the schema.
Table CountTotal number of tables in schema.
Function CountTotal number of functions in schema.
Sequence CountTotal number of sequences in schema.
Index size as a percentage of table sizeSize of the indexes in schema, as a percentage of their table's size.
Largest index by table-size percentageLargest index in schema, calculated as percentage of its table's size, oc_index, table_size
Materialized View bloatSpace wasted by the materialized view, in MB.
Total materialized view bloat in schemaThe total space wasted by materialized views in schema, in MB.
Materialized view size as a multiple of ubloated sizeSize of the materialized view as a multiple of estimated unbloated size.
Largest materialized view (by multiple of unbloated size)Largest materialized view in schema, calculated as a multiple of its own estimated unbloated size; exclude materialized view smaller than N MB.
Highest materialized view bloat in schemaThe most space wasted by a materialized view in schema, in MB.
Average materialized view bloat in schemaThe average space wasted by materialized views in schema, in MB.
Materialized view sizeThe size of materialized view, in MB.
Materialized view size in schemaThe size of materialized views in schema, in MB.
View CountTotal number of views in schema.
Materialized View CountTotal number of materialized views in schema.
Materialized View Frozen XIDThe age (in transactions before the current transaction) of the materialized view's frozen transaction ID.

Templates applicable on Table

Template NameDescriptionDetails
Table bloatSpace wasted by the table, in MB.
Table sizeThe size of table, in MB.
Table size as a multiple of ubloated sizeSize of the table as a multiple of estimated unbloated size.
Tuples insertedTuples inserted in table over last N minutes.
Tuples updatedTuples updated in table over last N minutes.
Tuples deletedTuples deleted from table over last N minutes.
Tuples hot updatedTuples hot updated in table, over last N minutes.
Sequential ScansNumber of full table scans on table, over last N minutes.
Index ScansNumber of index scans on table, over last N minutes.
Hot update percentagePercentage of hot updates in the table over last N minutes.
Live TuplesNumber of estimated live tuples in table.
Dead TuplesNumber of estimated dead tuples in table.
Dead tuples percentagePercentage of estimated dead tuples in table.
Last VacuumHours since last vacuum on the table.
Last AutoVacuumHours since last autovacuum on the table.
Last AnalyzeHours since last analyze on the table.
Last AutoAnalyzeHours since last autoanalyze on the table.
Row CountEstimated number of rows in a table.
Index size as a percentage of table sizeSize of the indexes on table, as a percentage of table's size.
Table Frozen XIDThe age (in transactions before the current transaction) of the table's frozen transaction ID.

Global Templates

Template NameDescriptionDetails
Agents DownNumber of agents that haven't reported in recently.
Servers DownNumber of servers that are currently inaccessible.
Alert ErrorsNumber of alerts in an error state.