Using Amazon RDS Performance Insights
Amazon RDS Performance Insights monitors your Amazon RDS DB instance load so that you can analyze and troubleshoot your database performance. Amazon RDS Performance Insights is currently available for use with the following DB engines:
-
Amazon Aurora with MySQL compatibility version 1.17.3 and higher 1.x versions
-
Amazon RDS MySQL version 5.7.22 and higher 5.7 versions
-
Amazon RDS MySQL version 5.6.41 and higher 5.6 versions
-
Amazon Aurora with PostgreSQL compatibility
-
Amazon RDS PostgreSQL version 10
-
Amazon RDS Oracle (all versions)
Note
Performance Insights is not supported on db.t2 DB instance classes.
Performance Insights expands on existing Amazon RDS monitoring features to illustrate your database's performance and help you analyze any issues that affect it. With the Performance Insights dashboard, you can visualize the database load and filter the load by waits, SQL statements, hosts, or users. Performance Insights is on by default in the console create wizard for the Amazon Aurora MySQL, Amazon RDS MySQL, Amazon Aurora PostgreSQL, and Amazon RDS PostgreSQL DB engines. If you have more than one database on the DB instance, performance data for all of the databases is aggregated for the DB instance.
The central metric for Performance Insights is DB Load,
which represents the average number of active sessions for the DB engine. The DB Load
metric is collected every second. An active session is a
connection that has submitted work to the DB engine and is waiting for a response
from it. For
example, if you submit a SQL query to the DB engine, the database session is active
while the DB engine is
processing that query.
By combining DB Load with wait event data,
you can get a complete picture of the state for an active session. Wait events vary
by DB engine:
-
For a list of the most commonly used wait events for Aurora MySQL, see Aurora MySQL Events .
-
For information about all MySQL wait events, see Wait Event Summary Tables in the MySQL documentation.
-
For a list of the most commonly used wait events for Aurora PostgreSQL, see Amazon Aurora PostgreSQL Events.
-
For information about all PostgreSQL wait events, see PostgreSQL Wait Events in the PostgreSQL documentation.
Session information is collected, aggregated, and displayed in the dashboard as the Average Active Sessions chart. The Average Active Sessions chart displays the Max CPU value as a line, so you can see if active sessions are exceeding it or not. The Max CPU value is determined by the number of vCPU (virtual CPU) cores for your DB instance.
If you find that the load in the Average Active Sessions chart is often above the Max CPU line and the primary wait state is CPU, the system CPU is overloaded. In these cases, you might want to throttle connections to the instance, tune any SQL queries with a high CPU load, or consider a larger instance class. High and consistent instances of any wait state indicate that there might be bottlenecks or resource contention issues that you should resolve, even if the load doesn't cross the Max CPU line.
You can find an overview of Performance Insights in the following video.
Topics
- Enabling Performance Insights
- Access Control for Performance Insights
- Using the Performance Insights Dashboard
- Additional User Interface Features
- Performance Insights API
- Performance Insights Metrics Published to Amazon CloudWatch
- Performance Insights Counters
- Logging Performance Insights Operations by Using AWS CloudTrail
