Automated execution plan tuning extension
pgext.cloud · Source code · Documentation · Control file
| Package | pg_plan_advsr |
|---|---|
| Version | 0.1 |
| PostgreSQL versions | 12 · 13 · 14 · 15 · 16 |
| Repository | Unspecified |
| Extension type | Preloaded |
| Requires CREATE EXTENSION | Yes |
| Requires preload | Yes |
| Trusted | No |
| Relocatable | Yes |
| Shared libraries | pg_hint_plan, pg_plan_advsr, pg_store_plans |
| Schema | plan_repo |
| Stars | 121 |
| Latest commit | 2024-05-27 |
| Catalogue updated | 2026-08-30 |
| pg_hint_plan | Give PostgreSQL ability to manually force some decisions in execution plans. |
| pg_store_plans | track plan statistics of all SQL statements executed |
| apg_plan_mgmt | Amazon Aurora PostgreSQL Query Plan Management extension for managed plan baselines. |
| generic_plan | Generate a generic plan for a parameterized SQL statement. |
| explanation | EXPLAIN plan parser that returns plan nodes as relational rows organized as a proximity tree. |
| pg_py_plan_forwarding | Forward PostgreSQL planner and executor data to embedded Python callbacks |
| pg_stat_plans | Track per-plan call counts, execution times, and example EXPLAIN texts. |
| sr_plan | Planner-hook extension that records, displays, and reuses saved execution plans, including parameterized-plan templates. |
| pg_session_trace | Trace session SQL, bind variables, execution plans, and timing metrics |
| pg_no_seqscan | Prevents or reports sequential scans in development and CI by inspecting query plans. |