Reference

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 name Value and Unit Description
audit_log_retention_time 30 days Specifies the number of days that an audit log will be retained on the PEM server.
auto_create_agent_alerts true Specifies whether to create default agent level alerts automatically when an agent is registered.
auto_create_server_alerts true Specifies whether to create default server level alerts automatically when a server is bound to an agent.
chart_disable_bullets false Enable/disable bullets on line charts on dashboards and Capacity Manager reports.
cm_data_points_per_report 50 Specifies the number of data points to plot on charts on Capacity Manager reports.
cm_max_end_date_in_years 5 years Specifies 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_timeout 60 seconds Specifies the number of seconds after which the components of the Alerts dashboard are auto-refreshed.
dash_db_comrol_span 7 days Specifies 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_timeout 1800 seconds Specifies 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_timeout 300 seconds Specifies the number of seconds after which the Connection Overview pie chart is auto-refreshed in the Database Analysis dashboard.
dash_db_eventlag_span 7 days Specifies 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_timeout 1800 seconds Specifies 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_rows 25 rows Specifies the number of rows to show on the HOT Table Analysis table on the Database Analysis dashboard.
dash_db_hottable_timeout 300 seconds Specifies the number of seconds after which the Hot Tables table is auto-refreshed in the Database Analysis dashboard.
dash_db_io_span 7 days Specifies 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_timeout 1800 seconds Specifies 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_span 7 days Specifies 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_timeout 1800 seconds Specifies 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_timeout 300 seconds Specifies the number of seconds after which the Storage bar chart is auto-refreshed in the Database Analysis dashboard.
dash_db_timelag_span 7 days Specifies 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_timeout 1800 seconds Specifies 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_span 7 days Specifies the number of days worth of data to plot on the User Activity Analysis chart on the Database Analysis dashboard.
dash_db_useract_timeout 1800 seconds Specifies the number of seconds after which the User Activity line chart is auto-refreshed in the Database Analysis dashboard.
dash_efm_timeout 300 seconds Specifies 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_timeout 30 seconds Specifies the number of seconds after which the components of the Global Overview dashboard are auto-refreshed.
dash_header_timeout 60 seconds Specifies the number of seconds after which the information on the header of all the dashboards are auto-refreshed.
dash_io_chkpt_span 7 days Specifies the number of days worth of data to plot on the Checkpoints chart on the I/O Analysis dashboard.
dash_io_chkpt_timeout 1800 seconds Specifies the number of seconds after which the Checkpoints line chart is auto-refreshed on the I/O Analysis dashboard.
dash_io_hotindx_timeout 300 seconds Specifies the number of seconds after which the Hot Indexes bar chart is auto-refreshed on the I/O Analysis dashboard.
dash_io_hottbl_timeout 300 seconds Specifies the number of seconds after which the Hot Tables bar chart is auto-refreshed on the I/O Analysis dashboard.
dash_io_index_objectio_rows 25 rows Specifies 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_timeout 60 seconds Specifies 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_rows 25 rows Specifies 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_timeout 300 seconds Specifies 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_span 7 days Specifies the number of days worth of data to plot on the Host Memory Activity Analysis chart on the Memory Analysis dashboard.
dash_memory_hostmemact_timeout 1800 seconds Specifies the number of seconds after which the Host Memory Activity line chart is auto-refreshed on the Memory Analysis dashboard.
dash_memory_hostmemconf_timeout 300 seconds Specifies 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_span 7 days Specifies the number of days worth of data to plot on the server Memory Activity Analysis chart on the Memory Analysis dashboard.
dash_memory_servmemact_timeout 1800 seconds Specifies the number of seconds after which the Server Memory Activity line chart is auto-refreshed on the Memory Analysis dashboard.
dash_memory_servmemconf_timeout 300 seconds Specifies the number of seconds after which the Server Memory Configuration pie chart is auto-refreshed on the Memory Analysis dashboard.
dash_objectact_objstorage_rows 15 rows Specifies the number of rows to show on the Object Storage table on the Object Activity Analysis dashboard.
dash_objectact_objstorage_timeout 300 seconds Specifies the number of seconds after which the Object Storage table is auto-refreshed in the Object Activity Analysis dashboard.
dash_objectact_objtopindexes_timeout 300 seconds Specifies 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_timeout 300 seconds Specifies 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_span 7 days Specifies the number of days worth of data to plot on the CPU chart on the Operating System Analysis dashboard.
dash_os_cpu_timeout 1800 seconds Specifies the number of seconds after which the CPU line chart is auto-refreshed on the Operating System Analysis dashboard.
dash_os_data_span 7 days Specifies the number of days worth of data to plot on the I/O line chart on the Operating System Analysis dashboard.
dash_os_disk_span 7 days Specifies the number of days worth of data to plot on the Utilisation chart on the Operating System Analysis dashboard.
dash_os_hostfs_timeout 1800 seconds Specifies the number of seconds after which the Host File System Details table is auto-refreshed on the Operating System Analysis dashboard.
dash_os_io_timeout 1800 seconds Specifies the number of seconds after which the I/O line chart is auto-refreshed on the Operating System Analysis dashboard.
dash_os_memory_span 7 days Specifies the number of days worth of data to plot on the Memory chart on the Operating System Analysis dashboard.
dash_os_memory_timeout 1800 seconds Specifies the number of seconds after which the Memory line chart is auto-refreshed on the Operating System Analysis dashboard.
dash_os_packet_span 7 days Specifies the number of days worth of data to plot on the Packet chart on the Operating System Analysis dashboard.
dash_os_packet_timeout 1800 seconds Specifies the number of seconds after which the Network Packets line chart is auto-refreshed on the Operating System Analysis dashboard.
dash_os_process_span 7 days Specifies the number of days worth of data to plot on the Process chart on the Operating System Analysis dashboard.
dash_os_process_timeout 1800 seconds Specifies the number of seconds after which the Process line chart is auto-refreshed on the Operating System Analysis dashboard.
dash_os_storage_timeout 1800 seconds Specifies the number of seconds after which the Storage pie chart is auto-refreshed on the Operating System Analysis dashboard.
dash_os_traffic_span 7 days Specifies the number of days worth of data to plot on the Traffic chart on the Operating System Analysis dashboard.
dash_os_traffic_timeout 1800 seconds Specifies the number of seconds after which the Traffic line chart is auto-refreshed on the Operating System Analysis dashboard.
dash_os_util_timeout 1800 seconds Specifies the number of seconds after which the Utilisation line chart is auto-refreshed on the Operating System Analysis dashboard.
dash_probe_log_timeout 300 seconds Specifies the number of seconds after which the Probe Log table is auto-refreshed on
dash_replication_archivestat_span 7 days Specifies the number of days worth of data to plot on the WAL Archive Status chart on the Streaming Replication Analysis dashboard.
dash_replication_archivestat_timeout 1800 seconds Specifies the number of seconds after which the WAL Archive Status line chart is auto-refreshed on the Streaming Replication dashboard.
dash_replication_pagelag_span 7 days Specifies the number of days worth of data to plot on the WAL Lag Pages chart on the Streaming Replication dashboard.
dash_replication_pagelag_timeout 1800 seconds Specifies the number of seconds after which the WAL Lag Pages line chart is auto-refreshed on the Streaming Replication dashboard.
dash_replication_segmentlag_span 7 days Specifies the number of days worth of data to plot on the WAL Lag Segments chart on the Streaming Replication dashboard.
dash_replication_segmentlag_timeout 1800 seconds Specifies the number of seconds after which the WAL Lag Segments line chart is auto-refreshed on the Streaming Replication dashboard.
dash_replication_timelag_span 7 days Specifies the number of days worth of data to plot on the Replication Lag Time chart on the Streaming Replication dashboard.
dash_replication_timelag_timeout 1800 seconds Specifies the number of seconds after which the Replication Lag Time line chart is auto-refreshed on the Streaming Replication dashboard.
dash_server_buffers_written 168 hours Specifies the number of days worth of data to plot on the Background Writer Statistics chart on the Server Analysis dashboard.
dash_server_buffers_written_timeout 300 seconds Specifies the number of seconds after which the Background Writer Statistics line chart is auto-refreshed on the Server Analysis dashboard.
dash_server_connovervw_timeout 300 seconds Specifies the number of seconds after which the Connection Overview pie chart is auto-refreshed in the Server Analysis dashboard.
dash_server_database_timeout 300 seconds Specifies the number of seconds after which the Databases table is auto-refreshed in the Server Analysis dashboard.
dash_server_dbsize_span 7 days Specifies the number of days worth of data to plot on the Database Size Analysis on the Server Analysis dashboard.
dash_server_dbsize_timeout 1800 seconds Specifies the number of seconds after which the Database Size line chart is auto-refreshed in the Server Analysis dashboard.
dash_server_disk_timeout 1800 seconds Specifies the number of seconds after which the Disk line chart is auto-refreshed in the Server Analysis dashboard.
dash_server_global_span 7 days Specifies the number of days worth of data to plot on the Disk line chart on the Server Analysis dashboard.
dash_server_sharedbuff_span 7 days Specifies the number of days worth of data to plot on the Shared Buffer chart on the Server Analysis dashboard.
dash_server_sharedbuff_timeout 1800 seconds Specifies the number of seconds after which the Shared Buffers line chart is auto-refreshed in the Server Analysis dashboard.
dash_server_tabspacesize_span 7 days Specifies the number of days worth of data to plot on the Tablespace Size chart on the Server Analysis dashboard.
dash_server_tabspacesize_timeout 1800 seconds Specifies the number of seconds after which the Tablespace Size line chart is auto-refreshed in the Server Analysis dashboard.
dash_server_useract_span 7 days Specifies the number of days worth of data to plot on the User Activity chart on the Server Analysis dashboard.
dash_server_useract_timeout 1800 seconds Specifies the number of seconds after which the User Activity line chart is auto-refreshed in the Server Analysis dashboard.
dash_sessact_lockact_timeout 300 seconds Specifies the number of seconds after which the Session Lock Activity table is auto-refreshed in the Session Activity Analysis dashboard.
dash_sessact_workload_timeout 300 seconds Specifies the number of seconds after which the Session Workload table is auto-refreshed in the Session Activity Analysis dashboard.
dash_sess_waits_nowaits_timeout 300 seconds Specifies the number of seconds after which the Session Waits By Number Of Waits pie
dash_sess_waits_timewait_timeout 300 seconds Specifies 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_timeout 300 seconds Specifies the number of seconds after which the Session Waits Details table is auto-refreshed in the Session Waits Analysis dashboard.
dash_storage_dbdtls_timeout 300 seconds Specifies the number of seconds after which the Database Details table is auto-refreshed in the Storage Analysis dashboard.
dash_storage_dbovervw_timeout 300 seconds Specifies the number of seconds after which the Database Overview pie chart is auto-refreshed in the Storage Analysis dashboard.
dash_storage_hostdtls_timeout 300 seconds Specifies the number of seconds after which the Host Details table is auto-refreshed
dash_storage_hostovervw_timeout 300 seconds Specifies the number of seconds after which the Host Overview pie chart is auto-refreshed in the Storage Analysis dashboard.
dash_storage_tblspcdtls_timeout 300 seconds Specifies the number of seconds after which the Tablespace Details table is auto-refreshed in the Storage Analysis dashboard.
dash_storage_tblspcovervw_timeout 300 seconds Specifies the number of seconds after which the Tablespace Overview pie chart is auto-refreshed in the Storage Analysis dashboard.
dash_sys_waits_nowaits_timeout 300 seconds Specifies 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_timeout 300 seconds Specifies 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_timeout 300 seconds Specifies the number of seconds after which the System Waits Details table is auto-refreshed in the System Waits Analysis dashboard.
deleted_charts_retention_time 7 days Specifies the number of days that a custom chart (displayed on a user-defined dashboard) is stored.
deleted_probes_retention_time 7 days Specifies the number of days that a custom probe (displayed on a user-defined dashboard) is stored.
download_chart_format jpeg Specifies the format in which a downloaded chart will be stored. May be jpeg or png.
flapping_detection_state_change 3 Specifies the number of state changes detected within a specified interval to define a given alert as flapping.
job_retention_time 30 days Specifies the number of days that non-recurring scheduled tasks and their associated
long_running_transaction_minutes 5 minutes Specifies 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_enabled t Specifies whether alert notification will be submitted to nagios or not.
nagios_medium_alert_as_critical f Specifies whether medium level PEM alert will be considered as critical in nagios.
nagios_spool_retention_time 7 days Specifies the number of days to retain nagios messages in the spool table before they are discarded.
package_catalog_xml <address> Specifies path of the catalog file which will be read by package catalog probe to get the list of all the supported packages.
package_download_chunk_size 1024 bytes Specify the size( in Bytes) to be read from network while downloading packages. By default, through PEM 6, 1KB, for PEM 7 and forward, 1MB.
probe_log_retention_time 30 days Specifies the number of days that probe log records are retained.
proxy_server 127.0.0.1 Use this parameter to specify the IP Address of a proxy server.
proxy_server_authentication f Set this parameter to t (true) if your proxy server requires authentication.
proxy_server_enabled f If you use a proxy server on a client machine (when connecting with internet), enable this setting to read the manifest file and download packages.
proxy_server_password   If your proxy server requires authentication, use this parameter to provide the password that will be used for authentication.
proxy_server_port 80 Use this parameter to specify the port for a proxy server.
proxy_server_username   If your proxy server requires authentication, use this parameter to provide the
reminder_notification_interval 24 hours Specifies the number of hours after which a reminder email is sent in case an alert has not been cleared.
server_log_retention_time 30 days Specifies the number of days that the server log is retained on the PEM server.
show_data_tab_on_graph false If ‘true’, a Data tab is added to each graph. Select the Data tab to review the data that is plotted on the graph.
smtp_authentication false Specifies whether to enable/disable authentication over SMTP.
smtp_enabled true Specifies whether to enable/disable sending of emails.
smtp_encryption false Specifies whether to send SMTP email using an encrypted connection.
smtp_password   Specifies the password to be used to connect to the SMTP server.
smtp_port 25 Specifies the SMTP server port to be used for sending email.
smtp_server 127.0.0.1 Specifies the SMTP server host address to be used for sending email.
smtp_spool_retention_time 7 days Specifies the number of days to retain sent email messages in the spool table before they are discarded.
smtp_username   Specifies the username to be used to connect to SMTP server.
snmp_community public Specifies the SNMP community used when sending traps. Used only with SNMPv1 and SNMPv2.
snmp_enabled true Specifies whether to enable/disable sending SNMP traps.
snmp_port 162 Specifies the SNMP server port to be used for sending SNMP traps.
snmp_server 127.0.0.1 Specifies the SNMP server host address to be used for sending SNMP traps.
snmp_spool_retention_time 7 days Specifies the number of days to retain sent traps in the spool table before they are discarded.
snmp_security_name   Specifies the user name or security name for sending SNMP traps. Used only with SNMPv3.
snmp_security_engine_id   Specifies the Engine id of the SNMP Agent on the SNMP Server. Used only with SNMPv3.
snmp_security_level NOAUTH_NOPRIV Specifies 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_name   Specifies the Context name, the identifier for MIB objects when sending SNMP traps. Used only with SNMPv3
snmp_context_engine_id   Specifies 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_protocol NONE Specifies the authentication type for SNMP traps. Its possible values can be NONE,HMACMD5 or HMACSHA. Used only with SNMPv3.
snmp_privacy_protocol NONE Specifies the privacy protocol for SNMP traps. Its possible values can be NONE, DES, AES128, IDEA, AES192, or AES256. Used only with SNMPv3.
snmp_authentication_password   Specifies the authentication password associated with security name mentioned in snmp_security_name. Used only for SNMPv3.
snmp_privacy_password   Specifies the privacy password associated with security name mentioned in snmp_security_name. Used only for SNMPv3.
webclient_help_pg EnterpriseDB hosted documentation Specifies 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 Name Description
# Dead Tuples The 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 Scans The number of heap tuples fetched by index scans.
# Heap Tuples Fetched by Index Scans The cumulative number of heap tuples fetched by index scans.
# Idle Backends+ The cumulative number of currently idle backend clients.
# Index Scans The number of index scans performed on the specified object.
# Index Scans+ The cumulative number of index scans performed on the specified object.
# Index Tuples Read The number of index tuples read.
# Index Tuples Read+ The cumulative number of index tuples read.
# Live Tuples The number of tuples visible to transactions.
# Live Tuples+ The cumulative number of tuples visible to transactions.
# Pages Estimated by ANALYZE The number of pages estimated by ANALYZE.
# Pages Estimated by ANALYZE+ The cumulative number of pages estimated by ANALYZE.
# Sequential Scans The number of sequential scans performed on the specific table.
# Sequential Scans+ The cumulative number of sequential scans performed on the specific table.
# Sequential Scan Tuples The number of tuples sequentially scanned in the specific table.
# Sequential Scan Tuples+ The cumulative number of tuples sequentially scanned in the specific table.
# Tuples Deleted The number of tuples deleted.
# Tuples Deleted+ The cumulative number of tuples deleted.
# Tuples Estimated by ANALYZE The number of live (visible) tuples estimated by ANALYZE.
# Tuples Estimated by ANALYZE+ The cumulative number of live tuples estimated by ANALYZE.
# Tuples HOT Updated The 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 Inserted The number of tuples inserted into the specified table.
# Tuples Inserted+ The cumulative number of tuples inserted into the specified table.
# Tuples Updated The number of tuples updated in the selected table.
# Tuples Updated+ The cumulative number of tuples updated in the selected table.
Blocks Hit The number of blocks found in the cache.
Blocks Hit+ The cumulative number of blocks found in the cache.
Blocks Read The number of blocks read.
Blocks Read+ The cumulative number of blocks read.
Blocks Read from InfiniteCache The number of blocks read from InfiniteCache.
Blocks Read from InfiniteCache+ The cumulative number of blocks read from InfiniteCache.
Blocks Written The number of blocks written.
Blocks Written+ The cumulative number of blocks written.
Buffers Allocated The number of buffers allocated.
Buffers Allocated+ The cumulative number of buffers allocated.
Buffers Written - Backends The 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 - Checkpoint The 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 Scan The 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 - Timed The number of checkpoint operations triggered by the checkpoint interval.
Checkpoints - Timed+ The cumulative number of checkpoint operations triggered by the checkpoint interval.
Checkpoints - Untimed The 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 Memory The amount of free RAM memory (in megabytes).
Free Swap Memory The amount of free swap space on disk (in megabytes).
Heap Blocks Hit The number of heap blocks found in the cache.
Heap Blocks Hit+ The cumulative number of heap blocks found in the cache.
Heap Blocks Read The number of heap blocks read.
Heap Blocks Read+ The cumulative number of heap blocks read.
Index Blocks Hit The number of index blocks found in the cache.
Index Blocks Hit+ The cumulative number of index blocks found in the cache.
Index Blocks Read The 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 Discards The number of inbound packets discarded.
In Packets Discards+ The cumulative number of inbound packets discarded.
In Packets Errors The 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 Minute CPU saturation (in percent) - 15 minute sampling average.
Load Average - 1 Minute CPU saturation (in percent) - 1 minute sampling average.
Load Average - 5 Minute CPU saturation (in percent) - 5 minute sampling average.
Load Percentage CPU 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 Discards The number of outbound packets discarded.
Out Packets Discards+ The cumulative number of outbound packets discarded.
Out Packets Errors The number of outbound packets that contain errors.
Out Packets Errors+ The cumulative number of outbound packets that contain errors.
Packets Received The number of packets received.
Packets Received+ The cumulative number of packets received.
Packets Sent The 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 Hit The number of TOAST blocks found in the cache.
Toast Blocks Hit+ The cumulative number of TOAST blocks found in the cache.
Toast Blocks Read The number of TOAST blocks read.
Toast Blocks Read+ The cumulative number of TOAST blocks read.
Total RAM Memory The total amount of RAM memory on the system (in megabytes).
Total Swap Memory The total amount of swap space on the system (in megabytes).
Total Table Size w/Indexes and Toast The total size of the specified table (including indexes and associated oversized attributes).
Transactions Aborted The number of aborted transactions.
Transactions Aborted+ The cumulative number of aborted transactions.
Transactions Committed The number of committed transactions.
Transactions Committed+ The cumulative number of committed transactions.
Tuples Deleted The number of tuples deleted from the specified table.
Tuples Deleted+ The cumulative number of tuples deleted from the specified table.
Tuples Estimated by ANALYZE The number of visible tuples in the specified table.
Tuples Estimated by ANALYZE+ The cumulative number of visible tuples in the specified table.
Tuples Fetched The number of tuples fetched from the specified table.
Tuples Fetched+ The cumulative number of tuples fetched from the specified table.
Tuples HOT Updated The 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 Inserted The number of tuples inserted into the specified table.
Tuples Inserted+ The cumulative number of tuples inserted into the specified table.
Tuples Returned The number of tuples returned in result sets.
Tuples Returned+ The cumulative number of tuples returned in result sets.
Tuples Updated The 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 Name Information Monitored by Probe Level
Background Writer Statistics

