Probes v8.0

Edit this page

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 NameInformation Monitored by ProbeProbe Configuration Level
Background Writer StatisticsThis probe monitors information about the background writer. The information includes:
- The number of timed checkpoints
- The number of requested checkpoints
- The number of buffers written (by checkpoint)
- The number of buffers written (by background writer)
- The number of background writer cycles
- The number of background buffers written
- The number of buffers allocated
Server
Blocked Session InformationThis probe returns information about blocked sessions.Server
CPU UsageThis probe monitors CPU Usage information.Agent
Data and Log File AnalysisThis probe monitors information about log files. The information includes:
- The name of the log file
- The directory in which the log file resides
Server
Database Frozen XIDThis probe monitors the frozen XID of each database.Server
Database SizeThis probe monitors information about the size of the monitored databases. The information includes:
- The time the information was gathered
- The database name
- The database size (in MB's)
Server
Database StatisticsThis probe monitors database statistics. The information includes:
- The number of backends
- The number of transactions committed
- The number of transactions rolled back
- The number of blocks read
- The number of blocks hit
- The number of rows returned
- The number of rows fetched
- The number of rows inserted
- The number of rows updated
- The number of rows deleted
Server
Disk Busy InfoThis probe monitors information about disk activity.
- Note: This probe is not supported on Mac OS X, Solaris or HP-UX
Agent
Disk SpaceThis probe monitors information about disk space usage. The information includes:
- The amount of disk space used
- The amount of disk space available
Agent
EDB Audit ConfigurationThis probe monitors the audit logging configuration of Postgres Plus Advanced Servers.Server
Failover Manager Cluster InfoThis probe monitors a Failover Manager cluster, returning information about the cluster. This probe is disabled unless a cluster name and path of the Failover Manager binary is provided on the Server Properties dialog.Server
Failover Manager Node StatusThis probe monitors a Failover Manager cluster, returning detailed about each node within the cluster. This probe is disabled unless a cluster name and path of the Failover Manager binary is provided on the Server Properties dialog.Server
Function StatisticsThis probe monitors a database, retrieving information about functions. The information includes:
- Function names
- Argument types
- Return values
Database
Index SizeThis probe monitors a database, retrieving information about indexes. The information includes:
- The name of the index
- The time the data was gathered
- The size of the index (in MB's)
Database
Index StatisticsThis probe monitors index statistics. The information includes:
- The number of index scans
- The number of rows read
- The number of rows fetched
- The number of blocks read
- The number of blocks hit
Database
Installed PackagesThis probe monitors the packages that are currently installed. The information gathered includes:
- The name of the installed package
- The version of the installed package
- The date and time that the probe executed



Agent

IO AnalysisThis probe monitors disk I/O information in. The information includes:
- The number of blocks read
- The number of blocks written
- The date and time that the probe executed
- Note: This probe is not supported on Mac OS X



Agent

Load AverageThis probe monitors CPU load averages. The information includes:
- The 1-minute load average
- The 5-minute load average
- The 15-minute load average
- Note: This probe is not supported on Windows
Agent
Lock InformationThis probe monitors lock information. The information includes:
- The database name
- The lock type
- The lock mode
- The process holding the lock
Server
Memory UsageThis probe monitors information about system memory usage. The information includes:
- Total RAM in MB
- Free RAM in MB
- Total swap memory in MB
- Free swap memory in MB
- Shared system memory in MB (It is used by tuning wizard to tune the memory parameters for the database server)
- On non-windows system, it is shmmax value and read from /proc/sys/kernel/shmmax
- On windows, it is same as total memory.
Agent
Network StatisticsThis probe monitors network statistics. The information includes:
- The interface IP address
- The number of packets sent
- The number of packets received
- The number of bytes sent
- The number of bytes received
- The link speed (in MB/second)
Agent
Number of Prepared TransactionsThis probe stores the number of prepared transactions.Server
Number of WAL FilesThis probe monitors the number of WAL files.Server
Object Catalog: DatabaseThis probe monitors a list of databases and their properties The information includes:
- The database name
- The database encoding type
- If the database allows user connections or system connections
Server
Object Catalog: Foreign KeyThis probe monitors a list of foreign keys and their properties. The information includes:
- The name of the table that contains the foreign key
- The name of the table that the foreign key references
- The name of the database in which the table resides
- The name of the schema in which the table resides
Schema
Object Catalog: FunctionThis probe monitors a list of functions and their properties. The information includes:
- The name of the function
- The name of the schema in which the function resides
- The name of the database in which the function resides
Schema
Object Catalog: IndexThis probe monitors a list of indexes and their properties. The information includes:
- The name of the index
- The name of the table that the index is associated with
- The name of the database in which the indexed table resides
Schema
Object Catalog: SchemaThis probe monitors a list of schemas and their associated databases and servers.Database
Object Catalog: SequenceThis probe monitors a list of sequences and their properties.Schema
Object Catalog: TableThis probe monitors a list of table information. The information includes:
- The table name
- The name of the schema in which the table resides
- The name of the database in which the schema resides
- A Boolean indicator that indicates if the table has a primary key
Schema
Object Catalog: TablespaceThis probe monitors a list of tablespaces.Server
Operating System InformationThis probe monitors the operating system details and boot time.Agent
Package CatalogThis probe monitors the packages that are currently available for installation. The information gathered includes:
- The package name
- The package version
Agent
PG HBA ConfThis probe monitors authentication configuration information from the pg_hba.conf file.Server
Server InformationThis probe monitors information about servers.Server
Session InformationThis probe monitors session information. The information includes:
- The name of the session user
- The date and time that the session connected to the server
- The status of the session at the time that the information was gathered (idle, waiting, etc)
- The client address and port number
Server
SettingsThis probe monitors the values currently assigned to GUC variables.Server
SQL ProtectThis probe monitors a server, retrieving information about SQL injection attacks.Server
Slony ReplicationThis probe monitors lag data for clusters replicated using Slony.Database
Streaming ReplicationThis probe monitors a cluster that is using streaming replication, retrieving information about:
- The sent Xlog location (in bytes)
- The write Xlog location (in bytes)
- The flush Xlog location (in bytes)
- The replay Xlog location (in bytes)
- The Xlog lag (in segments)
- The Xlog lag (in pages)
Server
Streaming Replication Lag TimeThis probe monitors a cluster that is using streaming replication, retrieving lag information about:
- Replication lag time (in seconds)
- Current status of replication (running/paused)
Server
Streaming Replication Database ConflictsThis probe monitors a database that is using streaming replication, retrieving information about any conflicts that arise. This includes information about queries that have been canceled due to:
- The # of drop tablespace conflicts
- The # of lock timeout conflicts
- The # of old snapshot conflicts
- The # of pinned buffer conflicts
- The # of deadlock conflicts
Server
Table BloatThis probe monitors information about the current table bloat. The information includes:
- The name of the table
- The name of the schema in which the table resides
- The estimated number of pages
- The estimated number of wasted pages
- The estimated number of bytes per row
Database
Table Frozen XIDThis probe monitors the frozen XID of each table.Schema
Table SizeThis probe monitors information about table size. The information includes:
- Table size (in MB's)
- Total index size (in MB's)
- Total table size, with indexes and TOAST (in MB's)
Database
Table StatisticsThis probe monitors table statistics. The information includes:
- The number of sequential scans
- The number of sequential scan rows
- The number of index scans
- The number of index scan rows
- The number of rows inserted
- The number of rows updated
- The number of rows deleted
- The number of live rows
- The number of dead rows
- The last VACUUM
- The last auto-vacuum
- The last ANALYZE
- The last auto-analyze
- The number of pages estimated by ANALYZE
- The number of rows estimated by ANALYZE
Database
Tablespace SizeThis probe monitors a list of tablespaces and their sizes.Server
User InformationThis probe monitors a list of the current users. The stored information includes:
- The user name
- The user type (superuser vs. non-superuser)
- The server to which the user is connected
Server
WAL Archive StatusThis probe monitors the status of the WAL archive. The stored information includes:
- The # of WAL archives done
- The # of WAL archives pending
- The last archive time
- The # of WAL archives failed
- The time of the last failure
Server
xDB ReplicationThis probe monitors lag data for clusters replicated using xDB replication.Database