How do I configure CloudWatch Database Insights to analyze my Aurora PostgreSQL-Compatible database cluster?

Resolution

Prerequisites: Review the following documentation.

• Amazon RDS DB engine, AWS Region, and instance class support for Database Insights
• Required permissions for Database Insights

Activate Database Insights

Important: Performance Insights will reach its end of life on June 30, 2026. You can upgrade to the Advanced mode of Database insights before June 30, 2026. If you don't upgrade, then DB clusters that use Performance Insights will default to the Standard mode of Database Insights. Only the Advanced mode of Database Insights will support execution plans and on-demand analysis. If your clusters default to the Standard mode, then you might not be able to use these features on the console. To turn on the Advanced mode, see Turning on the Advanced mode of Database Insights for Amazon RDS and Turning on the Advanced mode of Database Insights for Amazon Aurora.

Complete the following steps:

1. Open the Aurora and RDS console.
2. In the navigation pane, choose DB Clusters, and then select your Aurora PostgreSQL cluster.
3. Choose Modify.
4. In the Monitoring section, choose Database Insights - Standard or Database Insights - Advanced. For more information about which option you should choose, see Modes for Database Insights.
5. If you choose, Database Insights - Standard, then set the retention period to at least 7 days activate to activate Performance Insights.
6. Choose Continue.
7. In the Schedule modifications section, choose Apply immediately, and then choose Modify cluster.
   Note: If you choose Apply during the next scheduled maintenance window, then your database ignores this setting and immediately turns on Database Insights.

You can also set up cross-account cross-Region monitoring for CloudWatch Database Insights.

Analyze your Aurora PostgreSQL database clusters

Complete the following steps:

1. Open the Amazon CloudWatch console.
2. In the navigation pane, expand Infrastructure Monitoring, and then choose Database Insights.
3. In the Database Views section, choose Fleet Health or Database Instance.
   Note: The Fleet Health Dashboard shows a snapshot of your database fleet's health. To use Fleet Health, you must activate Database Insights Advanced mode.
4. Choose Database Instance.
5. In the Filters section, select the database instance that you want to analyze.

For more information on how to view the health of a database instance and analyze performance issues, see Viewing the Database Instance Dashboard for CloudWatch Database Insights.

Related Information

Optimize and troubleshoot database performance in Amazon Aurora PostgreSQL by analyzing execution plans using CloudWatch Database Insights

Amazon CloudWatch Database Insights applied in real scenarios