When your ApsaraDB RDS for PostgreSQL instance shows signs of slowdowns or resource pressure, the Performance Trends feature in Database Autonomy Service (DAS) lets you pinpoint the bottleneck quickly. Use it to visualize metric trends over a selected time range, perform multi-dimensional comparative analysis, and view custom combinations of metrics.
Available metrics
The Dashboard organizes metrics into two categories:
| Category | What it covers | Metrics |
|---|---|---|
| Basic metrics | Host-level resource usage | CPU utilization, memory usage, available memory percentage, available memory, space utilization, data disk space usage details, space usage, network traffic, data disk IOPS |
| Database metrics | PostgreSQL engine activity | Latency, 2PC, long-running transactions, slow queries, longest bloat duration, transactions per second, rows processed, Connections |
When to use each category:
Start with Basic metrics to check whether the host is under resource pressure (CPU, memory, disk, or network saturation).
Switch to Database metrics to investigate engine-level issues such as slow queries, connection buildup, or transaction bottlenecks.
View performance trends
Go to the Instances page. In the top navigation bar, select the region where the instance resides, then click the instance ID.
In the left navigation pane, choose Autonomy Service > Dashboard.
On the Dashboard page, use the following controls to explore your metrics:
Query a time period — Select a time range to load the corresponding monitoring metrics. Historical data is available for the last 30 days.
Enable real-time mode — Click the
icon next to the time range selector. The Dashboard refreshes monitoring metrics every 5 seconds so you can observe live changes in database performance.Change data granularity — Set Data Granularity to control how finely data points are plotted: 5 seconds, 30 seconds, or 1 minute.
View metric details — In any metric trend chart, click the
icon next to a metric name to see its sub-metrics and descriptions.Compare nodes — For Cluster Edition instances, select one or more nodes to compare the same metrics side by side across nodes.
On the Dashboard page, click Previous Version in the upper-right corner to switch to the previous version of Performance Trends.
Appendix: Previous version of Performance Trends
The previous version offers three pages — Performance Trends, Performance Trend Comparison, and Custom Charts — each suited to a different analysis workflow:
| Page | Best for |
|---|---|
| Performance Trends | Viewing metric trends within a time range and correlating them with detected events |
| Performance Trend Comparison | Identifying regressions or improvements by comparing the same metrics across different time periods |
| Custom Charts | Building custom dashboards that combine multiple metrics in one view for side-by-side correlation |
To access the previous version:
Log on to the ApsaraDB RDS console and go to the Instances page. Select the region where the instance resides, then click the instance ID.
In the left navigation pane, choose Autonomy Service > Dashboard.
In the upper-right corner of the Dashboard page, click Previous Version.
Performance Trends page
View metric trends within a selected time range and correlate them with detected events.
Click More Metrics to choose which metrics to display.
Click the icon next to each metric to see its sub-metrics.
Select event levels to overlay on the charts. When an event of a selected level is detected, it appears in the CPU Utilization trend chart. Click an event marker to view its diagnostic results in the event list.
Drag across any metric chart to select a time window, then click Diagnose to run a diagnosis on that period.
Click Details in any chart to zoom in and adjust the time range for a closer look.
Performance Trend Comparison page
Compare the same metrics across different time periods to identify regressions or improvements. Click More Metrics to select the metrics to compare.
Custom Charts page
Build custom monitoring dashboards that combine multiple metrics in one view — useful when you need to correlate metrics that appear on separate charts by default.
Click Add Monitoring Dashboard, enter a Dashboard Name, and click OK.
Click Add Node and Metrics, select the target nodes and metrics, and click
.Click OK.