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. |
webclient_help_pg |
EnterpriseDB hosted documentation |
Specifies the location of the online PostgreSQL core documentation. |
web_client_product_key |
Specifies the product key of the PEM web client. This parameter may be changed by users with Administrative privileges. |
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. |
