Top Statements

Scenarios

Top Statements shows the top SQL statements by resource overhead, helping you identify performance problems and optimize SQL statements.

To use the Top Statements function, contact customer service.

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 and choose Databases > Relational Database Service.
4. On the Instances page, click the DB instance name.
5. In the navigation pane, choose DBA Assistant > Real-Time Diagnosis.
6. On the Top Statements tab page, view the top SQL statements by CPU overhead, execution duration, rows returned, and logical reads.
   Figure 1 Top Statements
   
   • To export details about top SQL statements, click .
   • To sort parameter values in the top SQL details, click in the table header.