This topic describes the metrics of PolarDB for PostgreSQL or Oracle.
When you call an API operation provided by Cloud Monitor, you may need to set the Namespace and Period parameters. Set the parameters for the current service in the following way:
- Set the Namespace parameter to acs_polardb.
- Set the Period parameter to an integral multiple of 60s. The default value is 60s.
The following table describes the valid values of the MetricName and Dimensions parameters for the current service.
Metric | Unit | Metric | Dimensions | Statistics |
---|---|---|---|---|
Active Connection | Count | active_connections | userId, clusterId, and instanceId | Average |
BlockRead | Count | blks_read_delta | userId, clusterId, and instanceId | Value |
Connection Usage | % | conn_usage | userId, clusterId, and instanceId | Average |
CPU Usage | % | cpu_total | userId, clusterId, and instanceId | Average |
DB Age | xids | db_age | userId, clusterId, and instanceId | Average |
Memory Usage | % | mem_usage | userId, clusterId, and instanceId | Average |
Data Size | Mbyte | pls_data_size | userId, clusterId, and instanceId | Value |
IOPS | Frequency | pls_iops | userId, clusterId, and instanceId | Average |
Read IOPS | Frequency | pls_iops_read | userId, clusterId, and instanceId | Average |
Write IOPS | Frequency | pls_iops_write | userId, clusterId, and instanceId | Average |
WAL Log Size | Mbyte | pls_pg_wal_dir_size | userId, clusterId, and instanceId | Value |
IO Throughout | Mbyte/s | pls_throughput | userId, clusterId, and instanceId | Average |
Read IO Throughput | Mbyte/s | pls_throughput_read | userId, clusterId, and instanceId | Average |
Write IO Throughput | Mbyte/s | pls_throughput_write | userId, clusterId, and instanceId | Average |
Swell Time | s | swell_time | userId, clusterId, and instanceId | Average |
TPS | Frequency | tps | userId, clusterId, and instanceId | Average |
Rollback Ratio | % | rollback_ratio | userId, clusterId, and instanceId | userId, clusterId, and instanceId |