Database Autonomy Service (DAS) provides the performance insight feature for ApsaraDB RDS for PostgreSQL. You can use this feature to monitor the loads, analyze the associated data, and optimize the performance of your ApsaraDB RDS for PostgreSQL instance. This feature helps you troubleshoot performance issues to increase the stability of your RDS instance.

Prerequisites

Your ApsaraDB RDS for PostgreSQL instance runs ApsaraDB RDS for PostgreSQL High-availability Edition.

Data sources

  • If performance_schema is enabled for database instances, the performance insight feature collects and analyzes the data stored in performance_schema.
  • If performance_schema is disabled for database instances, the performance insight feature collects and analyzes the data of active sessions.

Procedure

  1. Access RDS Instances, select a region at the top, and then click the ID of the target RDS instance.
  2. In the left-side navigation pane, choose Autonomy Service > Diagnostics.
  3. On the Performance Insight tab, click Enable Performance Insight. In the message that appears, click OK to enable the performance insight feature.
    Note If you no longer require the performance insight feature, you can click Disable Performance Insight on the Performance Insight tab to disable the feature.
  4. In the Performance Insight and Average Active Session sections, view the following information about the RDS instance.
    Note When you select a time range, the end time must be later than the start time.
    • Data generated in up to seven days within the last month are displayed in the Performance Insight section.
    • The information about sessions in the last three days are displayed in the Average Active Session section.
    • In the Performance Insight section, you can specify a time range to view the database performance metrics within the specified period.

      You can view details of a specific performance metric. For example, if you want to view the memory usage or CPU utilization of the database instance, click Details on the right side of Memory Usage/CPU Utilization.

      ss
    • In the Average Active Session section, you can view the trends of different types of sessions and the database workloads from multiple dimensions. This can help you identify the root causes of performance issues.

      Click Optimize in the Actions column corresponding to an SQL query. On the SQL Diagnosis Optimization page, view the corresponding SQL statement, execution plan, and diagnosis result.

      aa