Skip to content

Analyze your Amazon RDS and Aurora PostgreSQL workloads

Language: English
Analyze your Amazon RDS and Aurora PostgreSQL workloads
0
Do you want to better understand your Amazon RDS and Aurora PostgreSQL workloads? Explore these curated resources for the best practices to analyze your Amazon RDS and Aurora PostgreSQL workloads.

Performance Insights

It's a best practice to use the Performance Insights dashboard to analyze your Amazon RDS metrics, DB load, database performance, and top SQL queries.

Using Performance Insights to Analyze Performance of Amazon Aurora PostgreSQL

Watch this video for a demonstration of using Amazon RDS Performance Insights to analyze performance of an Amazon Aurora PostgreSQL database instance.

Identify top and slow queries

It's a best practice to identify top and slow queries and analyze Amazon RDS for PostgreSQL logs in Amazon Cloudwatch.

Handle idle and idle in transactions

It's a best practice to check the status of your DB connections, and then stop idle sessions to keep your database running smoothly.

Collect and monitor statistics

It's a best practice to collect and monitor various statistic functions of your Aurora PostgreSQL workloads for performance.