System probes v10.3
Unless otherwise noted, Postgres Enterprise Manager (PEM) enables the following probes at the server, database, schema, extension, or agent levels:
| Name | Information monitored by probe | Level |
|---|---|---|
| Background Writer Statistics | Monitors information about the background writer. The information includes the number of: Timed checkpoints Requested checkpoints Buffers written (by checkpoint) Buffers written (by background writer) Background writer cycles Background buffers written Buffers allocated | Server |
| Barman Configuration | Information about the Barman tool global configuration. | Agent |
| Barman Information | Information about the Barman tool. | Agent |
| Barman Server | Information about the respective database server configuration monitored by Barman. | Agent |
| Barman Server Status | Information about the respective database server status monitored by Barman. | Agent |
| Barman Server Backup | Information about the backups of the respective database servers. | Agent |
| Barman Server WAL Status | Information about the Barman server WAL files. | Agent |
| Blocked Session Information | Information about blocked sessions. | Server |
| CPU Usage | CPU usage information. | Agent |
| Data and Log File Analysis | 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 | The frozen XID of each database. | Server |
| Database Size | 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). | Server |
| Database Statistics | 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 | Information about disk activity. Note: This probe isn't supported on Mac OS X, Solaris, or HP-UX. | Agent |
| Disk Space | Information about disk space usage. The information includes: The amount of disk space used The amount of disk space available | Agent |
| EDB Audit Configuration | The audit logging configuration of EDB Postgres Advanced Server. | Server |
| Function Statistics | Monitors a database, retrieving information about functions. The information includes: Function names Argument types Return values | Database |
| Index Size | 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) | Database |
| Index Statistics | 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 | 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 | Disk I/O information. The information includes: The number of blocks read The number of blocks written The number of read operations The number of write operations The date and time that the probe executed Note: This probe isn't supported on Mac OS X. | Agent |
| Load Average | CPU load averages. The information includes: The 1-minute load average The 5-minute load average The 15-minute load average Note: This probe isn't supported on Windows. | Agent |
| Lock Information | Lock information. The information includes: The database name The lock type The lock mode The process holding the lock | Server |
| Memory Usage | 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: - On non-Windows systems, it is the shmmax value and read from /proc/sys/kernel/shmmax.- On Windows, it is same as total memory. | Agent |
| Network Statistics | 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 | Stores the number of prepared transactions. | Server |
| Number of WAL Files | The number of WAL files. | Server |
| Object Catalog: Database | Monitors a list of databases and their properties. The information includes: The database name The database encoding type Whether or not the database allows user connections or system connections | Server |
| Object Catalog: Foreign Key | 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 | 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 | 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 | Monitors a list of schemas and their associated databases and servers. | Database |
| Object Catalog: Sequence | Monitors a list of sequences and their properties. | Schema |
| Object Catalog: Table | 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 shows whether the table has a primary key | Schema |
| Object Catalog: Tablespace | Monitors a list of tablespaces. | Server |
| Operating System Information | Operating system details and boot time. | Agent |
| Package Catalog | The packages that are currently available for installation. The information gathered includes: The package name The package version | Agent |
| PG HBA Conf | Authentication configuration information from the pg_hba.conf file. | Server |
| Server Information | Server information. | Server |
| Session Information | 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, and so on) The client address and port number | Server |
| Settings | Monitors the values currently assigned to GUC variables. | Server |
| SQL Protect | Monitors a server, retrieving information about SQL injection attacks. | Server |
| Slony Replication | Lag data for clusters replicated using Slony. | Database |
| Streaming Replication | 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 | Monitors a cluster that's using streaming replication, retrieving lag information about: Replication lag time (in seconds) Current status of replication (running/paused) | Server |
| Streaming Replication Database Conflicts | Monitors a database that's using streaming replication, retrieving information about any conflicts that arise. This includes information about queries that were canceled due to the number of: Drop tablespace conflicts Lock timeout conflicts Old snapshot conflicts Pinned buffer conflicts Deadlock conflicts | Server |
| Table Bloat | 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 | Monitors the frozen XID of each table. | Schema |
| Table Size | Information about table size. The information includes: Table size (in MB) Total index size (in MB) Total table size, with indexes and TOAST (in MB) | Database |
| Table Statistics | 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 | A list of tablespaces and their sizes. | Server |
| User Information | A list of the current users. The stored information includes: The user name The user type (superuser or non-superuser) The server to which the user is connected | Server |
| WAL Archive Status | Status of the WAL archive. The stored information includes: The number of WAL archives done The number of WAL archives pending The last archive time The number of WAL archives failed The time of the last failure | Server |
| xDB Replication | Lag data for clusters replicated using xDB replication. | Database |
| Multixact ID Exhaustion (Wraparound) | Information about the multixact ID. The stored information includes: The name of the database The oldest current multixact ID in the database Percentage toward wraparound Percentage toward emergency autovacuum | Server |
| Replication Slots | Information about the replication slots. The stored information includes: A unique, cluster-wide identifier for the replication slot. The base name of the shared object containing the output plugin this logical slot is using, or null for physical slot. The slot type: physical or logical. The OID of the database this slot is associated with, or null. Only logical slots have an associated database. The name of the database this slot is associated with, or null. Only logical slots have an associated database. Active field is True if this slot is currently actively being used. The oldest transaction that this slot needs the database to retain. VACUUM can't remove tuples deleted by any later transaction The oldest transaction affecting the system catalogs that this slot needs the database to retain. VACUUM can't remove catalog tuples deleted by any later transaction. The address (LSN) of oldest WAL, which still might be required by the consumer of this slot and thus won't be automatically removed during checkpoints. | Server |
Postgres distributed (PGD) probes
To monitor the PGD group using dashboards, you must enable the following probes. Configure these probes at the extension level:
Users with pgd_superuser privileges can view information from all the following probes. If you are using a version of EDB Postgres Distributed earlier than 4.0, all these probes work with EDB Postgres Distributed Enterprise Edition.
| Probe name | Information monitored by probe |
|---|---|
| PGD Analytic Slot Name | Provides the analytic slot name. This probe is available from PGD version 6 and later. |
| PGD Conflict History Summary | Information about row conflicts per conflict type. The stored information includes: The local time of the conflict The type of the conflict |
| PGD Global Locks | Information about global locks in a PGD group. The stored information includes: The name of the node where the global lock originated The PID of the process holding the lock The type of lock (DDL or DML) The name of the locked relation (for DML Locks) or keys (for advisory locks) The internal state of the lock acquistion process The list of backends waiting for the same global lock The time when the global lock acquire was initiated by origin node The time when the local node started trying to acquire the local lock The time acquire_stage last changed |
| PGD Group CAMO Details | Information about CAMOs in a PGD group. The stored information includes: The name of the node The node name for whom this node is partner The node name for whom this node is origin The connection status The readiness status The number of pending or unresolved CAMO transactions The LSN of last applied WAL log The LSN of last received WAL log |
| PGD Group Replication Slot Details | Information about replication slots in a EDB Postgres Distributed group. The stored information includes: The name of the EDB Postgres Distributed group The name of the origin node The name of the target node The slot name on the origin node used by this subscription The active status The state of the replication (catchup,streaming, disconnected,..) The approximate lag time for reported write The approximate lag time for reported flush The approximate lag time for reported replay The bytes difference between sent_lsn and current WAL write position The bytes difference between write_lsn and current WAL write position The bytes difference between flush_lsn and current WAL write position |
| PGD Group Subscription Summary | Information about the summary of subscriptions in the EDB Postgres Distributed group. The stored information includes: The name of the origin of the subscription The name of the target of the subscription The timestamp of the last replayed transaction The lag between now and time of last replayed transaction |
| PGD Monitor Group Raft | The status and message of a cluster-wide raft check. |
| PGD Group Raft Details | Information about raft consensus status from all the nodes in a EDB Postgres Distributed group. The stored information includes: The name of the node The raft worker state on the node The node id of the RAFT_LEADER The raft election internal id The raft snapshot internal id |
| PGD Monitor Group Versions | The status and message of cluster-wide version check. |
| PGD Group Versions Details | Information about version details of the installed Postgres, pglogical, EDB Postgres Distributed for each node in the EDB Postgres Distributed group. The stored information includes: The name of the node The installed Postgres version on the node The installed pglogical version on the node The version of the EDB Postgres Distributed on the node The EDB Postgres Distributed edition (Standard/Enterprise) for versions earlier than 4.0. |
| PGD Node Group Config Summary | Information about group configurations including: The Group ID The group option name The current value of the group The source of the current value of the group This probe is available from version 6 and later |
| PGD Node Replication Rates | Information about outgoing replication activity from a given node. The stored information includes: The name of the target peer node The latest sent position The latest position reported as replayed The approximate lag time for reported replay The bytes difference between replay_lsn and current WAL write position on origin The human-readable bytes difference between replay_lsn and current WAL write position Approximate time required for the peer node to catch up to all the changes that are yet to be applied |
| PGD Node Roles | Information about roles of a node in a PGD cluster. Some of the possible role values are: RAFT_LEADER RAFT_FOLLOWER RAFT_CANDIDATE write leader write candidate |
| PGD Node Slots | Information about the mapping of local PGD database nodes to replication slots, their status, and replication progress. The stored information includes: The name of the slot The name of the target node The name of the PGD group The database name on the target node The PID of the process attached to the slot The catalog XID needed by the slot The IP address of the client connection The latest sent position The latest position reported as replayed The approximate lag time for reported replay The bytes difference between replay_lsn and current WAL write position The human-readable bytes difference between replay_lsn and current WAL write position |
| PGD Node Summary | Information about all the nodes in the PGD group. The stored information includes: The name of the node The name of the PGD group the node is part of The consistent state of the node in human-readable form The state which the node is trying to reach (during join or promotion) The name of subscribed repsets The universal unique ID, from verion 6 and later |
| PGD Workers | Information about workers in a EDB Postgres Distributed node. The stored information includes: The PID of the worker process The worker query start timestamp The worker state change timestamp The worker wait event type The worker wait event The worker state The worker role name The worker commit timestamp The worker local timestamp The name of the origin node The receive LSN The receive commit LSN The last exact replay LSN The last exact flush LSN The last exact replay timestamp The worker query |
| PGD Work Errors | Information about the work errors in EDB Postgres Distributed database node. The stored information includes: The process id of the worker causing the error The name of the EDB Postgres Distributed group the node is part of The name of the origin node The name of the source node The name of the target node The name of the subscription The internal identifier of the role of this worker The name of the role of this worker The date and time of the error The age of the error The description of the error The context in which the error happened The remote relation id The subscription writer id The subscription writer name |
Failover manager probes
To monitor the Failover manager information and status, you must enable the following probes:
| Probe name | Information monitored by probe | Level |
|---|---|---|
| Failover Manager Cluster Info | Monitors a Failover Manager cluster, returning information about the cluster. This probe is enabled when a cluster name and path of the Failover Manager binary is provided on the Server Properties dialog box. | Server |
| Failover Manager Node Status | Monitors a Failover Manager cluster, returning details about each node within the cluster. This probe is enabled when a cluster name and path of the Failover Manager binary is provided on the Server Properties dialog box. | Server |
Patroni probes
To monitor the Patroni cluster information and status, you must enable the following probes:
| Probe name | Information monitored by probe | Level |
|---|---|---|
| Patroni Cluster Status | Monitors a Patroni cluster, retrieving information about: The Patroni cluster name The current PostgreSQL timeline ID the cluster is operating on The primary node name The hostname or IP address of the current primary node A boolean indicator to track the DCS healthy status A boolean indicator to track the Patroni cluster's down status A boolean indicator to track the cluster's paused status | Server |
| Patroni Node Status | Monitors the nodes of a Patroni cluster, retrieving information about: The Patroni cluster name The node name The hostname or IP address of the node The current assigned role of the node. The possible values are leader, replica, or standby_leader.The status of the node. The possible values are running, streaming, starting, or stopped.The timeline the node is currently on The replication lag time in MB | Server |