Alibaba Cloud RDS for PostgreSQL Monitoring Integration
Site24x7 offers comprehensive monitoring for Alibaba Cloud RDS for PostgreSQL, enabling complete visibility into system performance, resource consumption, and replication health. With detailed insights into CPU utilization, I/O throughput, transaction trends, and buffer usage, you can detect bottlenecks early, optimize query performance, and maintain database stability. When you integrate your Alibaba Cloud account with Site24x7, all RDS for PostgreSQL instances are automatically discovered and monitored.
Use cases
- Performance analysis: Track CPU, I/O, and memory usage to detect overloaded processes and optimize performance.
- Replication monitoring: Identify replication delays and replay latency to maintain data consistency.
- Connection visibility: Monitor active, idle, and waiting connections to avoid saturation.
- Buffer and cache optimization: Analyze shared buffer hit rates and cache performance to fine-tune PostgreSQL configurations.
- Automation and alerts: Create threshold-based alerts and automate recovery to reduce downtime.
Setup and configuration
- Log in to your Site24x7 account and navigate to Cloud > Alibaba Cloud > Add Monitor.
- In the Edit Alibaba Cloud Monitor page, select RDS for PostgreSQL from the Service Types list.
- Once added, go to Cloud > Alibaba > RDS for PostgreSQL to view dashboards and performance metrics.
Supported metrics
CPU Utilization
| Metric name | Description | Unit |
|---|---|---|
| PostgreSQL System CPU Usage | The percentage of CPU utilized by system-level processes. | Percentage |
| PostgreSQL User CPU Usage | The percentage of CPU used by user-level PostgreSQL processes. | Percentage |
| PostgreSQL Postmaster CPU Usage | The percentage of CPU utilization by the PostgreSQL postmaster process. | Percentage |
| PostgreSQL Backend CPU Usage | The percentage of CPU used by backend worker processes. | Percentage |
| PostgreSQL BGWriter CPU Usage | The percentage of CPU utilization by the background writer process. | Percentage |
| PostgreSQL Checkpoint CPU Usage | The percentage of CPU consumed during checkpoint operations. | Percentage |
| PostgreSQL Autovacuum CPU Usage | The percentage of CPU utilized by autovacuum workers. | Percentage |
| PostgreSQL Logger CPU Usage | The percentage of CPU consumed by the PostgreSQL logger process. | Percentage |
| PostgreSQL WAL Writer CPU Usage | The percentage of CPU usage by the WAL writer process. | Percentage |
| PostgreSQL WAL Sender CPU Usage | The percentage of CPU used by WAL sender processes. | Percentage |
| PostgreSQL Proxy CPU Utilization | The total CPU utilization percentage of the PostgreSQL proxy layer. | Percentage |
I/O Throughput
| Metric name | Description | Unit |
|---|---|---|
| PostgreSQL BGWorker IO Throughput | The I/O throughput generated by background worker processes. | Bytes/second |
| PostgreSQL Checkpoint IO Throughput | The I/O throughput during checkpoint operations. | Bytes/second |
| PostgreSQL BGWriter IO Throughput | The I/O throughput from background writer activities. | Bytes/second |
| PostgreSQL Startup IO Throughput | The I/O throughput during database startup. | Bytes/second |
| PostgreSQL Logger IO Throughput | The I/O throughput from logging operations. | Bytes/second |
| PostgreSQL WAL Sender IO Throughput | The I/O throughput from WAL sender processes. | Bytes/second |
| PostgreSQL WAL Writer IO Throughput | The I/O throughput generated by the WAL writer process. | Bytes/second |
| PostgreSQL WAL Receiver IO Throughput | The I/O throughput handled by the WAL receiver process. | Bytes/second |
| PostgreSQL Autovacuum IO Throughput | The I/O throughput from autovacuum activities. | Bytes/second |
| PostgreSQL PGStat IO Throughput | The I/O throughput of the statistics collector process. | Bytes/second |
| PostgreSQL Local IO Throughput | The total local disk I/O throughput. | Bytes/second |
| PostgreSQL Local IO Throughput Read | The local disk read throughput. | Bytes/second |
| PostgreSQL Local IO Throughput Write | The local disk write throughput. | Bytes/second |
Buffer & Cache
| Metric name | Description | Unit |
|---|---|---|
| PostgreSQL Shared Buffer Usage | The percentage of shared buffer memory currently in use. | Percentage |
| PostgreSQL Shared Buffer Hit Count | The number of hits recorded in the shared buffer cache. | Count |
| PostgreSQL Shared Buffer Hit Rate | The percentage of successful buffer hits compared to total lookups. | Percentage |
| PostgreSQL Blocks Read | The number of disk blocks read by PostgreSQL. | Count |
Transaction & Execution
| Metric name | Description | Unit |
|---|---|---|
| PostgreSQL Transaction Commits | The number of transactions successfully committed. | Count |
| PostgreSQL Transaction Rollbacks | The number of transactions rolled back. | Count |
| PostgreSQL Max Executing SQL Time | The maximum execution time of currently running SQL queries. | Milliseconds |
| PostgreSQL Database Age | The age of the oldest transaction in the database. | Count |
WAL & Checkpoint
| Metric name | Description | Unit |
|---|---|---|
| PostgreSQL Max Slot WAL Delay | The maximum replication delay observed in WAL slots. | Milliseconds |
| PostgreSQL Local WAL Directory Size | The total size of the local WAL directory. | Bytes |
Network & Replication
| Metric name | Description | Unit |
|---|---|---|
| PostgreSQL Network RX | The amount of inbound network traffic received by the database. | Bytes/second |
| PostgreSQL Network TX | The amount of outbound network traffic transmitted from the database. | Bytes/second |
| PostgreSQL RO Streaming Status | The replication streaming status for read-only replicas. | Status |
| PostgreSQL RO Read Lag | The read delay between the primary and read-only replicas. | Milliseconds |
| PostgreSQL Replay Latency | The latency between WAL replay and current transaction processing. | Milliseconds |
Connections
| Metric name | Description | Unit |
|---|---|---|
| PostgreSQL Active Connections | The number of active connections currently executing queries. | Count |
| PostgreSQL Idle Connections | The number of idle connections waiting for new tasks. | Count |
| PostgreSQL Waiting Connections | The number of connections waiting for resources or locks. | Count |
| PostgreSQL Total Connections | The total number of database connections (active + idle + waiting). | Count |
Other Metrics
| Metric name | Description | Unit |
|---|---|---|
| PostgreSQL Swell Time | The total time the database experienced memory pressure or performance swell. | Milliseconds |
| PostgreSQL Temp File Bytes | The total size of temporary files created during query execution. | Bytes |
Threshold configuration
- Go to Admin > Configuration Profiles > Threshold and Availability.
- Create or edit a threshold profile for RDS for PostgreSQL.
- Assign the profile to the respective monitors to trigger alerts.
IT automation
Site24x7's IT Automation tools help with automatically resolving performance degradation issues. When a breach occurs, the alarm engine continuously examines the system events for which thresholds have been defined and performs the mapped automation.
- Go to Admin > IT Automation Templates.
- Create a new automation rule.
- Map the rule to the monitor for proactive resolution.
How to configure IT Automation for a monitor
Configuration rules
With Site24x7's Configuration Rules, you can set parameters like Threshold Profile, Notification Profile, Tags, and Monitor Group for multiple monitors and automate the configuration settings of your monitoring resources. Automatically assign these settings when new RDS for PostgreSQL monitors are added.
How to add a Configuration Rule