This 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 Information This probe provides information about blocked sessions. Server
CPU Usage This probe monitors CPU Usage information. Agent
Data and Log File Analysis

This 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 Statistics

This 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 Info

This probe monitors information about disk activity.

Note: This probe is not supported on Mac OS X, Solaris or HP-UX

Agent
Disk Space

This 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 Configuration This probe monitors the audit logging configuration of EDB Postgres Advanced Server. Server
Failover Manager Cluster Info This 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 Status This 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 Statistics

This probe monitors a database, retrieving information about functions. The information includes:

Function names

Argument types

Return values

Database
Index Size

This 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 Statistics

This 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 Packages

This 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 Analysis

This 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 Average

This 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 Information

This probe monitors lock information. The information includes:

The database name

The lock type

The lock mode

The process holding the lock

Server
Memory Usage This probe monitors information about system memory usage. Agent
Network Statistics

This 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 Transactions This probe stores the number of prepared transactions. Server
Number of WAL Files This probe monitors the number of WAL files. Server
Object Catalog: Database

This 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 Key

This 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: Function

This 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: Index

This 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: Schema This probe monitors a list of schemas and their associated databases and servers. Database
Object Catalog: Sequence This probe monitors a list of sequences and their properties. Schema
Object Catalog: Table

This 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: Tablespace This probe monitors a list of tablespaces. Server
Operating System Information This probe monitors the operating system details and boot time. Agent
Package Catalog

