- Go to
Observability → Metrics and select the resources you would like to review.
- Go to the page of the cluster you would like to review and switch to the Metrics tab.
Dashboard filters
Select a group:pgbouncerto monitor the connection pool.postgresto monitor the database operations.
Cluster monitoring metrics
Resource usage
- Total service CPU usage Amount of vCPU that a cluster consumed.
- Total service memory usage Amount of consumed RAM in GiB, with work memory and cache.
- Total disk IO usage Disk read/write rate, in bytes per second.
- Total service network usage Network receive/transmit rate, in bytes per second.
- Total service disk usage Percentage of consumed storage.
- Last base backup Time since the last successful backup.
- CPU usage Amount of vCPU consumed per container, including the limit.
- Throttling containers in % Percentage of CPU periods containers went throttling.
- Throttling containers in seconds Percentage of CPU seconds containers went throttling.
- Memory usage Amount of memory that containers used in a dedicated period, including work memory and cache. Measured in bytes.
- Network RX/TX Average speed of data received/sent over the network per container, in bytes per second.
- Disk IO Average IOPS of the cluster’s disks per container, in operations per second.
- Disk used space Amount of disk space consumed per container, including the limit.
- Disk inodes used Number of used inodes with files metadata per container, including the limit. A lack of inodes leads to an overall lack of disk space, especially if you generate many small files like Write-Ahead Log (WAL) segments or temporary tablespaces.
Replication
- Current instance roles Roles that hosts in a cluster are performing now: primary (handling read/write operations) or replica (replicating data and serving read-only queries).
- Instance roles Roles that hosts in a cluster performed during the dedicated period.
- Instance status Hosts statuses during the dedicated period: up or down.
- Replication lag Delay between the primary database and its replicas, in seconds.
- WAL size Size of WAL files in bytes per host.
- WAL count Number of WAL files per host.
- WAL archiver Number of archieved WAL files per host.
Database performance
- Database size Amount of disk space that a database consumed.
- Transaction rate Number of transactions committed or rolled back from each host per second.
- Longest transaction A pair of committed and rolled-back transactions that took the longest to complete for each host.
Connection pooler
- Pooler query rate Number of queries passed through the pooler to the server per second.
- Pooler query duration Time used to process queries through the pooler.
- Pooler servers used Number of used server (pooler to PostgreSQL) connections.
- Pooler clients used Number of used client (client to pooler) connections.
- Pooler clients active Number of clients that are assigned a server connection and can process queries.
- Pooler clients waiting Number of clients that have sent queries but are not yet assigned a server connection.
Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada, and used with their permission.