Probes

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

Unless otherwise noted, Postgres Enterprise Manager™ enables the probes listed in the table below:

Probe Name Information Monitored by Probe Probe Configuration 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 returns 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 Frozen XID This probe monitors the frozen XID of each database. Server
Database Size

This probe monitors information about the size of the monitored databases. The information includes:

  • The time the information was gathered
  • The database name
  • The database size (in MB’s)
Server
Database 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 Postgres Plus Advanced Servers. 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 information about servers. 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 information about table size. The information includes:

  • Table size (in MB’s)
  • Total index size (in MB’s)
  • Total table size, with indexes and TOAST (in MB’s)
Database
Table Statistics

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