This probe monitors the packages that are currently available for installation. The information gathered includes:

The package name

The package version

Agent
PG HBA Conf This probe monitors authentication configuration information from the pg_hba.conf file. Server
Server Information This probe monitors server information. Server
Session Information

This 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
Settings This probe monitors the values currently assigned to GUC variables. Server
SQL Protect This probe monitors a server, retrieving information about SQL injection attacks. Server
Slony Replication This probe monitors lag data for clusters replicated using Slony. Database
Streaming Replication

This 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 Time

This 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 Conflicts

This 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 Bloat

This 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 XID This probe monitors the frozen XID of each table. Schema
Table Size

This 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
Table Statistics This probe monitors a list of tablespaces and their sizes. Server
Tablespace Size This probe monitors a list of tablespaces and their sizes. Server
User Information

This 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 Status

This 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 Replication This 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 Name Description
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 utilization Average CPU consumption.
Number of CPUs running higher than a Number of CPUs running at greater than K% utilization threshold
Free memory percentage Free memory as a percent of total system memory.
Memory used percentage Percentage of memory used.
Swap consumption Swap space consumed (in megabytes).
Swap consumption percentage Percentage of swap area consumed.
Disk Consumption Disk space consumed (in megabytes).
Disk consumption percentage Percentage of disk consumed.
Disk Available Disk space available (in megabytes).
Disk busy percentage Percentage of disk busy.
Most used disk percentage Percentage used of the most utilized disk on the system.
Total table bloat on host The total space wasted by tables on a host, in MB.
Highest table bloat on host The most space wasted by a table on a host, in MB.
Average table bloat on host The average space wasted by tables on host, in MB.
Table size on host The size of tables on host, in MB.
Database size on host The 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 hours The 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 hours The number of WARNINGS or ERRORS in the logfile on agent N in last X hours.
Package version mismatch Check for package version mismatch as per catalog.
Total materialized view bloat on host The total space wasted by materialized views on a host, in MB.
Highest materialized view bloat on host The most space wasted by a materialized view on a host, in MB.
Average materialized view bloat on host The average space wasted by materialized views on host, in MB.
Materialized view size on host The size of materialized views on host, in MB.
Agent Down Specified agent is currently down.

