Alibaba Cloud AnalyticDB for PostgreSQL Monitoring Integration
Site24x7 provides out-of-the-box monitoring for AnalyticDB for PostgreSQL (ADB for PostgreSQL) instances deployed in your Alibaba Cloud environment. With deep insights into CPU, memory, disk usage, query performance, and replication health, you can maintain smooth operations for complex analytics workloads. Once your Alibaba Cloud account is integrated with Site24x7, all associated ADB for PostgreSQL instances are auto-discovered and continuously monitored.
Use cases
- Capacity monitoring: Track disk, IOPS, and memory usage to avoid performance bottlenecks.
- Query optimization: Monitor blocked and queued queries to identify workload delays.
- Replication visibility: Measure synchronization latency to maintain data consistency.
- Connection management: Gain insights into active, idle, and segment-level connections.
- Health tracking: Monitor unhealthy counts for master and segment nodes to detect failures.
- Operational insights: Track ACU usage and materialized view update latency for real-time analytics.
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 AnalyticDB for PostgreSQL from the Service Types list.
- Once added, go to Cloud > Alibaba > AnalyticDB for PostgreSQL to view dashboards and performance metrics.
Supported metrics
Capacity & Utilization
| Metric name | Description | Unit |
|---|---|---|
| Disk Usage | The overall disk utilization of the instance. | Percentage |
| ADBPG Instance Disk Used MB | The total disk space used by the instance. | Bytes |
| ADBPG Instance Disk Usage Percent | The percentage of disk used by the instance. | Percentage |
| Node Disk Used Percent | The percentage of disk usage at the node level. | Percentage |
| Node Segment Workfile Used MB | The amount of disk space used by segment work files. | Bytes |
| Memory Usage | The overall memory utilization of the instance. | Percentage |
| Node Memory Used Percent | The percentage of memory used at the node level. | Percentage |
CPU & IOPS
| Metric name | Description | Unit |
|---|---|---|
| CPU Usage | The overall CPU utilization of the instance. | Percentage |
| Node CPU Used Percent | The percentage of CPU used at the node level. | Percentage |
| IOPS Usage | The overall IOPS utilization of the instance. | Percentage |
| Node Disk IOPS | The number of I/O operations per second at the node level. | Count |
| Node Disk IOPS Percent | The percentage of IOPS usage at the node level. | Percentage |
Connection & Workload
| Metric name | Description | Unit |
|---|---|---|
| ADBPG Connection Count | The total number of connections to the instance. | Count |
| ADBPG Connection Idle | The number of idle connections in the instance. | Count |
| ADBPG Master Connection Percent | The percentage of connections used by the master node. | Percentage |
| Connection Usage | The percentage of connection utilization. | Percentage |
| Node Segment Connection Count | The number of active connections to segment nodes. | Count |
Health & Specialized Metrics
| Metric name | Description | Unit |
|---|---|---|
| ADBPG Master Count Unhealthy | The number of unhealthy master nodes. | Count |
| ADBPG Segment Count Unhealthy | The number of unhealthy segment nodes. | Count |
| ADBPG ACU Daily Usage | The daily AnalyticDB compute unit (ACU) usage. | Count |
| ADBPG ACU Used | The total number of ACUs currently used. | Count |
| ADBPG Realtime MV Max Update Latency | The maximum update latency of real-time materialized views. | Milliseconds |
| ADBPG Realtime MV Update Failed Count | The number of failed materialized view updates. | Count |
Threshold configuration
- Go to Admin > Configuration Profiles > Threshold and Availability.
- Create or edit a threshold profile for AnalyticDB 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 AnalyticDB for PostgreSQL monitors are added.
How to add a Configuration Rule