![]() To the latest release for your version of Aurora PostgreSQL. We recommend that you upgrade the query plan management extension Support different versions of the apg_plan_mgmt extension. When you install the apg_plan_mgmt extension. Query plan management functionality is added to your Aurora PostgreSQL DB cluster ![]() For more information,Īurora PostgreSQL updates in the Release Notes for Aurora PostgreSQL. Query plan management is supported by all currently available Aurora PostgreSQL releases. Aurora PostgreSQL query plan management versions Such as a new PostgreSQL version or changes to statistics. The case when the optimizer chooses a less optimal plan than it did before a given change to the database environment, ![]() The plan history containsĪll plans captured for the statement, regardless of status. The set of all captured plans for a given managed statement. That is, all the plansįor the managed statement that have "Approved" for their status column in The set of approved plans for a given managed statement. One or more query execution plans stored in the apg_plan_mgmt.dba_plans view. managed statementĪ SQL statement captured by the optimizer under query The following terms are used throughout this topic. The current release of Aurora PostgreSQL query plan management has the following limitations. To learn more about these PostgreSQL language features,Īnd other topics in the PostgreSQL documentation.įor information about different versions of the Aurora PostgreSQL query plan management feature, seeĪpg_plan_mgmt extension versions in the Release Notes for Aurora PostgreSQL. Including partitioned tables, inheritance, row-level security, and recursive common More about query plan management's modes (manual, automatic), seeĪurora PostgreSQL query plan management supports all PostgreSQL language features, ![]() For more information, seeĪnalyzing the optimizer's chosen plan. You can use query plan management with EXPLAIN in manual mode toĬapture a plan without actually running it. Statements inside procedures and DO-blocks. SQL Commands in the PostgreSQL documentation. For more information, see PREPAREĭynamic statements, including those run in immediate-mode. Any SELECT, INSERT, UPDATE, or DELETE statement, regardless of complexity. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |