select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Administration

sr_plan

Planner-hook extension that records, displays, and reuses saved execution plans, including parameterized-plan templates.

pgext.cloud · Source code · Documentation · License text · Control file

Overview

Packagesr_plan
Version1.2
PostgreSQL versions10 · 11
RepositoryUnspecified
Extension typePreloaded
Project statusUnmaintained
Requires CREATE EXTENSIONYes
Requires preloadYes
TrustedNo
RelocatableNo
Shared librariessr_plan
Stars64
Latest commit2022-08-01
Latest release2018-12-18
Catalogue updated2026-08-30

Related extensions

See also

pg_py_plan_forwardingForward PostgreSQL planner and executor data to embedded Python callbacks
micromanageexample extension to inject plans
geqo_extensionLoad-only extraction of PostgreSQL's Genetic Query Optimizer with a planner hook and configurable GEQO behavior.
saioExperimental load-only planner hook that searches PostgreSQL join orders with simulated annealing as an alternative to GEQO
generic_planGenerate a generic plan for a parameterized SQL statement.
apg_plan_mgmtAmazon Aurora PostgreSQL Query Plan Management extension for managed plan baselines.
pg_session_traceTrace session SQL, bind variables, execution plans, and timing metrics
repeaterDemonstration extension for executing serialized raw query plans on a remote PostgreSQL node.