• Relational Database Service

rds
  1. Help Center
  2. Relational Database Service
  3. User Guide
  4. FAQs
  5. Management FAQs
  6. What Should I Do If My Queries Are Executed Slowly?

What Should I Do If My Queries Are Executed Slowly?

  1. You can view the slow SQL logs to check whether any slowly executed SQL queries exist and view their performance characteristics (if any) to locate the cause.

    For details on viewing MySQL logs, see section Viewing Slow Query Logs.

    For details on viewing PostgreSQL logs, see section Viewing Error Logs.

    For Microsoft SQL Server, you can query dynamic management views (DMVs) to locate the cause of slow queries. For details on DMVs, visit the Microsoft official website.

  2. You can view CPU usage metrics of RDS DB instances to facilitate problem locating.

    For details, see section Configuring Displayed Metrics.