How to Monitor RDS PostgreSQL in Huawei Cloud
Site24x7 monitors RDS PostgreSQL environment in Huawei Cloud, with insights into CPU, memory, disk I/O, connections, replication lag, and query performance. These insights can help you to detect bottlenecks early and ensure reliable database operations.
Use cases
Replication safety: Mitigate failover risks by monitoring replication lag and slot growth. This ensures that standby nodes remain in sync and prevents Write-Ahead Logging (WAL) buildup.
TXID protection: Prevent unexpected shutdowns by overseeing transaction ID usage and implementing timely VACUUM operations before key limits are reached.
Query performance: Decrease latency by tracking slow queries and overall throughput. This helps identify inefficient queries before they negatively affect users.
Setup and configuration
RDS PostgreSQL resources are auto-discovered and monitored during the Huawei Cloud integration. To enable monitoring, follow the steps below:
- Navigate to Cloud > Huawei > Add Huawei Monitor. Follow the steps to add a Huawei Cloud monitor.
- While adding or editing a Huawei Cloud monitor, select RDS PostgreSQL from the Service/Resource Types drop-down and click Save.
- Navigate to Cloud > Huawei, select the created Huawei monitor, and click RDS PostgreSQL to view the performance metrics.
Supported metrics
CPU and Memory
Metric name | Description | Units |
| CPU Utilization | The percentage of CPU capacity currently consumed by the RDS PostgreSQL instance. | Percentage |
| Memory Utilization | The percentage of memory capacity currently consumed by the RDS PostgreSQL instance. | Percentage |
| Swap Usage | The percentage of swap space currently consumed by the instance. | Percentage |
Network
Metric name | Description | Units |
| Network Input Throughput | The rate of data received by the instance over the network per second. | Byte/second |
| Network Output Throughput | The rate of data transmitted out of the instance over the network per second. | Byte/second |
Connections
Metric name | Description | Units |
| Database Connections | The total number of connections currently established to the PostgreSQL instance. | Count |
| Active Connections | The number of connections currently executing a query or operation. | Count |
| Connection Usage | The percentage of available connection capacity currently in use. | Percentage |
Queries and Transactions
Metric name | Description | Units |
| Queries Per Second | The rate of query statements executed on the instance per second. | Count/second |
| Transactions Per Second | The rate of transactions committed on the instance per second. | Count/second |
| Maximum Used Transaction IDs | The maximum number of transaction IDs currently consumed, indicating wraparound risk. | Count |
| Slow SQL (1 Second) | The number of SQL statements that exceeded 1 second execution time. | Count |
Replication
Metric name | Description | Units |
| Replication Lag | The delay between the primary and standby node in applying replication data. | Millisecond |
| Oldest Replication Slot Lag | The amount of WAL data retained for the oldest replication slot. | MB |
| Transaction Logs Usage | The total size of transaction logs currently consumed on the instance. | MB |
| Transaction Logs Generation Rate | The rate at which new transaction logs are being generated per second. | MB/second |
| WAL Size | The total size of Write-Ahead Log data currently stored on the instance. | GB |
Disk and I/O
Metric name | Description | Units |
| IOPS | The number of read and write I/O operations processed by the disk per second. | Count |
| Disk Utilization | The percentage of total disk storage currently consumed by the instance. | Percentage |
| Disk Total Size | The total disk storage capacity provisioned for the instance. | GB |
| Disk Used Size | The total disk storage currently consumed by the instance. | GB |
| Disk Read Throughput | The rate of data read from disk per second. | Byte/second |
| Disk Write Throughput | The rate of data written to disk per second. | Byte/second |
| Disk I/O Usage | The percentage of disk I/O capacity currently in use. | Percentage |
Threshold configuration
You can configure thresholds and alerts for all RDS PostgreSQL metrics to proactively detect performance degradation or connection issues.
- Go to Admin > Configuration Profiles > Threshold and Availability.
- Create or edit your Threshold Profile for RDS PostgreSQL.
- Assign the profile to the respective monitors to trigger alerts.
IT Automation
Use Site24x7's IT Automation to resolve common issues with RDS PostgreSQL performance:
- Go to Admin > IT Automation Templates. Then, click Add Automation Templates.
- Create an automation rule by selecting the automation Type (e.g., Server reboot, clear queue).
- Map the created rules to the RDS PostgreSQL, for automatic execution during alerts.
Configuration rules
Use Configuration Rules to simplify bulk setup across RDS PostgreSQL instances. Automatically assign Threshold Profiles, Notification Profiles, Tags, and Monitor Groups when new monitors are discovered.