Templates applicable on Server

Template Name Description
Total table bloat in server The 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 server The most space wasted by a table in server, in MB.
Average table bloat in server The average space wasted by tables in server, in MB.
Table size in server The size of tables in server, in MB.
Database size in server The size of databases in server, in MB.
Number of WAL files Total number of Write Ahead Log files.
Number of prepared transactions Number of transactions in prepared state.
Total connections Total number of connections in the server.
Total connections as percentage of Total number of connections in the server as a percentage of maximum
max_connections connections allowed on server, settings.
Unused, non-superuser connections Number of unused, non-superuser connections on the server, user_info, settings.
Unused, non-superuser connections as percentage of max_connections Number of unused, non-superuser connections on the server as a percentage of max_connections of max_connections, user_info, settings.
Ungranted locks Number of ungranted locks in server.
Percentage of buffers written by backends The percentage of buffers written by backends vs. the total buffers written.
Percentage of buffers written by checkpoint The percentage of buffers written by the checkpoints vs. the total buffers written.
Buffers written per second Number of buffers written per second, over the last two probe cycles.
Buffers allocated per second Number of buffers allocated per second, over the last two probe cycles.
Connections in idle state Number of connections in server that are in idle state.
Connections in idle-in-transaction state Number of connections in server that are in idle-in-transaction state.
Connections in idle-in-transaction state, as percentage of max_connections Number of connections in server that are in idle-in-transaction state, as a percentage of maximum connections allowed on server, settings.
Long-running idle connections Number of connections in the server that have been idle for more than N seconds.
Long-running idle connections and idle transactions Number of connections in the server that have been idle or transactions idle-in-transaction for more than N seconds.
Long-running idle transactions Number of connections in the server that have been idle in transaction for more than N seconds.
Long-running transactions Number of transactions in server that have been running for more than N seconds.
Long-running queries Number of queries in server that have been running for more than N seconds.
Long-running vacuums Number of vacuum operations in server that have been running for more than N seconds.
Long-running autovacuums Number of autovacuum operations in server that have been running for more than N seconds.
Committed transactions percentage Percentage of transactions in the server that committed vs. that rolled-back over last N minutes.
Shared buffers hit percentage Percentage of block read requests in the server that were satisfied by shared buffers, over last N minutes.
Tuples inserted Tuples inserted into server over last N minutes.
InfiniteCache buffers hit percentage Percentage of block read requests in the server that were satisfied by InfiniteCache, over last N minutes.
Tuples fetched Tuples fetched from server over last N minutes.
Tuples returned Tuples returned from server over last N minutes.
Dead Tuples Number of estimated dead tuples in server.
Tuples updated Tuples updated in server over last N minutes.
Tuples deleted Tuples deleted from server over last N minutes.
Tuples hot updated Tuples hot updated in server, over last N minutes.
Sequential Scans Number of full table scans in server, over last N minutes.
Index Scans Number of index scans in server, over last N minutes.
Hot update percentage Percentage of hot updates in the server over last N minutes.
Live Tuples Number of estimated live tuples in server.
Dead tuples percentage Percentage of estimated dead tuples in server.
Last Vacuum Hours since last vacuum on the server.
Last AutoVacuum Hours since last autovacuum on the server.
Last Analyze Hours since last analyze on the server.
Last AutoAnalyze Hours since last autoanalyze on the server.
Percentage of buffers written by backends over the last N minutes The percentage of buffers written by backends vs. the total buffers backends over last N
Table Count Total number of tables in server.
Function Count Total number of functions in server.
Sequence Count Total number of sequences in server.
A user expires in N days Number of days before a user’s validity expires.
Index size as a percentage of table size Size 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 hours The 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 hours The 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 hours The number of WARNINGS or ERRORS in the logfile on server M in the last X hours.
Number of attacks detected in the last N minutes The number of SQL injection attacks occurred in the last N minutes.
Number of attacks detected in the last N minutes by username The number of SQL injection attacks occurred in the last N minutes by username.
Number of standby servers lag behind the master by write location Streaming Replication: number of standby servers lag behind the master by write location.
Number of standby servers lag behind the master by flush location Streaming Replication: number of standby servers lag behind the master by flush location.
Number of standby servers lag behind the master by replay location Streaming Replication: number of standby servers lag behind the master by replay location.
Standby server lag behind the master by write location Streaming Replication: standby server lag behind the master by write location in MB.
Standby server lag behind the master by flush location Streaming Replication: standby server lag behind the master by flush location in MB.
Standby server lag behind the master by replay location Streaming Replication: standby server lag behind the master by replay location in MB.
Standby server lag behind the master by size (MB) Streaming Replication: standby server lag behind the master by size in MB.
Standby server lag behind the master by WAL segments Streaming Replication: standby server lag behind the master by WAL segments.
Standby server lag behind the master by WAL pages Streaming Replication: standby server lag behind the master by WAL pages.
Total materialized view bloat in server The 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 server The most space wasted by a materialized view in server, in MB.
Average materialized view bloat in server The average space wasted by materialized views in server, in MB.
Materialized view size in server The size of materialized view in server, in MB.
View Count Total number of views in server.
Materialized View Count Total number of materialized views in server.
Audit config mismatch Check for audit config parameter mismatch
Server Down Specified server is currently inaccessible.
Number of WAL archives pending Streaming Replication: number of WAL files pending to be replayed at standby.
Number of minutes lag of standby server from master server Streaming Replication: number of minutes standby node is lagging behind the master node.
Log config mismatch Check for log config parameter mismatch.

Templates applicable on Database

Template Name Description
Total table bloat in database The 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 database The most space wasted by a table in database, in MB.
Average table bloat in database The average space wasted by tables in database, in MB.
Table size in database The size of tables in database, in MB.
Database size The size of the database, in MB.
Total connections Total number of connections in the database.
Total connections as percentage of max_connections Total number of connections in the database as a percentage of maximum connections allowed on server, settings.
Ungranted locks Number of ungranted locks in database.
Connections in idle state Number of connections in database that are in idle state.
Connections in idle-in-transaction state Number of connections in database that are in idle-in-transaction state
Connections in idle-in-transaction state,as percentage of max_connections Number of connections in database that are in idle-in-transaction state, as a percentage of maximum connections allowed on server, settings.
Long-running idle connections Number of connections in the database that have been idle for more than N seconds.
Long-running idle connections and idle transactions Number of connections in the database that have been idle or idle-in-transaction for more than N seconds.
Long-running idle transactions Number of connections in the database that have been idle in transaction for more than N seconds.
Long-running transactions Number of transactions in database that have been running for more than N seconds.
Long-running queries Number of queries in database that have been running for more than N seconds.
Long-running vacuums Number of vacuum operations in database that have been running for more than N seconds.
Long-running autovacuums Number of autovacuum operations in database that have been running for more than N seconds.
Committed transactions percentage Percentage of transactions in the database that committed vs. that rolled-back over last N minutes.
Shared buffers hit percentage Percentage of block read requests in the database that were satisfied by shared buffers, over last N minutes.
InfiniteCache buffers hit percentage Percentage of block read requests in the database that were satisfied by InfiniteCache, over last N minutes.
Tuples fetched Tuples fetched from database over last N minutes.
Tuples returned Tuples returned from database over last N minutes.
Tuples inserted Tuples inserted into database over last N minutes.
Tuples updated Tuples updated in database over last N minutes.
Tuples deleted Tuples deleted from database over last N minutes.
Tuples hot updated Tuples hot updated in database, over last N minutes.
Sequential Scans Number of full table scans in database, over last N minutes.
Index Scans Number of index scans in database, over last N minutes.
Hot update percentage Percentage of hot updates in the database over last N minutes.
Live Tuples Number of estimated live tuples in database.
Dead Tuples Number of estimated dead tuples in database.
Dead tuples percentage Percentage of estimated dead tuples in database.
Last Vacuum Hours since last vacuum on the database.
Last AutoVacuum Hours since last autovacuum on the database.
Last Analyze Hours since last analyze on the database.
Last AutoAnalyze Hours since last autoanalyze on the database.
Table Count Total number of tables in database.
Function Count Total number of functions in database.
Sequence Count Total number of sequences in database.
Index size as a percentage of table size Size of the indexes in database, as a percentage of their tables’ size.
Largest index by table-size percentage Largest index in database, calculated as percentage of its table’s size, oc_index, table_size.
Database Frozen XID The age (in transactions before the current transaction) of the database’s frozen transaction ID.
Number of attacks detected in the The number of SQL injection attacks occurred in the last N minutes. last N minutes
Number of attacks detected in the The 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 tablespaces Streaming Replication: number of queries that have been cancelled due to dropped tablespaces.
Queries that have been cancelled due to lock timeouts Streaming Replication: number of queries that have been cancelled due to lock timeouts.
Queries that have been cancelled due to old snapshots Streaming Replication: number of queries that have been cancelled due to old snapshots.
Queries that have been cancelled due to pinned buffers Streaming Replication: number of queries that have been cancelled due to pinned buffers.
Queries that have been cancelled due to deadlocks Streaming Replication: number of queries that have been cancelled due to deadlocks.
Total events lagging in all slony clusters Slony Replication: total events lagging in all slony clusters.
Events lagging in one slony cluster Slony Replication: events lagging in one slony cluster.
Lag time (minutes) in one slony cluster Slony Replication: lag time (minutes) in one slony cluster.
Total rows lagging in xdb single master replication xDB Replication: Total rows lagging in xdb single master replication
Total rows lagging in xdb multi master replication xDB Replication: Total rows lagging in xdb multi master replication.
Total materialized view bloat in database The 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 database The most space wasted by a materialized view in database, in MB.
Average materialized view bloat in database The average space wasted by materialized views in database, in MB.
Materialized view size in database The size of materialized view in database, in MB.
View Count Total number of views in database.
Materialized View Count Total number of materialized views in database.

