select open change scope Open full search

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

Extensions / Monitoring

pg_plan_guard

Detect drift from approved PostgreSQL 19 plan-advice baselines

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

Overview

Packagepg_plan_guard
Version1.1
PostgreSQL versions19
RepositoryUnspecified
Extension typeSQL only
Project statusActive
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableNo
Schemaplan_guard
Stars1
Latest commit2026-09-16
Latest release2026-09-12
Catalogue updated2026-09-19

Related extensions

Requires

pg_plan_adviceDescribe and constrain planner choices with plan advice

See also

pg_hint_planGive PostgreSQL ability to manually force some decisions in execution plans.
plan_filterfilter statements by their execution plans.
pg_qualstatsAn extension collecting statistics about quals
auto_explainProvides a means for logging execution plans of slow statements automatically
pg_show_plansshow query plans of all currently running SQL statements
pg_overexplainAllow EXPLAIN to dump even more details
pg_plan_adviceDescribe and constrain planner choices with plan advice
pg_stash_adviceStore plan advice by query ID and automatically apply it during PostgreSQL query planning
pg_living_assertionsExecutable SQL checks with verdict dates and assertion history