Server Metrics
The Metrics tab on the Server Detail page displays real-time and recent metric panels for the selected PostgreSQL server.
{screenshot: server-metrics-tab}
Available Metric Panels
Connections
Current connection activity on the PostgreSQL instance:
| Metric | Description |
|---|---|
| Active connections | Sessions currently executing a query |
| Idle connections | Sessions connected but not executing |
| Idle in transaction | Sessions in an open transaction but not actively executing |
| Total connections | Sum of all connections |
| Max connections | max_connections parameter value |
| Connection usage % | Total connections as a percentage of max_connections |
{screenshot: connections-panel}
Database Activity
Key throughput metrics for the monitored instance (aggregated across all databases):
| Metric | Description |
|---|---|
| Transactions/sec | Rate of committed transactions |
| Reads/sec | Block read rate (heap + index) |
| Writes/sec | Block write rate |
| Rollbacks/sec | Rate of rolled-back transactions |
Database Sizes
List of all databases on the instance with their current size.
{screenshot: database-sizes-panel}
OS Metrics
System-level context collected by the agent:
| Metric | Description |
|---|---|
| CPU usage % | Overall CPU utilization |
| Memory usage % | RAM usage |
| Disk usage % | Disk utilization for the PostgreSQL data directory |
| Load average | System load average (1 min) |
Data Freshness
Metrics on this tab reflect the most recently received data from the agent. The timestamp of the last data point is displayed at the top of each panel.
- Connection metrics — updated every heartbeat (30 seconds)
- Activity metrics — updated every 60 seconds (pg_stat_database delta)
- OS metrics — updated every 60 seconds
tip
For second-by-second activity monitoring, use the ASH Viewer → which samples pg_stat_activity every 2 seconds.