Templates applicable on Schema

Template Name Description
Total table bloat in schema The 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 schema The most space wasted by a table in schema, in MB.
Average table bloat in schema The average space wasted by tables in schema, in MB.
Table size in schema The size of tables in schema, in MB.
Tuples inserted Tuples inserted in schema over last N minutes.
Tuples updated Tuples updated in schema over last N minutes.
Tuples deleted Tuples deleted from schema over last N minutes.
Tuples hot updated Tuples hot updated in schema, over last N minutes.
Sequential Scans Number of full table scans in schema, over last N minutes.
Index Scans Number of index scans in schema, over last N minutes.
Hot update percentage Percentage of hot updates in the schema over last N minutes.
Live Tuples Number of estimated live tuples in schema.
Dead Tuples Number of estimated dead tuples in schema.
Dead tuples percentage Percentage of estimated dead tuples in schema.
Last Vacuum Hours since last vacuum on the schema.
Last AutoVacuum Hours since last autovacuum on the schema.
Last Analyze Hours since last analyze on the schema.
Last AutoAnalyze Hours since last autoanalyze on the schema.
Table Count Total number of tables in schema.
Function Count Total number of functions in schema.
Sequence Count Total number of sequences in schema.
Index size as a percentage of table size Size of the indexes in schema, as a percentage of their table’s size.
Largest index by table-size percentage Largest index in schema, calculated as percentage of its table’s size, oc_index, table_size
Materialized View bloat Space wasted by the materialized view, in MB.
Total materialized view bloat in schema The total space wasted by materialized views in schema, in MB.
Materialized view size as a multiple of unbloated size Size 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 schema The most space wasted by a materialized view in schema, in MB.
Average materialized view bloat in schema The average space wasted by materialized views in schema, in MB.
Materialized view size The size of materialized view, in MB.
Materialized view size in schema The size of materialized views in schema, in MB.
View Count Total number of views in schema.
Materialized View Count Total number of materialized views in schema.
Materialized View Frozen XID The age (in transactions before the current transaction) of the materialized view’s frozen transaction ID.

