Top SQL

Scenarios

After Collect All SQL Statements is enabled, you can gain a comprehensive insight into SQL statements on the SQL Explorer page. Top SQL helps you locate exceptions.

Procedure

1. Log in to the management console.
2. Click in the upper left corner and select a region and a project.
3. Click in the upper left corner of the page, choose Database > GaussDB(for MySQL).
4. On the Instances page, click the instance name.
5. In the navigation pane, choose DBA Assistant > Historical Diagnosis.
6. Choose SQL Explorer > Top SQL.
7. View execution durations of the top SQL statements in the last 1 hour, last 3 hours, last 6 hours, or a custom time period (spanning no more than one day).
   • Click a point in time or drag to select a time period to view the SQL statistics of a SQL template.
   • Click to export information about all top SQL templates in the list. To use this export function, subscribe to Intelligent O&M.
   • Locate a SQL template and click Details to view the total execution times, average rows scanned, average execution duration, and the like.
   • Locate a SQL template and click Concurrency Control in the Operation column. For details, see Concurrency Control.