Alibaba Cloud PolarDB for PostgreSQL Monitoring Integration
Site24x7 provides comprehensive monitoring for Alibaba Cloud PolarDB for PostgreSQL, giving detailed insights into compute, memory, I/O throughput, session activity, and transaction performance. After integrating your Alibaba Cloud account with Site24x7, all PolarDB for PostgreSQL instances are automatically discovered and monitored.
Use cases
- Resource optimization: Monitor CPU, memory, and I/O utilization to prevent resource bottlenecks.
- Performance monitoring: Track TPS, QPS, slow queries, and long-running transactions to optimize workloads.
- Connection management: Analyze active, idle, and total connections to prevent session saturation.
- Replication and latency insights: Detect replication lag and transaction delays to ensure data consistency.
- Automation and alerts: Configure thresholds and IT automation for proactive remediation.
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 PolarDB for PostgreSQL from the Service Types list.
- Once added, go to Cloud > Alibaba > PolarDB for PostgreSQL to view dashboards and performance metrics.
Supported metrics
Compute & Memory
| Metric name | Description | Unit |
|---|---|---|
| Cluster CPU Utilization | The percentage of CPU utilization across the cluster. | Percentage |
| Cluster Memory Utilization | The percentage of memory used by the cluster. | Percentage |
| Total CPU Usage | Total CPU usage of the cluster. | Percentage |
| Memory Usage | Total memory usage of the cluster. | Percentage |
| Cluster PCU by CPU Cores | CPU usage per CPU core in the cluster. | Percentage |
| Cluster Proxy CPU Utilization | The CPU utilization of the cluster proxy layer. | Percentage |
Disk & I/O
| Metric name | Description | Unit |
|---|---|---|
| Cluster IOPS | The total number of I/O operations per second on the cluster. | Count/second |
| Cluster IOPS Usage | The percentage of IOPS utilization. | Percentage |
| Cluster Disk Utilization | Disk space utilization across cluster nodes. | Percentage |
| Cluster Data IOPS | IOPS specifically used for data reads/writes. | Count/second |
| Cluster Redo Write Rate | Rate of redo log writes in the cluster. | Bytes/second |
| Cluster Input Traffic | Inbound network traffic to the cluster. | Bytes/second |
| Cluster Output Traffic | Outbound network traffic from the cluster. | Bytes/second |
Connection & Session Utilization
| Metric name | Description | Unit |
|---|---|---|
| Total Connections | Total number of connections to the cluster. | Count |
| Active Connections | The number of currently active connections. | Count |
| Idle Connections | The number of idle connections in the cluster. | Count |
| Cluster Connection Utilization | Percentage of connection utilization across the cluster. | Percentage |
| Cluster Active Sessions | The number of active sessions on cluster nodes. | Count |
Throughput & Performance
| Metric name | Description | Unit |
|---|---|---|
| Cluster TPS | Transactions processed per second in the cluster. | Count/second |
| Cluster QPS | Queries executed per second in the cluster. | Count/second |
| TPS | Transaction rate for the cluster. | Count/second |
| Cluster Memory Hit Ratio | The memory hit ratio of the cluster. | Percentage |
Latency
| Metric name | Description | Unit |
|---|---|---|
| Swell Time | Time taken by queries experiencing execution delay. | Milliseconds |
| SQLs Executing > 5s | The number of queries executing longer than 5 seconds. | Count |
| SQLs Executing > 3s | The number of queries executing longer than 3 seconds. | Count |
| SQLs Executing > 1s | The number of queries executing longer than 1 second. | Count |
PostgreSQL Operations
| Metric name | Description | Unit |
|---|---|---|
| PostgreSQL Active Connections | The number of active connections in the cluster. | Count |
| PostgreSQL Connection Usage | The percentage of connection utilization. | Percentage |
| PostgreSQL TPS | The number of transactions processed per second. | Count/second |
| Transactions > 1s | The number of transactions taking longer than 1 second. | Count |
| Transactions > 3s | The number of transactions taking longer than 3 seconds. | Count |
| PostgreSQL Rollback Ratio | The percentage of rolled-back transactions to total transactions. | Percentage |
| PostgreSQL PLS IOPS Read | The number of I/O read operations performed by PostgreSQL. | Count/second |
| PostgreSQL PLS IOPS Write | The number of I/O write operations performed by PostgreSQL. | Count/second |
| PostgreSQL PLS WAL Directory Size | The total size of WAL files in the cluster. | Bytes |
| PostgreSQL Blocks Read Delta | The number of blocks read from disk during queries. | Count |
| PostgreSQL Memory Usage | The total memory used by PostgreSQL processes. | Bytes |
| PostgreSQL Swell Time | The total execution delay caused by query swell. | Milliseconds |
Threshold configuration
- Go to Admin > Configuration Profiles > Threshold and Availability.
- Create or edit a threshold profile for PolarDB 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 PolarDB for PostgreSQL monitors are added.
How to add a Configuration Rule