Viewing the Database Instance Dashboard for CloudWatch Database Insights
Use the Database Instance Dashboard to view a snapshot of the health of a DB instance.
Database load chart
Database load (DB Load) measures the level of session activity in your database. DB Load is the key metric in Database Insights, and Database Insights collects DB Load every second.
For more information about DB Load, see Database load in the Amazon Aurora User Guide.
Use the Database load chart to view DB Load sliced (grouped) by the following dimensions.
Database
Host
SQL
User
Waits
Application (for Amazon Aurora PostgreSQL only)
Session type (for Amazon Aurora PostgreSQL only)
By default, CloudWatch displays DB Load with a bar chart. Choose Line to display DB Load with a stacked line chart.
DB Load analysis tab
Use the DB Load analysis tab to monitor the top contributors to DB Load for each of the following dimensions.
Database
Host
SQL
User
Waits
Application (for Amazon Aurora PostgreSQL only)
Session type (for Amazon Aurora PostgreSQL only)
Analyze statistics for a query
You might want to analyze statistics for a query with a high DB Load. To analyze statistics for a query, use the following procedure.
To analyze statistics for queries
Sign in to the AWS Management Console and open the CloudWatch console at https://console.aws.amazon.com/cloudwatch/
. Choose Insights.
Choose Database Insights.
Choose the Database Instance view.
Choose a DB instance.
Choose the Top SQL tab.
To view statistics for a query, choose a query.
Database telemetry tab
Use the Database telemetry tab to view metrics and logs for the selected instance.
Metrics section for database telemetry
The Metrics section displays a metrics dashboard customized for each engine type.
Logs section for database telemetry
The Logs section provides a view of database logs exported to CloudWatch Logs for the selected DB instance.
For information about publishing logs to CloudWatch Logs for Amazon Aurora, see Publishing database logs to Amazon CloudWatch Logs in the Amazon Aurora User Guide.
Slow SQL Queries section for database telemetry
To view slow SQL queries and query patterns, you must enable log exports to CloudWatch Logs and configure DB parameters for your database.
For information about publishing logs to CloudWatch Logs, see the following topics.
For information about configuring DB parameters for your database, see Configuring your database to monitor slow SQL queries with Database Insights in the Amazon Aurora User Guide.
The Slow SQL Queries section provides a list of slow query patterns sorted by frequency. By selecting a pattern, you can view a list of slow queries that match the selected pattern. You can use the slow query list to identify slow queries affecting your DB instance.
Database Insights displays statistics for slow queries. The statistics represent only queries that exceed the configured slow query duration threshold.
Important
Slow queries may contain sensitive data. Mask your sensitive data with CloudWatch Logs. For more information about masking log data, see Help protect sensitive log data with masking in the Amazon CloudWatch Logs User Guide.
Events table
Use the Events table to view RDS events for your DB instance. For a list of events for Amazon Aurora, see Amazon RDS event categories and event messages for Aurora in the Amazon Aurora User Guide.
Calling services tab
Database Insights shows the services and operations that are calling your instance. Database Insights integrates with CloudWatch Application Signals to provide metrics for each service and operation, including availability, latency, errors, and volume.
Analyze database performance on demand with CloudWatch Database Insights
Analyze database performance with on-demand analyses for your Amazon RDS databases with CloudWatch Database Insights.
Use the Performance analysis tab to view performance analysis reports for databases in your fleet.
For information about performance analysis reports for Amazon Aurora, see Analyzing database performance for a period of time in the Amazon Aurora User Guide.
Note
You must create performance analysis reports using the Amazon RDS console, AWS CLI, or API. For information about creating a performance analysis report for Amazon Aurora, see Creating a performance analysis report in Performance Insights in the Amazon Aurora User Guide.
Integrating CloudWatch Database Insights with CloudWatch Application Signals
Integrate CloudWatch Database Insights with CloudWatch Application Signals.
Use the Calling services tab to view the CloudWatch Application Signals services and operations that called an endpoint of the selected instance. By default, CloudWatch sorts the table by fault rate. Choose values in the Services, Operations, or Endpoint address columns to view the corresponding resource in the CloudWatch Application Signals console.
For more information about supported systems for CloudWatch Application Signals, see Application Signals supported systems .
