select open change scope Open full search

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

Extensions / Monitoring

explanation

EXPLAIN plan parser that returns plan nodes as relational rows organized as a proximity tree.

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

Overview

Packageexplanation
Version0.3.0
PostgreSQL versions10 · 11 · 12 · 13 · 14
RepositoryUnspecified
Extension typeSQL only
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableYes
Stars13
Latest commit2020-10-18
Latest release2011-04-30
Catalogue updated2026-08-30

Related extensions

Requires

plpgsqlPL/pgSQL procedural language

See also

pg_stat_plansTrack per-plan call counts, execution times, and example EXPLAIN texts.
dsefDiffStats and ExplainFull: detailed SQL reports for third party help & support
generic_planGenerate a generic plan for a parameterized SQL statement.
pg_substraitExecute Substrait protobuf or JSON query plans through PostgreSQL functions
micromanageexample extension to inject plans
pg_store_planstrack plan statistics of all SQL statements executed
jx_ioExtension to export and import json and xml from/to postgres
pg_overexplainAllow EXPLAIN to dump even more details
fhirbaseIncomplete PostgreSQL extension scaffold for a FHIR database.
xnodeImplementation of XML using DOM.