Managing query execution plans for Aurora PostgreSQL
Aurora PostgreSQL query plan management is an optional feature that you can use with your
Amazon Aurora PostgreSQL-Compatible Edition DB cluster. This feature is packaged as the apg_plan_mgmt
extension that you can install in your Aurora PostgreSQL DB cluster. Query plan management
allows you to manage the query execution plans
generated by the optimizer for your SQL applications. The apg_plan_mgmt
Amazon extension
builds on the native query processing functionality of the PostgreSQL database engine.
Following, you can find information about Aurora PostgreSQL query plan management features,
how to set it up, and how to use it with your Aurora PostgreSQL DB cluster. Before you get started,
we recommend that you review any release notes for the specific version of the
apg_plan_mgmt
extension available for your Aurora PostgreSQL version. For more information, see
Aurora PostgreSQL
apg_plan_mgmt extension versions in the Release Notes for Aurora PostgreSQL.
Topics
- Overview of Aurora PostgreSQL query plan management
- Best practices for Aurora PostgreSQL query plan management
- Aurora PostgreSQL query plan management
- Capturing Aurora PostgreSQL execution plans
- Using Aurora PostgreSQL managed plans
- Examining Aurora PostgreSQL query plans in the dba_plans view
- Improving Aurora PostgreSQL query plans
- Deleting Aurora PostgreSQL query plans
- Exporting and importing managed plans for Aurora PostgreSQL
- Parameter reference for Aurora PostgreSQL query plan management
- Function reference for Aurora PostgreSQL query plan management
- Reference for the apg_plan_mgmt.dba_plans view for Aurora PostgreSQL-Compatible Edition
- Advanced features in Query Plan Management