Monitor query plans for Amazon Aurora PostgreSQL
Database Blog
This article discusses how to monitor query plans in Amazon Aurora PostgreSQL using a new query monitoring feature. It provides valuable insights and optimizations to improve database performance.
Specifically, the article covers:
- Solution overview and prerequisites
- How to monitor query plans using aurora_stat_activity and aurora_stat_plans functions
- Use case 1: Integration with Query Plan Management (QPM) auto capture
- Use case 2: Integration with QPM manual capture using pg_hint_plan extension
- Clean up steps after testing
The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.
Related articles
Apr 24
2024
2024
Monitor query performance with Performance Insights on Amazon RDS for SQL Server
Oct 27
2025
2025
Optimize and troubleshoot database performance in Amazon Aurora PostgreSQL by analyzing execution plans using CloudWatch Database Insights
May 14
2024
2024
Continuously replicate Amazon DynamoDB changes to Amazon Aurora PostgreSQL using AWS Lambda
Jun 16
2026
2026
Improve query performance with EXPLAIN plans in Amazon Aurora DSQL
The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.