Help Center/ Relational Database Service/ User Guide/ Working with RDS for MySQL/ Problem Diagnosis and SQL Analysis/ SQL Analysis/ Viewing Top SQL Statements of a DB Instance
Updated on 2025-11-26 GMT+08:00
View PDF

Viewing Top SQL Statements of a DB Instance

Scenarios

Top SQL shows the SQL queries that have been contributing the most to DB load. You can sort them by multiple dimensions.

Procedure

  1. Log in to the management console.
  2. Click in the upper left corner of the page and choose Databases > Relational Database Service.
  3. On the Instances page, click the target instance name to go to the Summary page.
  4. In the navigation pane, choose DBA Assistant > Historical Diagnosis. Then, click the SQL Explore tab.
  5. Click the Top SQL tab.

    This function is only available with Advanced DBA Assistant.

  6. View execution durations of the top SQL statements in the last 1 hour, last 3 hours, last 12 hours, or a custom time period (spanning no more than one day).

Parent Topic: SQL Analysis