Posted On: Sep 14, 2022

Amazon Relational Database Service (Amazon RDS) Performance Insights’ Top SQL tab shows the SQL queries that are contributing the most to database load. Starting today, we are increasing the top SQL queries displayed in Amazon RDS Performance Insights from 10 to 25. Amazon RDS Performance Insights is a database performance tuning and monitoring feature of RDS and Amazon Aurora that helps you quickly assess the load on your database and determine when and where to take action.

Amazon RDS Performance Insights allows non-experts to measure database performance with a simple-to-understand dashboard that visualizes database load. With one click, you can add a fully managed performance monitoring solution to your Aurora clusters and Amazon RDS instances. Amazon RDS Performance Insights automatically gathers necessary performance metrics and visualizes them in a dynamic dashboard on the RDS console. You can identify your database’s top performance bottlenecks from a single graph. 

To get started, log into the Amazon RDS Management Console and enable Amazon RDS Performance Insights when creating or modifying an instance of a supported Amazon RDS engine. Then go to the Amazon RDS Performance Insights dashboard to start monitoring performance. 

Amazon RDS Performance Insights is included with supported Aurora clusters and Amazon RDS instances, and stores seven days of performance history in a rolling window at no additional cost. If you need longer-term retention, you can pay for 1-24 months of performance history retention. For a complete list of regions where Amazon RDS Performance Insights is offered, see Amazon Web Services Regions. To learn more about Amazon RDS Performance Insights and supported database engines, see the Amazon RDS User Guide