PolarDB for PostgreSQL provides the diagnostics feature that integrates some features of Database Autonomy Service (DAS). You can use the performance insight feature to rapidly evaluate the workloads on databases and identify the root causes of performance issues. This helps you improve the stability of your databases.
Background information
The performance insight feature collects and analyzes data from the following major sources:
If performance_schema is enabled for instances, the performance insight feature collects and analyzes the data stored in performance_schema.
If performance_schema is disabled for instances, the performance insight feature collects and analyzes the data of active sessions.
Procedure
Log on to the PolarDB console.
In the upper-left corner of the PolarDB console, select the region in which the desired cluster is deployed.
On the Clusters page, click the ID of the cluster that you want to manage.
In the left-side navigation pane, choose .
Click the Performance Insight tab.
Click Enable Performance Insight.
In the dialog box that appears, click Confirm.
On the Performance Insight tab, view and manage the performance information.
In the Performance Insight section, you can specify a time range to view the performance metrics within the specified period. If you want to view the details of a specific performance metric such as CPU utilization, click Details in the upper-right corner of the performance metric section.
NoteYou can view the data of a metric only within the latest seven days.
In the Average Active Session section, you can view the trends of different types of sessions, such as sessions that are created to execute SQL statements. You can also view the database workloads from multiple dimensions. This helps you identify the root causes of performance issues.