View the performance trends of an ApsaraDB RDS for PostgreSQL instance-ApsaraDB RDS(RDS)-阿里云帮助中心

Database Autonomy Service (DAS) provides the Performance Trends feature for ApsaraDB RDS for PostgreSQL. This feature lets you query metrics over a specified time range, compare them across multiple dimensions, and view custom combinations of metrics.

Introduction

In Performance Trends, you can view the following metrics:

Metric category	Metric
Basic metrics	CPU utilization, memory usage, available memory percentage, available memory, space utilization, disk space usage details, space usage, network traffic, and data disk IOPS.
Database metrics	latency, 2PC, long-running transactions, slow queries, bloat points, transactions per second, rows processed, and connections.

Performance trends

Go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the ID of the instance.
In the navigation pane on the left, choose Autonomy Services > Dashboard.
On the Dashboard page, perform the following operations:
- Query metrics for a specific time range
  
  Select a time range within the last 30 days to view the corresponding monitoring metrics.
  
  In the time range selector, click Quick Selections to choose a preset time range, or customize the start and end times.
- Enable real-time mode
  
  Click the icon next to the time selector to enable real-time mode. In this mode, the system automatically refreshes monitoring metrics every 5 seconds to show real-time changes in database performance.
- Change the data granularity
  
  Set data granularity to view metric trends at different time granularities, such as 5 seconds, 30 seconds, or 1 minute.
- View monitoring metric descriptions
  
  In a metric trend chart, click the icon next to a metric to view its sub-metrics and their descriptions.
- Switch nodes
  
  For Cluster Edition ApsaraDB RDS for PostgreSQL instances, you can select one or more nodes to view and compare their metrics.
Note
Click the Back to Old Version button in the upper-right corner of the Dashboard page to return to the Previous Version of Performance Trends.

Appendix: Previous version of performance trends

Log on to the ApsaraDB RDS console and go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the instance ID.
In the navigation pane on the left, choose Autonomy Services > Dashboard.
In the upper-right corner of the Dashboard page, click Back to Old Version.
- On the Performance Trends page, view the performance trends of various metrics within the selected time range.
  - Click More Metrics to select which metrics to view.
    
    Note
    Click the icon next to each monitoring item to view its sub-metrics.
  - Select the event levels that you want to display. When the system detects a corresponding event, it appears in the CPU Utilization trend chart.
    
    Click an event in the trend chart to view its details and diagnostic results in the event list.
  - In any metric trend chart, drag to select a time period, and then click Diagnose.
  - Click Details in a metric trend chart to zoom in on the chart. You can also change the time range to view the trend of the metric over different periods.
- On the Performance Trend Comparison page, compare the performance trends of the same metrics across different time periods.
  
  Click More Metrics to select the metrics to compare.
- On the Custom Charts page, you can create custom performance dashboards. Displaying multiple monitoring metrics in a single chart simplifies troubleshooting and analysis.
  1. Click Add Monitoring Dashboard, enter a Dashboard Name, and then click OK.
  2. Click Add Node and Metrics, select the target nodes and metrics, and then click .
  3. Click OK.