Reference v8.0

Edit this page

The following sections are provided for reference; please note that the items referred to in the following tables are subject to change.

PEM Server Configuration Parameters - Reference

You can use global configuration options to modify aspects of the PEM Server's behavior. Please note that the list of configuration parameters is subject to change.

Parameter nameValue and UnitDescription
audit_log_retention_time30 daysSpecifies the number of days that an audit log will be retained on the PEM server.
auto_create_agent_alertstrueSpecifies whether to create default agent level alerts automatically when an agent is registered.
auto_create_server_alertstrueSpecifies whether to create default server level alerts automatically when a server is bound to an agent.
chart_disable_bulletsfalseEnable/disable bullets on line charts on dashboards and Capacity Manager reports.
cm_data_points_per_report50Specifies the number of data points to plot on charts on Capacity Manager reports.
cm_max_end_date_in_years5 yearsSpecifies the maximum amount of time that the Capacity Manager will extrapolate data for. Ensures that threshold-based end dates of on reports do not get extrapolated indefinitely.
dash_alerts_timeout60 secondsSpecifies the number of seconds after which the components of the Alerts dashboard are auto-refreshed.
dash_db_comrol_span7 daysSpecifies the number of days worth of data to plot on the Commit/Rollback Analysis chart on the Database Analysis dashboard and Server Analysis dashboard.
dash_db_comrol_timeout1800 secondsSpecifies the number of seconds after which the Commits/Rollbacks line chart is auto-refreshed on the Database Analysis dashboard and Server Analysis dashboard.
dash_db_connovervw_timeout300 secondsSpecifies the number of seconds after which the Connection Overview pie chart is auto-refreshed in the Database Analysis dashboard.
dash_db_eventlag_span7 daysSpecifies the number of days worth of data to plot on the Number of Events Lag chart for slony replication on the Database Analysis dashboard.
dash_db_eventlag_timeout1800 secondsSpecifies the number of seconds after which the Number of Events Lag line chart for slony replication is auto-refreshed on the Database Analysis dashboard.
dash_db_hottable_rows25 rowsSpecifies the number of rows to show on the HOT Table Analysis table on the Database Analysis dashboard.
dash_db_hottable_timeout300 secondsSpecifies the number of seconds after which the Hot Tables table is auto-refreshed in the Database Analysis dashboard.
dash_db_io_span7 daysSpecifies the number of days worth of data to plot on the Database I/O Analysis chart on the Database Analysis dashboard and I/O Analysis dashboard.
dash_db_io_timeout1800 secondsSpecifies the number of seconds after which the Database I/O line chart is auto-refreshed on the Database Analysis dashboard and I/O Analysis dashboard.
dash_db_rowact_span7 daysSpecifies the number of days worth of data to plot on the Row Activity Analysis chart on the Database Analysis dashboard, the I/O Analysis dashboard, and the Server Analysis dashboard.
dash_db_rowact_timeout1800 secondsSpecifies the number of seconds after which the Row Activity line chart is auto-refreshed on the Database Analysis dashboard, the I/O Analysis dashboard, and the Server Analysis dashboard.
dash_db_storage_timeout300 secondsSpecifies the number of seconds after which the Storage bar chart is auto-refreshed in the Database Analysis dashboard.
dash_db_timelag_span7 daysSpecifies the number of days worth of data to plot on the Time Lag chart for Slony replication on the Database Analysis dashboard.
dash_db_timelag_timeout1800 secondsSpecifies the number of seconds after which the Time Lag line chart for Slony replication is auto-refreshed on the Database Analysis dashboard.
dash_db_useract_span7 daysSpecifies the number of days worth of data to plot on the User Activity Analysis chart on the Database Analysis dashboard.
dash_db_useract_timeout1800 secondsSpecifies the number of seconds after which the User Activity line chart is auto-refreshed in the Database Analysis dashboard.
dash_efm_timeout300 secondsSpecifies the number of seconds after which the Failover Manager Node Status and Failover Manager Cluster Info line chart is auto-refreshed on the Streaming Replication dashboard.
dash_global_overview_timeout30 secondsSpecifies the number of seconds after which the components of the Global Overview dashboard are auto-refreshed.
dash_header_timeout60 secondsSpecifies the number of seconds after which the information on the header of all the dashboards are auto-refreshed.
dash_io_chkpt_span7 daysSpecifies the number of days worth of data to plot on the Checkpoints chart on the I/O Analysis dashboard.
dash_io_chkpt_timeout1800 secondsSpecifies the number of seconds after which the Checkpoints line chart is auto-refreshed on the I/O Analysis dashboard.
dash_io_hotindx_timeout300 secondsSpecifies the number of seconds after which the Hot Indexes bar chart is auto-refreshed on the I/O Analysis dashboard.
dash_io_hottbl_timeout300 secondsSpecifies the number of seconds after which the Hot Tables bar chart is auto-refreshed on the I/O Analysis dashboard.
dash_io_index_objectio_rows25 rowsSpecifies the number of rows displayed on the Index Activity table on the I/O Analysis dashboard and the Object Activity Analysis dashboard.
dash_io_index_objectio_timeout60 secondsSpecifies the number of seconds after which the Index Activity table is auto-refreshed on the I/O Analysis dashboard and the Object Activity Analysis dashboard.
dash_io_objectio_rows25 rowsSpecifies the number of rows displayed in the Object I/O Details table on the I/O Analysis dashboard and Object Activity Analysis dashboard.
dash_io_objectio_timeout300 secondsSpecifies the number of seconds after which the Object I/O Details table is auto-refreshed on the I/O Analysis dashboard and Object Activity Analysis dashboard.
dash_memory_hostmemact_span7 daysSpecifies the number of days worth of data to plot on the Host Memory Activity Analysis chart on the Memory Analysis dashboard.
dash_memory_hostmemact_timeout1800 secondsSpecifies the number of seconds after which the Host Memory Activity line chart is auto-refreshed on the Memory Analysis dashboard.
dash_memory_hostmemconf_timeout300 secondsSpecifies the number of seconds after which the Host Memory Configuration pie chart is auto-refreshed on the Memory Analysis dashboard and Server Analysis dashboard.
dash_memory_servmemact_span7 daysSpecifies the number of days worth of data to plot on the server Memory Activity Analysis chart on the Memory Analysis dashboard.
dash_memory_servmemact_timeout1800 secondsSpecifies the number of seconds after which the Server Memory Activity line chart is auto-refreshed on the Memory Analysis dashboard.
dash_memory_servmemconf_timeout300 secondsSpecifies the number of seconds after which the Server Memory Configuration pie chart is auto-refreshed on the Memory Analysis dashboard.
dash_objectact_objstorage_rows15 rowsSpecifies the number of rows to show on the Object Storage table on the Object Activity Analysis dashboard.
dash_objectact_objstorage_timeout300 secondsSpecifies the number of seconds after which the Object Storage table is auto-refreshed in the Object Activity Analysis dashboard.
dash_objectact_objtopindexes_timeout300 secondsSpecifies the number of seconds after which the Top 5 Largest Indexes bar chart is auto-refreshed in the Object Activity Analysis dashboard.
dash_objectact_objtoptables_timeout300 secondsSpecifies the number of seconds after which the Top 5 Largest Tables bar chart is auto-refreshed in the Object Activity Analysis dashboard.
dash_os_cpu_span7 daysSpecifies the number of days worth of data to plot on the CPU chart on the Operating System Analysis dashboard.
dash_os_cpu_timeout1800 secondsSpecifies the number of seconds after which the CPU line chart is auto-refreshed on the Operating System Analysis dashboard.
dash_os_data_span7 daysSpecifies the number of days worth of data to plot on the I/O line chart on the Operating System Analysis dashboard.
dash_os_disk_span7 daysSpecifies the number of days worth of data to plot on the Utilisation chart on the Operating System Analysis dashboard.
dash_os_hostfs_timeout1800 secondsSpecifies the number of seconds after which the Host File System Details table is auto-refreshed on the Operating System Analysis dashboard.
dash_os_io_timeout1800 secondsSpecifies the number of seconds after which the I/O line chart is auto-refreshed on the Operating System Analysis dashboard.
dash_os_memory_span7 daysSpecifies the number of days worth of data to plot on the Memory chart on the Operating System Analysis dashboard.
dash_os_memory_timeout1800 secondsSpecifies the number of seconds after which the Memory line chart is auto-refreshed on the Operating System Analysis dashboard.
dash_os_packet_span7 daysSpecifies the number of days worth of data to plot on the Packet chart on the Operating System Analysis dashboard.
dash_os_packet_timeout1800 secondsSpecifies the number of seconds after which the Network Packets line chart is auto-refreshed on the Operating System Analysis dashboard.
dash_os_process_span7 daysSpecifies the number of days worth of data to plot on the Process chart on the Operating System Analysis dashboard.
dash_os_process_timeout1800 secondsSpecifies the number of seconds after which the Process line chart is auto-refreshed on the Operating System Analysis dashboard.
dash_os_storage_timeout1800 secondsSpecifies the number of seconds after which the Storage pie chart is auto-refreshed on the Operating System Analysis dashboard.
dash_os_traffic_span7 daysSpecifies the number of days worth of data to plot on the Traffic chart on the Operating System Analysis dashboard.
dash_os_traffic_timeout1800 secondsSpecifies the number of seconds after which the Traffic line chart is auto-refreshed on the Operating System Analysis dashboard.
dash_os_util_timeout1800 secondsSpecifies the number of seconds after which the Utilisation line chart is auto-refreshed on the Operating System Analysis dashboard.
dash_probe_log_timeout300 secondsSpecifies the number of seconds after which the Probe Log table is auto-refreshed on
dash_replication_archivestat_span7 daysSpecifies the number of days worth of data to plot on the WAL Archive Status chart on the Streaming Replication Analysis dashboard.
dash_replication_archivestat_timeout1800 secondsSpecifies the number of seconds after which the WAL Archive Status line chart is auto-refreshed on the Streaming Replication dashboard.
dash_replication_pagelag_span7 daysSpecifies the number of days worth of data to plot on the WAL Lag Pages chart on the Streaming Replication dashboard.
dash_replication_pagelag_timeout1800 secondsSpecifies the number of seconds after which the WAL Lag Pages line chart is auto-refreshed on the Streaming Replication dashboard.
dash_replication_segmentlag_span7 daysSpecifies the number of days worth of data to plot on the WAL Lag Segments chart on the Streaming Replication dashboard.
dash_replication_segmentlag_timeout1800 secondsSpecifies the number of seconds after which the WAL Lag Segments line chart is auto-refreshed on the Streaming Replication dashboard.
dash_replication_timelag_span7 daysSpecifies the number of days worth of data to plot on the Replication Lag Time chart on the Streaming Replication dashboard.
dash_replication_timelag_timeout1800 secondsSpecifies the number of seconds after which the Replication Lag Time line chart is auto-refreshed on the Streaming Replication dashboard.
dash_server_buffers_written168 hoursSpecifies the number of days worth of data to plot on the Background Writer Statistics chart on the Server Analysis dashboard.
dash_server_buffers_written_timeout300 secondsSpecifies the number of seconds after which the Background Writer Statistics line chart is auto-refreshed on the Server Analysis dashboard.
dash_server_connovervw_timeout300 secondsSpecifies the number of seconds after which the Connection Overview pie chart is auto-refreshed in the Server Analysis dashboard.
dash_server_database_timeout300 secondsSpecifies the number of seconds after which the Databases table is auto-refreshed in the Server Analysis dashboard.
dash_server_dbsize_span7 daysSpecifies the number of days worth of data to plot on the Database Size Analysis on the Server Analysis dashboard.
dash_server_dbsize_timeout1800 secondsSpecifies the number of seconds after which the Database Size line chart is auto-refreshed in the Server Analysis dashboard.
dash_server_disk_timeout1800 secondsSpecifies the number of seconds after which the Disk line chart is auto-refreshed in the Server Analysis dashboard.
dash_server_global_span7 daysSpecifies the number of days worth of data to plot on the Disk line chart on the Server Analysis dashboard.
dash_server_sharedbuff_span7 daysSpecifies the number of days worth of data to plot on the Shared Buffer chart on the Server Analysis dashboard.
dash_server_sharedbuff_timeout1800 secondsSpecifies the number of seconds after which the Shared Buffers line chart is auto-refreshed in the Server Analysis dashboard.
dash_server_tabspacesize_span7 daysSpecifies the number of days worth of data to plot on the Tablespace Size chart on the Server Analysis dashboard.
dash_server_tabspacesize_timeout1800 secondsSpecifies the number of seconds after which the Tablespace Size line chart is auto-refreshed in the Server Analysis dashboard.
dash_server_useract_span7 daysSpecifies the number of days worth of data to plot on the User Activity chart on the Server Analysis dashboard.
dash_server_useract_timeout1800 secondsSpecifies the number of seconds after which the User Activity line chart is auto-refreshed in the Server Analysis dashboard.
dash_sessact_lockact_timeout300 secondsSpecifies the number of seconds after which the Session Lock Activity table is auto-refreshed in the Session Activity Analysis dashboard.
dash_sessact_workload_timeout300 secondsSpecifies the number of seconds after which the Session Workload table is auto-refreshed in the Session Activity Analysis dashboard.
dash_sess_waits_nowaits_timeout300 secondsSpecifies the number of seconds after which the Session Waits By Number Of Waits pie
dash_sess_waits_timewait_timeout300 secondsSpecifies the number of seconds after which the Session Waits By Time Waited pie chart is auto-refreshed in the Session Waits Analysis dashboard.
dash_sess_waits_waitdtl_timeout300 secondsSpecifies the number of seconds after which the Session Waits Details table is auto-refreshed in the Session Waits Analysis dashboard.
dash_storage_dbdtls_timeout300 secondsSpecifies the number of seconds after which the Database Details table is auto-refreshed in the Storage Analysis dashboard.
dash_storage_dbovervw_timeout300 secondsSpecifies the number of seconds after which the Database Overview pie chart is auto-refreshed in the Storage Analysis dashboard.
dash_storage_hostdtls_timeout300 secondsSpecifies the number of seconds after which the Host Details table is auto-refreshed
dash_storage_hostovervw_timeout300 secondsSpecifies the number of seconds after which the Host Overview pie chart is auto-refreshed in the Storage Analysis dashboard.
dash_storage_tblspcdtls_timeout300 secondsSpecifies the number of seconds after which the Tablespace Details table is auto-refreshed in the Storage Analysis dashboard.
dash_storage_tblspcovervw_timeout300 secondsSpecifies the number of seconds after which the Tablespace Overview pie chart is auto-refreshed in the Storage Analysis dashboard.
dash_sys_waits_nowaits_timeout300 secondsSpecifies the number of seconds after which the System Waits By Number Of Waits pie chart is auto-refreshed in the System Waits Analysis dashboard.
dash_sys_waits_timewait_timeout300 secondsSpecifies the number of seconds after which the System Waits By Time Waited pie chart is auto-refreshed in the System Waits Analysis dashboard.
dash_sys_waits_waitdtl_timeout300 secondsSpecifies the number of seconds after which the System Waits Details table is auto-refreshed in the System Waits Analysis dashboard.
deleted_charts_retention_time7 daysSpecifies the number of days that a custom chart (displayed on a user-defined dashboard) is stored.
deleted_probes_retention_time7 daysSpecifies the number of days that a custom probe (displayed on a user-defined dashboard) is stored.
download_chart_formatjpegSpecifies the format in which a downloaded chart will be stored. May be jpeg or png.
flapping_detection_state_change3Specifies the number of state changes detected within a specified interval to define a given alert as flapping. Flapping starts when more than N state changes have occurred over [ N + 1 * (min(probe_interval) * 2)] minutes and the fine state is not None. Where the default value of N is 2 or 3, and min(probe_interval) is the smallest interval for all the probes used by the alert. Flapping ends when ZERO state changes have occurred over [2 N * min(probe_interval)] minutes.
job_retention_time30 daysSpecifies the number of days that non-recurring scheduled tasks and their associated
long_running_transaction_minutes5 minutesSpecifies the number of minutes a query executes for before being considered long running.
nagios_cmd_file_name<file_name>Specifies nagios command file to which passive service check result will be sent.
nagios_enabledtSpecifies whether alert notification will be submitted to nagios or not.
nagios_medium_alert_as_criticalfSpecifies whether medium level PEM alert will be considered as critical in nagios.
nagios_spool_retention_time7 daysSpecifies the number of days to retain nagios messages in the spool table before they are discarded.
probe_log_retention_time30 daysSpecifies the number of days that probe log records are retained.
reminder_notification_interval24 hoursSpecifies the number of hours after which a reminder email is sent in case an alert has not been cleared.
server_log_retention_time30 daysSpecifies the number of days that the server log is retained on the PEM server.
show_data_tab_on_graphfalseIf 'true', a Data tab is added to each graph. Select the Data tab to review the data that is plotted on the graph.
smtp_authenticationfalseSpecifies whether to enable/disable authentication over SMTP.
smtp_enabledtrueSpecifies whether to enable/disable sending of emails.
smtp_encryptionfalseSpecifies whether to send SMTP email using an encrypted connection.
smtp_passwordSpecifies the password to be used to connect to the SMTP server.
smtp_port25Specifies the SMTP server port to be used for sending email.
smtp_server127.0.0.1Specifies the SMTP server host address to be used for sending email.
smtp_spool_retention_time7 daysSpecifies the number of days to retain sent email messages in the spool table before they are discarded.
smtp_usernameSpecifies the username to be used to connect to SMTP server.
snmp_communitypublicSpecifies the SNMP community used when sending traps. Used only with SNMPv1 and SNMPv2.
snmp_enabledtrueSpecifies whether to enable/disable sending SNMP traps.
snmp_port162Specifies the SNMP server port to be used for sending SNMP traps.
snmp_server127.0.0.1Specifies the SNMP server host address to be used for sending SNMP traps.
snmp_spool_retention_time7 daysSpecifies the number of days to retain sent traps in the spool table before they are discarded.
snmp_security_nameSpecifies the user name or security name for sending SNMP traps. Used only with SNMPv3.
snmp_security_engine_idSpecifies the Engine id of the SNMP Agent on the SNMP Server. Used only with SNMPv3.
snmp_security_levelNOAUTH_NOPRIVSpecifies Security level and its possible values can be: AUTH_NOPRIV - Authentication, No Privacy or AUTH_PRIV - Authentication, Privacy or NOAUTH_NOPRIV - no Authentication, no Privacy. Used only with SNMPv3.
snmp_context_nameSpecifies the Context name, the identifier for MIB objects when sending SNMP traps. Used only with SNMPv3.
snmp_context_engine_idSpecifies the Context engine id, the identifier for MIB objects when sending SNMP traps. If not specified, snmp_security_engine_id will be used. Used only with SNMPv3.
snmp_authentication_protocolNONESpecifies the authentication type for SNMP traps. Its possible values can be NONE,HMACMD5 or HMACSHA. Used only with SNMPv3.
snmp_privacy_protocolNONESpecifies the privacy protocol for SNMP traps. Its possible values can be NONE, DES, AES128, IDEA, AES192, or AES256. Used only with SNMPv3.
snmp_authentication_passwordSpecifies the authentication password associated with security name mentioned in snmp_security_name. Used only for SNMPv3.
snmp_privacy_passwordSpecifies the privacy password associated with security name mentioned in snmp_security_name. Used only for SNMPv3.
webclient_help_pgEDB hosted documentationSpecifies the location of the online PostgreSQL core documentation.

