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 AWS 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