select open change scope Open full search

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

Extensions / Monitoring

generic_plan

Generate a generic plan for a parameterized SQL statement.

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

Overview

Packagegeneric_plan
Version1.0
RepositoryUnspecified
Extension typeSQL only
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableYes
Stars11
Latest commit2023-06-05
Catalogue updated2026-08-30

Related extensions

Requires

plpgsqlPL/pgSQL procedural language

See also

apg_plan_mgmtAmazon Aurora PostgreSQL Query Plan Management extension for managed plan baselines.
explanationEXPLAIN plan parser that returns plan nodes as relational rows organized as a proximity tree.
sr_planPlanner-hook extension that records, displays, and reuses saved execution plans, including parameterized-plan templates.
dsefDiffStats and ExplainFull: detailed SQL reports for third party help & support
pg_py_plan_forwardingForward PostgreSQL planner and executor data to embedded Python callbacks
pg_query_stateTool for query progress monitoring in PostgreSQL
pg_session_traceTrace session SQL, bind variables, execution plans, and timing metrics
pg_no_seqscanPrevents or reports sequential scans in development and CI by inspecting query plans.