To ensure optimal performance and identify potential issues in your AWS RDS MySQL and PostgreSQL database instances, it is recommended that you enable the Performance Insights feature. AWS RDS Performance Insights provides instant visibility into database workloads and helps to identify the root cause of performance problems. With Performance Insights enabled, you can monitor database load in real time using an intuitive dashboard, allowing you to detect and resolve performance bottlenecks quickly. The feature can help you to identify issues such as high CPU consumption, lock waits, or I/O latency, and pinpoint the SQL queries responsible for them. Performance Insights is currently available for Amazon Aurora (MySQL and PostgreSQL-compatible editions), AWS RDS MySQL, and AWS RDS PostgreSQL database engines. Enabling Performance Insights can help you gain a better overview of your databases' performance, and is an essential step in maintaining optimal performance and adherence to AWS best practices.
To ensure that AWS RDS MySQL and PostgreSQL database instances have Performance Insights feature enabled, you can follow the below remediation steps:
Alternatively, you can use the AWS CLI or SDK to enable Performance Insights for your RDS instances.