Capacity Manager Metrics - Reference

Please Note that the Capacity Manager metrics available will vary by platform, and are subject to change. The available metrics may include the metrics described in the table below.

Metric NameDescription
# Dead TuplesThe number of dead tuples in the selected table.
# Dead Tuples+The cumulative number of dead tuples in the selected table.
# Heap Tuples Fetched by Index ScansThe number of heap tuples fetched by index scans.
# Heap Tuples Fetched by Index ScansThe cumulative number of heap tuples fetched by index scans.
# Idle Backends+The cumulative number of currently idle backend clients.
# Index ScansThe number of index scans performed on the specified object.
# Index Scans+The cumulative number of index scans performed on the specified object.
# Index Tuples ReadThe number of index tuples read.
# Index Tuples Read+The cumulative number of index tuples read.
# Live TuplesThe number of tuples visible to transactions.
# Live Tuples+The cumulative number of tuples visible to transactions.
# Pages Estimated by ANALYZEThe number of pages estimated by ANALYZE.
# Pages Estimated by ANALYZE+The cumulative number of pages estimated by ANALYZE.
# Sequential ScansThe number of sequential scans performed on the specific table.
# Sequential Scans+The cumulative number of sequential scans performed on the specific table.
# Sequential Scan TuplesThe number of tuples sequentially scanned in the specific table.
# Sequential Scan Tuples+The cumulative number of tuples sequentially scanned in the specific table.
# Tuples DeletedThe number of tuples deleted.
# Tuples Deleted+The cumulative number of tuples deleted.
# Tuples Estimated by ANALYZEThe number of live (visible) tuples estimated by ANALYZE.
# Tuples Estimated by ANALYZE+The cumulative number of live tuples estimated by ANALYZE.
# Tuples HOT UpdatedThe number of tuples HOT updated. In a HOT update, the new tuple resides in the same block as the original tuple and the tuples share an index entry.
# Tuples HOT Updated+The cumulative number of tuples HOT updated.
# Tuples InsertedThe number of tuples inserted into the specified table.
# Tuples Inserted+The cumulative number of tuples inserted into the specified table.
# Tuples UpdatedThe number of tuples updated in the selected table.
# Tuples Updated+The cumulative number of tuples updated in the selected table.
Blocks HitThe number of blocks found in the cache.
Blocks Hit+The cumulative number of blocks found in the cache.
Blocks ReadThe number of blocks read.
Blocks Read+The cumulative number of blocks read.
Blocks Read from InfiniteCacheThe number of blocks read from InfiniteCache.
Blocks Read from InfiniteCache+The cumulative number of blocks read from InfiniteCache.
Blocks WrittenThe number of blocks written.
Blocks Written+The cumulative number of blocks written.
Buffers AllocatedThe number of buffers allocated.
Buffers Allocated+The cumulative number of buffers allocated.
Buffers Written - BackendsThe number of buffer blocks written to disk by server processe (processes connected to a client application).
Buffers Written - Backends+The cumulative number of buffer blocks written to disk by server processes.
Buffers Written - CheckpointThe number of blocks written to disk by the checkpoint process.
Buffers Written - Checkpoint+The cumulative number of blocks written to disk by the checkpoint process.
Buffers Written - Cleaning ScanThe number of blocks written to disk by the autovacuum process.
Buffers Written - Cleaning Scan+The cumulative number of blocks written to disk by the autovacuum process.
Bytes Received (KB)The number of bytes received from the client (in kilobytes).
Bytes Received (KB)+The cumulative number of bytes received (in kilobytes).
Bytes Sent (KB)The number of bytes sent to the client (in kilobytes).
Bytes Sent (KB)+The cumulative number of bytes sent (in kilobytes).
Checkpoints - TimedThe number of checkpoint operations triggered by the checkpoint interval.
Checkpoints - Timed+The cumulative number of checkpoint operations triggered by the checkpoint interval.
Checkpoints - UntimedThe number of checkpoint operations triggered by checkpoint size.
Checkpoints - Untimed+The cumulative number of checkpoint operations triggered by checkpoint size.
Database Size (MB)The size of the specified database (in megabytes).
Free RAM MemoryThe amount of free RAM memory (in megabytes).
Free Swap MemoryThe amount of free swap space on disk (in megabytes).
Heap Blocks HitThe number of heap blocks found in the cache.
Heap Blocks Hit+The cumulative number of heap blocks found in the cache.
Heap Blocks ReadThe number of heap blocks read.
Heap Blocks Read+The cumulative number of heap blocks read.
Index Blocks HitThe number of index blocks found in the cache.
Index Blocks Hit+The cumulative number of index blocks found in the cache.
Index Blocks ReadThe number of index blocks read.
Index Blocks Read+The cumulative number of index blocks read.
Index Size (MB)The size of the specified index (in megabytes).
In Packets DiscardsThe number of inbound packets discarded.
In Packets Discards+The cumulative number of inbound packets discarded.
In Packets ErrorsThe number of inbound packets that contain errors.
In Packets Errors+The cumulative number of inbound packets that contain errors.
Link Bandwidth (Mbit/s)The speed of the network adapter (in megabits per second).
Load Average - 15 MinuteCPU saturation (in percent) - 15 minute sampling average.
Load Average - 1 MinuteCPU saturation (in percent) - 1 minute sampling average.
Load Average - 5 MinuteCPU saturation (in percent) - 5 minute sampling average.
Load PercentageCPU saturation in percent.
Number of Prepared Transactions+The cumulative number of prepared transactions.
Number of WAL Files+The cumulative number of write-ahead log files.
Out Packets DiscardsThe number of outbound packets discarded.
Out Packets Discards+The cumulative number of outbound packets discarded.
Out Packets ErrorsThe number of outbound packets that contain errors.
Out Packets Errors+The cumulative number of outbound packets that contain errors.
Packets ReceivedThe number of packets received.
Packets Received+The cumulative number of packets received.
Packets SentThe number of packets sent.
Packets Sent+The cumulative number of packets sent.
Size (MB)The total size of the disk (in megabytes).
Size of Indexes (MB)The size of indexes on the specified table (in megabytes).
Space Available (MB)The current disk space available (in megabytes).
Space Used (MB)The current disk space used (in megabytes).
Table Size (MB)The size of the specified table (in megabytes).
Tablespace Size (MB)The size of the specified tablespace (in megabytes).
Temp Buffers (MB)The size of temporary buffers (in megabytes).
Toast Blocks HitThe number of TOAST blocks found in the cache.
Toast Blocks Hit+The cumulative number of TOAST blocks found in the cache.
Toast Blocks ReadThe number of TOAST blocks read.
Toast Blocks Read+The cumulative number of TOAST blocks read.
Total RAM MemoryThe total amount of RAM memory on the system (in megabytes).
Total Swap MemoryThe total amount of swap space on the system (in megabytes).
Total Table Size w/Indexes and ToastThe total size of the specified table (including indexes and associated oversized attributes).
Transactions AbortedThe number of aborted transactions.
Transactions Aborted+The cumulative number of aborted transactions.
Transactions CommittedThe number of committed transactions.
Transactions Committed+The cumulative number of committed transactions.
Tuples DeletedThe number of tuples deleted from the specified table.
Tuples Deleted+The cumulative number of tuples deleted from the specified table.
Tuples Estimated by ANALYZEThe number of visible tuples in the specified table.
Tuples Estimated by ANALYZE+The cumulative number of visible tuples in the specified table.
Tuples FetchedThe number of tuples fetched from the specified table.
Tuples Fetched+The cumulative number of tuples fetched from the specified table.
Tuples HOT UpdatedThe number of tuples HOT updated. In a HOT update, the new tuple resides in the same block as the original tuple and the tuples share an index entry.
Tuples HOT Updated+The cumulative number of tuples HOT updated. In a HOT update, the new tuple resides in the same block as the original tuple and the tuples share an index entry.
Tuples InsertedThe number of tuples inserted into the specified table.
Tuples Inserted+The cumulative number of tuples inserted into the specified table.
Tuples ReturnedThe number of tuples returned in result sets.
Tuples Returned+The cumulative number of tuples returned in result sets.
Tuples UpdatedThe number of tuples updated in the specified table.
Tuples Updated+The cumulative number of tuples updated in the specified table.
WAL Segment Size (MB)The segment size of the write-ahead log (in megabytes).
Note

