The page has been translated by Gen AI.
Monitoring Metrics
PostgreSQL(DBaaS) Monitoring Metrics
The following table shows the performance monitoring metrics of PostgreSQL(DBaaS) that can be checked through Cloud Monitoring. For detailed instructions on using Cloud Monitoring, refer to the Cloud Monitoring guide.
For server monitoring metrics of PostgreSQL(DBaaS), refer to the Virtual Server Monitoring Metrics guide.
| Performance Item | Detailed Description | Unit |
|---|---|---|
| Active Locks | Number of Active Locks | cnt |
| Active Locks [Access Exclusive] | Number of Access Exclusive Locks | cnt |
| Active Locks [Access Share] | Number of Access Share Locks | cnt |
| Active Locks [Total] | Total Number of Active Locks | cnt |
| Active Sessions | Number of Active Sessions | cnt |
| Active Sessions [Total] | Total Number of Active Sessions | cnt |
| Apply Lag Time | Apply Lag Time | min |
| Check No Replication | Check No Replication Value | cnt |
| Check Replication | Check Replication Status Value | status |
| Connection Usage | DB Connection Usage Rate (%) | % |
| Connection Usage [Total] | DB Connection Usage Rate (%) | % |
| DB Age Max | Database Age (Frozen XID) Value | age |
| Exclusive Locks | Number of Exclusive Locks | cnt |
| Idle In Transaction Sessions | Number of Idle In Transaction Sessions | cnt |
| Idle In Transaction Sessions [Total] | Total Number of Idle In Transaction Sessions | cnt |
| Idle Sessions | Number of Idle Sessions | cnt |
| Idle Sessions [Total] | Total Number of Idle Sessions | cnt |
| Row Exclusive Locks | Number of Row Exclusive Locks | cnt |
| Row Share Locks | Number of Row Share Locks | cnt |
| Share Locks | Number of Share Locks | cnt |
| Share Row Exclusive Locks | Number of Share Row Exclusive Locks | cnt |
| Share Update Exclusive Locks | Number of Share Update Exclusive Locks | cnt |
| Slowqueries | Number of Long-Running SQL Queries (over 5 minutes) | cnt |
| Tablespace Used | Table Space Size | bytes |
| Tablespace Used [Total] | Table Space Size | bytes |
| Tablespace Used Bytes [MB] | File System Directory Usage (MB) | MB |
| Tablespaces [Total] | File System Directory Usage (MB) | MB |
| Transaction Time Max [Long] | Longest Running Transaction Time (minutes) | min |
| Transaction Time Max Total [Long] | Longest Running Transaction Time (minutes) | min |
| Wait Locks | Number of Sessions Waiting for Locks (per DB) | cnt |
| Wait Locks [Long Total] | Number of Sessions Waiting for Locks for a Long Time (over 300 seconds) | cnt |
| Wait Locks [Long] | Number of Sessions Waiting for Locks | cnt |
| Wait Locks [Total] | Total Number of Sessions Waiting for Locks | cnt |
| Waiting Sessions | Number of Waiting Sessions | cnt |
| Waiting Sessions [Total] | Total Number of Waiting Sessions | cnt |
Table. PostgreSQL(DBaaS) Monitoring Metrics