[Notice] Diagnostics and optimization feature released

更新时间:
复制 MD 格式

AnalyticDB for PostgreSQL released the Diagnosis and Optimization feature on September 30, 2021. Use it to isolate slow queries, inspect execution plans, and break down your SQL workload by database, user, statement type, and execution time.

Release date

September 30, 2021

Scope

AnalyticDB for PostgreSQL V6.3.5.2 and later.

Note To check or update your instance's minor engine version, see Query the minor engine version and Upgrade the engine version.

Features

The Diagnosis and Optimization feature includes two capabilities:

View slow queries

Analyze SQL queries executed within a specific time range, review execution plan details, and identify root causes of slow SQL queries.

SQL distribution statistics

View the breakdown of SQL queries within a time range, filtered by:

  • Database

  • SQL type

  • SQL execution duration

  • User

What's next