The '+' following the name of a metric signifies that the data for the metric is gathered cumulatively; those metrics that are not followed by the '+' sign are collected as a 'point-in-time' value.

PEM Probes – Reference

A probe is a scheduled task that retrieves information about the database objects that are being monitored by the PEM agent. PEM uses the collected information to build the graphs displayed on each dashboard. The Manage Probes tab (accessed via the Management menu) allows you to modify the data collection schedule and the length of time that PEM will retain information returned by a specific probe.

Probe NameInformation Monitored by ProbeLevel
Background Writer StatisticsThis probe monitors information about the background writer. The information includes:
The number of timed checkpoints
The number of requested checkpoints
The number of buffers written (by checkpoint)
The number of buffers written (by background writer)
The number of background writer cycles
The number of background buffers written
The number of buffers allocated
Server
Blocked Session InformationThis probe provides information about blocked sessions.Server
CPU UsageThis probe monitors CPU Usage information.Agent
Data and Log File AnalysisThis probe monitors information about log files. The information includes:
The name of the log file
The directory in which the log file resides
Server
Database Frozen XIDThis probe monitors the frozen XID of each database.Server
Database SizeThis probe monitors information about the size of the monitored databases.The information includes:
The time the information was gathered
The database name
The database size (in MB's).
Server
Database StatisticsThis probe monitors database statistics. The information includes:
The number of backends
The number of transactions committed
The number of transactions rolled back
The number of blocks read
The number of blocks hit
The number of rows returned
The number of rows fetched
The number of rows inserted
The number of rows updated
The number of rows deleted
Server
Disk Busy InfoThis probe monitors information about disk activity.
Note: This probe is not supported on Mac OS X, Solaris or HP-UX
Agent
Disk SpaceThis probe monitors information about disk space usage. The information includes:
The amount of disk space used
The amount of disk space available
Agent
EDB Audit ConfigurationThis probe monitors the audit logging configuration of EDB Postgres Advanced Server.Server
Failover Manager Cluster InfoThis probe monitors a Failover Manager cluster, returning information about the cluster. This probe is disabled unless a cluster name and path of the Failover Manager binary is provided on the Server Properties dialog.Server
Failover Manager Node StatusThis probe monitors a Failover Manager cluster, returning detailed about each node within the cluster. This probe is disabled unless a cluster name and path of the Failover Manager binary is provided on the Server Properties dialog.Server
Function StatisticsThis probe monitors a database, retrieving information about functions. The information includes:
Function names
Argument types
Return values
Database
Index SizeThis probe monitors a database, retrieving information about indexes. The information includes:
The name of the index
The time the data was gathered
The size of the index (in MB's)
Database
Index StatisticsThis probe monitors index statistics. The information includes:
The number of index scans
The number of rows read
The number of rows fetched
The number of blocks read
The number of blocks hit
Database
Installed PackagesThis probe monitors the packages that are currently installed. The information gathered includes:
The name of the installed package
The version of the installed package
The date and time that the probe executed
Agent
IO AnalysisThis probe monitors disk I/O information in. The information includes:
The number of blocks read
The number of blocks written
The date and time that the probe executed
Note: This probe is not supported on Mac OS X
Agent
Load AverageThis probe monitors CPU load averages. The information includes:
The 1-minute load average
The 5-minute load average
The 15-minute load average
Note: This probe is not supported on Windows
Agent
Lock InformationThis probe monitors lock information. The information includes:
The database name
The lock type
The lock mode
The process holding the lock
Server
Memory UsageThis probe monitors information about system memory usage.The information includes:
Total RAM in MB
Free RAM in MB
Total swap memory in MB
Free swap memory in MB
Shared system memory in MB(It is used by tuning wizard to tune the memory parameters for the database server)
- On non-windows system, it is shmmax value and read from /proc/sys/kernel/shmmax.
- On windows, it is same as total memory.
Agent
Network StatisticsThis probe monitors network statistics. The information includes:
The interface IP address
The number of packets sent
The number of packets received
The number of bytes sent
The number of bytes received
The link speed (in MB/second)
Agent
Number of Prepared TransactionsThis probe stores the number of prepared transactions.Server
Number of WAL FilesThis probe monitors the number of WAL files.Server
Object Catalog: DatabaseThis probe monitors a list of databases and their properties The information includes:
The database name
The database encoding type
If the database allows user connections or system connections
Server
Object Catalog: Foreign KeyThis probe monitors a list of foreign keys and their properties. The information includes:
The name of the table that contains the foreign key
The name of the table that the foreign key references
The name of the database in which the table resides
The name of the schema in which the table resides
Schema
Object Catalog: FunctionThis probe monitors a list of functions and their properties. The information includes:
The name of the function
The name of the schema in which the function resides
The name of the database in which the function resides
Schema
Object Catalog: IndexThis probe monitors a list of indexes and their properties. The information includes:
The name of the index
The name of the table that the index is associated with
The name of the database in which the indexed table resides
Schema
Object Catalog: SchemaThis probe monitors a list of schemas and their associated databases and servers.Database
Object Catalog: SequenceThis probe monitors a list of sequences and their properties.Schema
Object Catalog: TableThis probe monitors a list of table information. The information includes:
The table name
The name of the schema in which the table resides
The name of the database in which the schema resides
A Boolean indicator that indicates if the table has a primary key
Schema
Object Catalog: TablespaceThis probe monitors a list of tablespaces.Server
Operating System InformationThis probe monitors the operating system details and boot time.Agent
Package CatalogThis probe monitors the packages that are currently available for installation. The information gathered includes:
The package name
The package version
Agent
PG HBA ConfThis probe monitors authentication configuration information from the pg_hba.conf file.Server
Server InformationThis probe monitors server information.Server
Session InformationThis probe monitors session information. The information includes:
The name of the session user
The date and time that the session connected to the server
The status of the session at the time that the information was gathered (idle, waiting, etc)
The client address and port number
Server
SettingsThis probe monitors the values currently assigned to GUC variables.Server
SQL ProtectThis probe monitors a server, retrieving information about SQL injection attacks.Server
Slony ReplicationThis probe monitors lag data for clusters replicated using Slony.Database
Streaming ReplicationThis probe monitors a cluster that is using streaming replication, retrieving information about:
The sent Xlog location (in bytes)
The write Xlog location (in bytes)
The flush Xlog location (in bytes)
The replay Xlog location (in bytes)
The Xlog lag (in segments)
The Xlog lag (in pages)
Server
Streaming Replication Lag TimeThis probe monitors a cluster that is using streaming replication, retrieving lag information about:
Replication lag time (in seconds)
Current status of replication (running/paused)
Server
Streaming Replication Database ConflictsThis probe monitors a database that is using streaming replication, retrieving information about any conflicts that arise. This includes information about queries that have been canceled due to:
The # of drop tablespace conflicts
The # of lock timeout conflicts
The # of old snapshot conflicts
The # of pinned buffer conflicts
The # of deadlock conflicts
Server
Table BloatThis probe monitors information about the current table bloat. The information includes:
The name of the table
The name of the schema in which the table resides
The estimated number of pages
The estimated number of wasted pages
The estimated number of bytes per row
Database
Table Frozen XIDThis probe monitors the frozen XID of each table.Schema
Table SizeThis probe monitors information about table size. The information includes:
Table size (in MB's)
Total index size (in MB's)
Total table size, with indexes and TOAST (in MB's)
Database
Table StatisticsThis probe monitors table statistics. The information includes:
The number of sequential scans
The number of sequential scan rows
The number of index scans
The number of index scan rows
The number of rows inserted
The number of rows updated
The number of rows deleted
The number of live rows
The number of dead rows
The last VACUUM
The last auto-vacuum
The last ANALYZE
The last auto-analyze
The number of pages estimated by ANALYZE
The number of rows estimated by ANALYZE
Database
Tablespace SizeThis probe monitors a list of tablespaces and their sizes.Server
User InformationThis probe monitors a list of the current users. The stored information includes:
The user name
The user type (superuser vs. non-superuser)
The server to which the user is connected
Server
WAL Archive StatusThis probe monitors the status of the WAL archive. The stored information includes:
The # of WAL archives done
The # of WAL archives pending
The last archive time
The # of WAL archives failed
The time of the last failure
Server
xDB ReplicationThis probe monitors lag data for clusters replicated using xDB replication.Database

PEM Pre-defined Alert Templates – Reference

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 tables that follow list 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:

Templates applicable on Agent

Template NameDescription
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 aNumber of CPUs running at greater than K% utilization threshold
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.
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 hours.The 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.
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 NameDescription
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.
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.
Database size in serverThe size of databases in server, in MB.
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.
Total connections as percentage ofTotal number of connections in the server as a percentage of maximum
max_connectionsconnections 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 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.
Connections in idle-in-transaction stateNumber of connections in server that are in idle-in-transaction state.
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.
Long-running idle connections and idle transactionsNumber of connections in the server that have been idle or transactions idle-in-transaction for more than N seconds.
Long-running idle transactionsNumber of connections in the server that have been idle in transaction for more than N seconds.
Long-running transactionsNumber of transactions in server that have been running for more than N seconds.
Long-running queriesNumber of queries in server that have been running for more than N seconds.
Long-running vacuumsNumber of vacuum operations in server that have been running for more than N seconds.
Long-running autovacuumsNumber of autovacuum operations in server that have been running for more than N seconds.
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 the last N minutesThe percentage of buffers written by backends vs. the total buffers backends over last N
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 percentage oc_index, table_size.Largest index in server, calculated as percentage of its table's 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 location> Streaming Replication: number of replica servers lag behind the primary by write location.
Number of replica servers lag behind the primary by flush location> Streaming Replication: number of replica servers lag behind the primary by flush location.
Number of replica servers lag behind the primary by replay location> Streaming Replication: number of replica servers lag behind the primary by replay location.
Replica server lag behind the primary by write location> Streaming Replication: replica server lag behind the primary by write location in MB.
Replica server lag behind the primary by flush location> Streaming Replication: replica server lag behind the primary by flush location in MB.
Replica server lag behind the primary by replay location> Streaming Replication: replica server lag behind the primary by replay location in MB.
Replica server lag behind the primary by size (MB)> Streaming Replication: replica server lag behind the primary by size in MB.
Replica server lag behind the primary by WAL segments> Streaming Replication: replica server lag behind the primary by WAL segments.
Replica server lag behind the primary by WAL pages> Streaming Replication: replica server lag behind the primary by WAL pages.
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 mismatch
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 server> Streaming Replication: number of minutes replica node is lagging behind the primary node.
Log config mismatchCheck for log config parameter mismatch.

Templates applicable on Database

Template NameDescription
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.
Database sizeThe size of the database, in MB.
Total connectionsTotal number of connections in the database.
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.
Connections in idle-in-transaction stateNumber of connections in database that are in idle-in-transaction state
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.
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.
Long-running idle transactionsNumber of connections in the database that have been idle in transaction for more than N seconds.
Long-running transactionsNumber of transactions in database that have been running for more than N seconds.
Long-running queriesNumber of queries in database that have been running for more than N seconds.
Long-running vacuumsNumber of vacuum operations in database that have been running for more than N seconds.
Long-running autovacuumsNumber of autovacuum operations in database that have been running for more than N seconds.
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 theThe number of SQL injection attacks occurred in the last N minutes. last N minutes
Number of attacks detected in theThe number of SQL injection attacks occurred in the last N minutes by 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.
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 replication> xDB Replication: Total rows lagging in xdb single primary replication
Total rows lagging in xdb multi primary replication> xDB Replication: Total rows lagging in xdb multi primary replication.
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 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 NameDescription
Total table bloat in schemaThe total space wasted by tables in schema, in MB.
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.
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 unbloated 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 NameDescription
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 NameDescription
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.