Templates applicable on Table

Template Name Description
Table bloat Space wasted by the table, in MB.
Table size The size of table, in MB.
Table size as a multiple of ubloated size Size of the table as a multiple of estimated unbloated size.
Tuples inserted Tuples inserted in table over last N minutes.
Tuples updated Tuples updated in table over last N minutes.
Tuples deleted Tuples deleted from table over last N minutes.
Tuples hot updated Tuples hot updated in table, over last N minutes.
Sequential Scans Number of full table scans on table, over last N minutes.
Index Scans Number of index scans on table, over last N minutes.
Hot update percentage Percentage of hot updates in the table over last N minutes.
Live Tuples Number of estimated live tuples in table.
Dead Tuples Number of estimated dead tuples in table.
Dead tuples percentage Percentage of estimated dead tuples in table.
Last Vacuum Hours since last vacuum on the table.
Last AutoVacuum Hours since last autovacuum on the table.
Last Analyze Hours since last analyze on the table.
Last AutoAnalyze Hours since last autoanalyze on the table.
Row Count Estimated number of rows in a table.
Index size as a percentage of table size Size of the indexes on table, as a percentage of table’s size.
Table Frozen XID The age (in transactions before the current transaction) of the table’s frozen transaction ID.

Global Templates

Template Name Description
Agents Down Number of agents that haven’t reported in recently.
Servers Down Number of servers that are currently inaccessible.
Alert Errors Number of alerts in an error state.