Viewing Slow Query Logs of a DB Instance

Scenarios

Slow Query Log displays a chart of SQL statements that are taking too long to execute and allows you to sort slow SQL statements by multiple dimensions, such as by user, client IP address, or SQL template. It helps you quickly identify bottlenecks and improve instance performance.

Procedure

1. Log in to the RDS console.
2. Click in the upper left corner and select a region.
3. On the Instances page, click the target instance name to go to the Summary page.
4. In the navigation pane, choose SQL Analysis and Tuning under DBA Assistant.
5. Click the Slow Query Logs tab.
   

   Slow Query Logs needs to be purchased separately. To use this function, subscribe to Intelligent O&M first.

6. Click Upgrade DBA Assistant. In the displayed dialog box, you can learn about the enhanced features and billing rules.
   Figure 1 Upgrading DBA Assistant
   

7. After the upgrade is complete, view slow queries over time of your instance.
8. Check slow queries over time and archived slow query logs in the last 1 hour, last 3 hours, last 12 hours, or a custom time period (spanning no more than one day).
   Figure 2 Viewing slow queries over time
   

9. View slow query log details and template statistics.
   • To export slow query log information, click Export.
   • To view log export history, click View Export List.