Select your cookie preferences

We use essential cookies and similar tools that are necessary to provide our site and services. We use performance cookies to collect anonymous statistics, so we can understand how customers use our site and make improvements. Essential cookies cannot be deactivated, but you can choose “Customize” or “Decline” to decline performance cookies.

If you agree, AWS and approved third parties will also use cookies to provide useful site features, remember your preferences, and display relevant content, including relevant advertising. To accept or decline all non-essential cookies, choose “Accept” or “Decline.” To make more detailed choices, choose “Customize.”

Skip to main content

Performance Insights

Analyze and tune Amazon RDS database performance

Get started with Performance Insights

Amazon RDS Performance Insights?

Amazon RDS Performance Insights is a database performance tuning and monitoring feature that helps you quickly assess the load on your database, and determine when and where to take action. Performance Insights allows non-experts to detect performance problems with an easy-to-understand dashboard that visualizes database load.

Performance Insights uses lightweight data collection methods that don’t impact the performance of your applications, and makes it easy to see which SQL statements are causing the load, and why. It requires no configuration or maintenance, and is currently available for  (PostgreSQL- and MySQL-compatible editions), Amazon RDS for PostgreSQL, MySQL, MariaDB, SQL Server and Oracle.

With seven days of free performance history retention, it's easy to track down and solve a wide variety of issues. The Amazon Web Services API and SDK make it easy to integrate Performance Insights into on-premises and third-party monitoring tools. If you need longer-term retention, you can choose to pay for up to two years of performance history retention.

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

Please note that starting November 30, 2025 the Performance Insights console experience and flexible retention period pricing will no longer be supported. We recommend that you use CloudWatch Database Insights going forward to access an expanded set of capabilities, including fleet-level monitoring, integration with application performance monitoring, lock analysis, and more.

Play
Seek backward
Seek forward
Mute
Volume
Current Time 0:00
Duration 0:00
See more videos like this
Loaded: 0%
NaN
 
Settings
Captions
Transcript
Fullscreen
Seek forward
Seek backward
Play
Transcript
Auto Scroll On
A
A
thumbnail for video undefined

Benefits

What Can You Monitor with Performance Insights?

Production Applications

Detect performance problems in production as soon as they happen. Performance Insights shows what’s causing the load on the database, so you can take corrective action by tuning your SQL statements or increasing your system resources.

Development and Test Databases

Discover the impact of your SQL queries before going into production. Use Performance Insights to monitor your CPU consumption, and then determine the right instance size for your database, and whether your SQL statements should be tuned for better performance.

Database Migrations

Migrating your database to the cloud, or to a new AWS instance type? Use Performance Insights to monitor your CPU consumption, and then determine the right instance size for your database, and whether your SQL statements should be tuned for better performance.