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
Oct 27
2025
2025
Optimize and troubleshoot database performance in Amazon Aurora PostgreSQL by analyzing execution plans using CloudWatch Database Insights
Jan 28
2025
2025
Monitor the health of Amazon Aurora PostgreSQL instances in large-scale deployments
Sep 30
2024
2024
Amazon Aurora supports PostgreSQL 16.4, 15.8, 14.13, 13.16, and 12.20
Aug 8
2024
2024
Amazon Aurora supports PostgreSQL 16.3, 15.7, 14.12, 13.15, and 12.19
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.