Viewing Top SQL Statements

Scenarios

After Collect All Query Logs is enabled, you can filter, search for, and analyze SQL statements in multiple dimensions and gain a comprehensive insight into all SQL statements. Top SQL helps you locate exceptions.

Constraints

If you did not subscribe to Intelligent O&M, you can only view the data of the last hour. The data will be automatically deleted when it expires. If you have subscribed to Intelligent O&M, you can configure how long top SQL statements are kept (at most one day).

Procedure

1. Log in to the TaurusDB console.
2. Click in the upper left corner and select a region and project.
3. On the Instances page, click the instance name.
4. In the navigation pane, choose SQL Analysis and Tuning under DBA Assistant.
5. Click the Top SQL tab.
6. Click Subscribe. In the displayed dialog box, you can learn about Intelligent O&M functions and pricing.
   Figure 1 Subscribing to Intelligent O&M
   

7. View the top SQL statements of the DB instance.
   Figure 2 Viewing the top SQL statements
   
   • View execution durations of the top SQL statements in the last 1 hour, last 3 hours, last 6 hours, last 12 hours, or a custom time period (no longer 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 SQL Throttling in the Operation column to add a SQL throttling rule. For details, see Configuring SQL Throttling.
   • Select Comparison by Date and select dates and a time range to view the top SQL statements in the time range on different days.