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. Flapping starts when more than N state changes have occurred over [ N + 1 * (min(probe_interval) * 2)] minutes and the fine state is not None. Where the default value of N is 2 or 3, and min(probe_interval) is the smallest interval for all the probes used by the alert. Flapping ends when ZERO state changes have occurred over [2 N * min(probe_interval)] minutes.

job_retention_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.

probe_log_retention_time

30 days

Specifies the number of days that probe log records are retained.

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

EDB 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 replica servers lag behind the primary by write location

Streaming Replication: number of replica servers lag behind the primary by write location.

Number of replica servers lag behind the primary by flush location

Streaming Replication: number of replica servers lag behind the primary by flush location.

Number of replica servers lag behind the primary by replay location

Streaming Replication: number of replica servers lag behind the primary by replay location.

Replica server lag behind the primary by write location

Streaming Replication: replica server lag behind the primary by write location in MB.

Replica server lag behind the primary by flush location

Streaming Replication: replica server lag behind the primary by flush location in MB.

Replica server lag behind the primary by replay location

Streaming Replication: replica server lag behind the primary by replay location in MB.

Replica server lag behind the primary by size (MB)

Streaming Replication: replica server lag behind the primary by size in MB.

Replica server lag behind the primary by WAL segments

Streaming Replication: replica server lag behind the primary by WAL segments.

Replica server lag behind the primary by WAL pages

Streaming Replication: replica server lag behind the primary by WAL pages.

Total materialized view bloat in 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 replica.

Number of minutes lag of replica server from primary server

Streaming Replication: number of minutes replica node is lagging behind the primary node.

Log config 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 primary replication

xDB Replication: Total rows lagging in xdb single primary replication

Total rows lagging in xdb multi primary replication

xDB Replication: Total rows lagging in xdb multi primary replication.

Total materialized view bloat in 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.