Help Center/
Relational Database Service_RDS for MySQL/
User Guide/
Problem Diagnosis and SQL Analysis/
SQL Analysis/
Viewing Top SQL Statements of a DB Instance
Updated on 2025-08-20 GMT+08:00
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
- Click
in the upper left corner and select a region.
- Click
in the upper left corner of the page and choose Databases > Relational Database Service.
- On the Instances page, click the target instance name.
- In the navigation pane, choose DBA Assistant > Historical Diagnosis.
- Choose SQL Explorer > Top SQL.
Top SQL needs to be purchased separately. To use this function, subscribe to Intelligent O&M first.
- Click Subscribe. In the displayed dialog box, learn about Intelligent O&M functions and pricing.
- After subscribing to Intelligent O&M, view top SQL statements of your instance.
- 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).
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbot