Tags

0.12.0-rc.3

0.12.0-rc.3

PostgreSQL 16-19 EXPLAIN text-rendering fidelity — long-tail closure + CI guard.

Builds on 0.12.0-rc.2. pkg/pgexplain now byte-reproduces psql's native FORMAT TEXT
across PG16-19, enforced by a per-version CI fidelity guard.

- fix(pgexplain): 8 byte-fidelity fixes found by a strict joe-vs-psql re-diff —
  suppress 'Rows Removed by Filter: 0'; SetOp/HashSetOp label; Function Scan
  'Function Call:'; multi-function ROWS FROM alias; Result 'One-Time Filter';
  Tid Scan 'TID Cond'; quote_identifier for special Subquery Scan aliases;
  PG18+ Storage line ordering.
- test(pgexplain): per-version CI fidelity guard (TestFidelityAgainstLiveServer +
  fidelity-pg-matrix jobs) asserting joe == psql FORMAT TEXT after a documented
  4-trait normalization; small allowlist = the known #210 gaps.

Reviewed by akartasov. Audit + remaining backlog tracked in #210.

0.12.0-rc.2

0.12.0-rc.2

PostgreSQL 16-19 EXPLAIN text-rendering fidelity.

pkg/pgexplain now byte-reproduces psql's native FORMAT TEXT from a JSON plan:
- fix(pgexplain): aggregate Strategy/Partial labels (GroupAggregate/MixedAggregate,
  Finalize/Partial), never-executed nodes, trigger for-constraint, Function Scan
  alias + schema-qualification, comma-separated Buffers sections, Bitmap Index Scan 'on'.
- feat(pgexplain): render previously-dropped fields - Memoize cache stats, Join Filter
  + Rows Removed, Incremental Sort Presorted Key + Full-sort/Pre-sorted Groups, Index
  Recheck + Heap Blocks, HashAgg spill, WindowAgg Run Condition.
- feat: cmd/explainrender CLI to render EXPLAIN JSON via joe's renderer.

All red/green against real PostgreSQL 16/17/18/19beta1; oracle is psql FORMAT TEXT.
Audit + remaining strict-re-diff backlog tracked in #210.

0.12.0-rc.1

0.12.0-rc.1

PostgreSQL 17/18/19(beta1) EXPLAIN compatibility + HypoPG fix.

- fix(pgexplain): support PG18 fractional Actual Rows (uint64->float64) and
  signed Query Identifier (int64) — explain was fully broken on PG18.
- feat(pgexplain): render PG18 fields (Disabled, Index Searches, WAL Buffers
  Full, Storage); broader node-type coverage; fix ModifyTable rendering.
- fix(hypo): query hypopg() directly instead of hypopg_list_indexes() (became a
  view in HypoPG 1.2.0; was failing with SQLSTATE 42883).
- ci: PG13-19beta1 EXPLAIN matrix + HypoPG integration test.

0.11.1

0.11.0

v0.11.0-rc.6

v0.12.0-alpha.0

0.11.0-rc.5

0.11.0-rc.4

0.11.0-rc.3

0.11.0-rc.2

0.11.0-rc.1

0.10.0

0.10.0-rc.1

0.9.4

0.9.3

0.9.2

0.9.1

0.9.0

0.9.0-rc.1