CloudWatch Database Insights
Use CloudWatch Database Insights to monitor and troubleshoot Amazon Aurora MySQL and Amazon Aurora PostgreSQL databases at scale.
With Database Insights, you can monitor your database fleet with pre-built, opinionated dashboards. To help you analyze the performance of your fleet, the Database Insights dashboards display curated metrics and visualizations. By presenting metrics in a single dashboard for all databases in your fleet, Database Insights allows you to monitor your databases simultaneously.
For example, you can use Database Insights to find a database that is performing poorly within a fleet of hundreds of database instances. You can then choose that instance and use Database Insights to troubleshoot issues.
For information about engine, AWS Region, and instance class support, see Aurora DB engine, Region, and instance class support for Database Insights in the Amazon Aurora User Guide.
To get started with Database Insights, see the following topics.
Topics
Modes for Database Insights
Database Insights has an Advanced mode and a Standard mode. Standard mode is the default for Database Insights, and you can turn on the Advanced mode for your database.
The following table shows which features CloudWatch supports for the Advanced mode and Standard mode of Database Insights.
| Feature | Standard mode | Advanced mode |
|---|---|---|
| Analyze the top contributors to DB Load by dimension | Supported | Supported |
| Query, graph, and set alarms on database metrics with up to 7 days of retention | Supported | Supported |
| Define fine‐grained access control policies to restrict access to potentially sensitive dimensions such as SQL text | Supported | Supported |
| Create and save fleet‐wide monitoring views to assess health across hundreds of databases | Not supported | Supported |
| Visualize per‐query statistics | Not supported | Supported |
| Analyze slow SQL queries | Not supported | Supported |
| View calling services with CloudWatch Application Signals | Not supported | Supported |
| View a consolidated dashboard for all database telemetry, including metrics, logs, events, and applications | Not supported | Supported |
| Import Performance Insights counter metrics into CloudWatch automatically | Not supported | Supported |
| View Amazon RDS events in CloudWatch | Not supported | Supported |
| Analyze database performance for a time period of your choice with on‐demand analysis | Not supported | Supported |
Data retention
The Advanced mode of Database Insights retains 15 months of metrics collected by Performance Insights.
If Performance Insights is enabled for the Standard mode, Amazon RDS retains 7 days of Performance Insights counter metrics.
For information about counter metrics for Performance Insights, see Performance Insights counter metrics.
For information about the retention period for CloudWatch metrics collected by Database Insights, see the following topics.
Amazon CloudWatch metrics for Amazon Aurora in the Amazon Aurora User Guide
Amazon CloudWatch metrics for Amazon RDS Performance Insights in the Amazon Aurora User Guide
How Database Insights integrates with Performance Insights
Performance Insights is a database performance monitoring service.
Database Insights builds upon and extends the capabilities of Performance Insights. Database Insights adds monitoring, analysis, and optimization features.
To enable the Advanced mode of Database Insights, you must enable Performance Insights.
Database Insights imports Performance Insights counter metrics into CloudWatch automatically. For information about Performance Insights counter metrics, see Performance Insights counter metrics in the Amazon Aurora User Guide.
Pricing
For information about pricing, see Amazon CloudWatch Pricing
