Amazon RDS Performance Insights is a database performance tuning and monitoring feature that helps to asess the load on a database, and determine when and where to take action. Performance Insights helps non-experts to detect performance problems with a 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 Amazon Aurora (PostgreSQL- and MySQL-compatible editions), Amazon RDS for PostgreSQL, MySQL, MariaDB, SQL Server and Oracle.
With seven days of free performance history retention, users can track down and solve a variety of issues. The Amazon Web Services API and SDK enables integration of Performance Insights into on-premises and third-party monitoring tools. For longer-term retention, the user can choose to pay for up to two years of performance history retention.
Performance Insights is started from the Amazon RDS Management Console, where the user can enable Performance Insights when creating or modifying an instance of a supported RDS engine. From the Performance Insights dashboard, the user can start monitoring performance.