RDS for PostgreSQL Metrics
Description
This section describes namespaces, descriptions, and dimensions of metrics reported by RDS for PostgreSQL to Cloud Eye. You can use APIs provided by Cloud Eye to retrieve metrics and alarms generated for RDS for PostgreSQL.
Namespace
SYS.RDS
Metrics
Metric ID |
Name |
Description |
Value Range |
Monitored Object and Instance Type |
---|---|---|---|---|
rds001_cpu_util |
CPU Usage |
CPU usage of the monitored object |
0–100% |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
rds002_mem_util |
Memory Usage |
Memory usage of the monitored object |
0–100% |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
rds003_iops |
IOPS |
Average number of I/O requests processed by the system in a specified period |
≥ 0 counts/s |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
read_count_per_second |
Read IOPS |
Average number of read I/O requests processed by the system in a specified period |
≥ 0 counts/s |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
write_count_per_second |
Write IOPS |
Average number of write I/O requests processed by the system in a specified period |
≥ 0 counts/s |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
rds004_bytes_in |
Network Input Throughput |
Incoming traffic in bytes per second |
≥ 0 bytes/s |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
rds005_bytes_out |
Network Output Throughput |
Outgoing traffic in bytes per second |
≥ 0 bytes/s |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
rds039_disk_util |
Storage Space Usage |
Storage space usage of the monitored object |
0–100% |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
rds040_transaction_logs_usage |
Transaction Logs Usage |
Storage space usage of transaction logs |
≥ 0 MB |
Monitored object: database Monitored instance type: RDS for PostgreSQL instance |
rds041_replication_slot_usage |
Replication Slot Usage |
Storage space usage of replication slot files |
≥ 0 MB |
Monitored object: database Monitored instance type: RDS for PostgreSQL instance |
rds042_database_connections |
Database Connections in Use |
Number of database connections in use |
≥ 0 counts |
Monitored object: database Monitored instance type: RDS for PostgreSQL instance |
rds043_maximum_used_transaction_ids |
Maximum Used Transaction IDs |
Maximum number of transaction IDs that have been used |
≥ 0 counts |
Monitored object: database Monitored instance type: RDS for PostgreSQL instance |
rds044_transaction_logs_generations |
Transaction Logs Generation |
Size of transaction logs generated per second |
≥ 0 MB/s |
Monitored object: database Monitored instance type: RDS for PostgreSQL instance |
rds045_oldest_replication_slot_lag |
Oldest Replication Slot Lag |
Lagging size of the most lagging replica in terms of WAL data received |
≥ 0 MB |
Monitored object: database Monitored instance type: RDS for PostgreSQL instance |
rds046_replication_lag |
Replication Lag |
Replication lag |
≥ 0 ms |
Monitored object: database Monitored instance type: RDS for PostgreSQL instance |
rds047_disk_total_size |
Total Storage Space |
Total storage space of the monitored object |
40–4000, in GB |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
rds048_disk_used_size |
Used Storage Space |
Used storage space of the monitored object |
0–4000, in GB |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
rds049_disk_read_throughput |
Disk Read Throughput |
Number of bytes read from the disk per second |
≥ 0 bytes/s |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
rds050_disk_write_throughput |
Disk Write Throughput |
Number of bytes written into the disk per second |
≥ 0 bytes/s |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
ds082_tps |
TPS |
Execution times of submitted and rollback transactions per second |
≥ 0 counts/s |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
rds083_conn_usage |
Connection Usage |
Percent of used PostgreSQL connections to the total number of connections |
0–100% |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
row_per_second |
Operation Rows |
Number of rows that are being inserted, deleted, updated, or queried |
≥ 0 |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
active_connections |
Active Connections |
Number of active database connections |
≥ 0 |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
idle_transaction_connections |
Idle Transaction Connections |
Number of idle transaction connections |
≥ 0 |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
oldest_transaction_duration |
Oldest Active Transaction Duration |
Length of time since the start of the transaction that has been active longer than any other current transaction |
≥ 0 ms |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
oldest_transaction_duration_2pc |
Oldest Two-Phase Commit Transaction Duration |
Length of time since the start of the transaction that has been prepared for two-phase commit longer than any other current transaction |
≥ 0 ms |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
disk_io_usage |
Disk I/O Usage |
I/O usage of disks. The disk I/O usage is the percentage of the time that the disk processes I/O requests to the total time.
NOTE:
If the disk I/O usage reaches 100%, data is being written to the disk during the statistical period. The disk performance is determined by multiple metrics, such as IOPS, disk throughput, and read/write latency. |
0–100% |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
lock_waiting_sessions |
Sessions Waiting for Locks |
Number of blocked sessions |
≥ 0 |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
swap_in_rate |
Swap-In Rate |
Volume of data written from the swap partition to the memory per second |
≥ 0 KB/s |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
swap_out_rate |
Swap-Out Rate |
Volume of data written from the memory to the swap partition per second |
≥ 0 KB/s |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
swap_total_size |
Total Swap Size |
Total size of the swap partition |
≥ 0 MB |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
swap_usage |
Swap Usage |
Usage of the swap partition |
0–100% |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
db_max_age |
Maximum Database Age |
Maximum age of the current database, which is the value of max(age(datfrozenxid)) in the pg_database table |
≥ 0 |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
cpu_user_usage |
User-mode CPU Time Percentage |
Percentage of time that the CPU is in user mode |
0–100% |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
cpu_sys_usage |
Kernel-mode CPU Time Percentage |
Percentage of time that the CPU is in kernel mode |
0–100% |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
cpu_wait_usage |
Disk I/O Wait Time Percentage |
Percentage of time that the CPU is waiting for disk I/O operations to complete |
0–100% |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
io_read_delay |
Read I/O Latency |
Average latency (in milliseconds) of disks responding to read requests |
≥ 0 ms |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
io_write_delay |
Write I/O Latency |
Average latency (in milliseconds) of disks responding to write requests |
≥ 0 ms |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
slow_sql_one_second |
Number of SQL Statements Executed for More Than 1s |
Number of slow SQL statements whose execution time is longer than 1s |
≥ 0 |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
slow_sql_three_second |
Number of SQL Statements Executed for More Than 3s |
Number of slow SQL statements whose execution time is longer than 3s |
≥ 0 |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
slow_sql_five_second |
Number of SQL Statements Executed for More Than 5s |
Number of slow SQL statements whose execution time is longer than 5s |
≥ 0 |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
slow_sql_log_min_duration_statement |
Number of SQL Statements Executed for More Than log_min_duration_statement |
Number of slow SQL statements whose execution time is longer than the value of log_min_duration_statement. You can change the value of this metric as required. |
≥ 0 |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
pg_dr_repl_stat |
Replication Status Between Primary DB Instance and DR Instance |
Replication status between the primary DB instance and DR instance. The value ranges from 0 to 5.
|
≥ 0 counts |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
pg_dr_wal_delay |
LSN Latency Between Primary DB Instance and DR Instance |
Latency between the LSN of the primary DB instance and the replay LSN of the DR instance |
≥ 0 bytes/s |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
round_trip_time |
Network Latency Between Primary DB Instance and DR Instance |
RTT between the primary DB instance and DR instance |
≥ 0 ms |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
packet_loss_rate |
Packet Loss Rate Between Primary DB Instance and DR Instance |
Packet loss rate between the primary DB instance and DR instance |
0–100% |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
inactive_logical_replication_slot |
Inactive Logical Replication Slots |
Number of inactive logical replication slots |
≥ 0 |
Monitored object: database Monitored instance type: RDS for PostgreSQL instance |
pgaudit_log_size |
Audit Log Size |
Size of audit logs |
≥ 0 GB |
Monitored object: database Monitored instance type: RDS for PostgreSQL instance |
slave_replication_status |
Stream Replication Status of Standby Node |
Stream replication status of the standby node. The value 0 indicates abnormal stream replication; 1 indicates normal stream replication; and 2 means that this node is the primary node. For this metric, the standby node also includes read replicas. |
|
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
synchronous_replication_blocking_time |
Synchronous Replication Blocking Time |
Time during which synchronous replication between the primary and standby nodes is blocked |
≥ 0s |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
temporary_files_generation_num |
Temporary Files per Minute |
Number of temporary files generated within 1 minute |
≥ 0 counts/min |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
temporary_files_generation_size |
Temporary File Size per Minute |
Size of temporary files generated within 1 minute |
≥ 0 bytes/min |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
sent_lsn_replication_latency_size |
Size of Not Sent WAL |
Size of WAL logs that have not been sent from the primary node to the standby node |
≥ 0 bytes |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
write_lsn_replication_latency_size |
Size of Not Written WAL |
Size of WAL logs that have not been written to the disk by the standby node |
≥ 0 bytes |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
flush_lsn_replication_latency_size |
Size of Not Flushed WAL |
Size of WAL logs that have not been flushed to the disk by the standby node |
≥ 0 bytes |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
replay_lsn_replication_latency_size |
Size of Not Replayed WAL |
Size of WAL logs that have not been replayed by the standby node |
≥ 0 bytes |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
data_disk_inode_used |
Inodes |
Used data disk inodes |
≥ 0 counts |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
user_current_connections |
Connections in Use |
Number of connections in use (excluding built-in connections used for monitoring and O&M) |
≥ 0 counts |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
user_active_connections |
Active Connections of Users |
Number of active connections used by users (excluding built-in active connections used for monitoring and O&M) |
≥ 0 counts |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
wal_size |
WAL Size |
Size of WAL logs |
≥ 0 GB |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
dbuser_passwd_deadline |
The fastest expiration time for database users |
Database user password expiration time minus current time
NOTE:
If no password expiration time is set, this metric cannot be collected. |
≥ 0s |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
sys_memory_hit_rate |
Memory Hit Rate |
Memory hit rate |
≥ 0% |
Monitored object: ECS Monitored instance type: RDS for PostgreSQL instance |
Dimension
Key |
Value |
---|---|
postgresql_cluster_id |
RDS for PostgreSQL instance ID |
API Calling
Use APIs to search for RDS monitoring metrics. For details about calling methods and parameter description, see Querying Monitoring Data in the Cloud Eye API Reference.
Examples:
- Request
/V1.0/{project_id}/metric-data?namespace=SYS.RDS&metric_name=rds001_cpu_util&dim.0=rds_cluster_id,5ea170ad-cc6b-49cd-9020-e94fdbeea391&from=1484123686000&to=1568188853000&period=300&filter=average
- Response:
{ "datapoints": [ { "average": 0.35, "timestamp": 1484123400000, "unit": "Ratio" }, { "average": 0.11, "timestamp": 1484123700000, "unit": "Ratio" } ], "metric_name": "rds001_cpu_util", "httpcode" : 200, "header" : { "Transfer-Encoding" : "chunked", "Server" : "Web Server", "X-Request-Id" : "te-I-CES-APISVR25.id-0418d62a-1e76-46ff-9a5f-9ce40b336e29.ts-1484123744291.c-15046", "X-Content-Type-Options" : "nosniff", "Connection" : "keep-alive", "X-Download-Options" : "noopen", "Date" : "Wed, 11 Jan 2017 08:35:44 GMT", "X-Frame-Options" : "DENY", "Strict-Transport-Security" : "max-age=31536000; includeSubdomains;", "Cache-Control" : "no-cache", "X-XSS-Protection" : "1; mode=block;", "Content-Length" : "165", "Content-Type" : "application/json" } }
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot