AnalyticDB for PostgreSQL released the diagnostics and optimization feature on September 30, 2021. This feature allows you to view slow SQL queries and SQL distribution statistics in the console.
September 30, 2021
AnalyticDB for PostgreSQL V184.108.40.206 instances and later.
AnalyticDB for PostgreSQL provides the Diagnosis and Optimization feature to allow the following operations:
- View slow queries
You can analyze SQL queries executed within a specific time range, view execution plan details, and identify root causes of slow SQL queries.
- SQL distribution statistics
You can view the proportions of SQL queries by using dimensions such as databases, SQL types, SQL execution durations, and users within a specific time range.