Posted On: Nov 24, 2020
HAQM RDS Performance Insights supports additional dimensions to identify the source of high-frequency, long-running, and stuck SQL queries faster. The new Performance Insights dimensions are available on HAQM RDS for PostgreSQL and HAQM Aurora with PostgreSQL compatibility.
Previously, gathering performance data on a database required configuration and maintenance of monitoring applications and related resources. Correlating performance data took hours without specialized expertise. To find a query of interest, such as a stuck or long-running SQL query, meant investigating each query one at a time.
RDS Performance Insights allows non-experts and experts to identify top SQL loads and from where they originated on a visual dashboard in seconds. Now, RDS Performance Insights supports segmenting the performance data by additional dimensions, such as database name, application, and session type. You can determine if a specific application is generating unusual high load or is issuing SQL queries that take unusually long to complete. You can then make improvements to your application such as optimizing a slow SQL query, changing connection patterns, adding an index to your database, and scaling your database.
HAQM RDS Performance Insights is a database performance tuning and monitoring feature of RDS that allows you to visually assess the load on your database and determine when and where to take action. With one click in the HAQM RDS Management Console, you can add a fully managed performance monitoring solution to your HAQM RDS database. RDS Performance Insights is included with supported HAQM Aurora clusters and HAQM RDS instances and stores seven days of performance history in a rolling window at no additional cost. If you need longer-term retention, you can choose to pay for up to two years of performance history retention.
To learn more about RDS Performance Insights and supported database engines, read the HAQM RDS User Guide.