Enabling the Performance Insights feature on your AWS RDS MySQL and PostgreSQL database instances can provide you with an enhanced overview of your databases' performance and facilitate the identification of potential performance issues. Performance Insights is a performance monitoring tool for evaluating the load on your MySQL/PostgreSQL databases, enabling you to determine when and where action is necessary. It offers an easy-to-understand dashboard that visualizes database load in real-time, allowing you to detect performance bottlenecks. With Performance Insights, you can quickly identify the type of bottleneck, such as high CPU consumption, lock waits, or I/O latency, and determine which SQL queries are causing the bottleneck. Performance Insights is currently available for the following database engines: Amazon Aurora (MySQL and PostgreSQL-compatible editions), AWS RDS MySQL, and AWS RDS PostgreSQL.The Performance Insights feature of AWS Relational Database Service (RDS) provides instant visibility into the nature of workloads on your Amazon RDS databases, helping you to pinpoint the cause of any performance issues you may encounter.
To ensure that your AWS RDS MySQL and PostgreSQL database instances have the Performance Insights feature enabled, you can take the following steps:
Note: Enabling Performance Insights may result in additional charges for data storage and API usage. You may want to review the pricing details before enabling this feature.