model-writtenrun 6950 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Lukas Fittl proposed optional plan-shape identifiers computed during the existing planner traversal, reusable jumbling APIs, and an illustrative pg_stat_plans extension in #1, arguing that core computation would avoid the overhead of hashing EXPLAIN text.
- Jeremy Schneider supported exposing identifiers alongside query IDs in pg_stat_activity in #2, and Artem Gavrilov reported passing tests with formatting issues in #3.
- Michael Paquier requested an independently tested statistics-drop API and recommended node annotations instead of complex handwritten plan jumbling in #4.
- Sami Imseih supplied an alternative generated-jumbling experiment in #5, while also identifying an extension locking problem, missing nested-query information, and opportunities to improve enablement and memory management.
- Andrei Lepikhov questioned plan-shape equivalence and advocated extension-defined identifiers in #7; Lukas later explained why traversal order should distinguish join orders in #17, while Andrei maintained his concern about differing extension requirements in #18.
- Lukas independently adopted generated node annotations in #8, added automatic enablement and statistics-drop tests, and corrected the extension locking and top-level tracking issues.
- Michael generalized the statistics helper into a callback-based API in #9, then committed its core implementation as ce5c620fb6 and its injection-points example as a632cd354d, returning the three remaining patches in #10.
- Lukas refined plan hashing in #16 by separating range-table hashing, correcting array handling, adding bitmap support, changing traversal placement, and including more fields to reduce annotation maintenance.
- Following refactoring discussion in #13 and #14, Sami submitted #19 with a separate plan-node comment cleanup and more generic jumbling filenames, retaining the existing plan-ID and extension design.
- Michael committed the comment-cleanup portion with light formatting and rebase adjustments as 3d17d7d7fb, explaining in #20 that the broader plan-hash definition still needed study.
- Sami reported and patched a misindented comment in #21; it landed unchanged as c9238ad853, with confirmation in #23.
- The naming discussion broadened from jumbling to fingerprinting in #21 and #25, but Greg Sabino Mullane preferred retaining jumble terminology in #29 and Alvaro Herrera opposed renaming without broader consensus in #36.
- Julien Rouhaud explained how changing temporary-table OIDs fragment query statistics in #28, prompting discussion of configurable core algorithms and name-based identities in #30, #32, and #33, without a settled implementation in this thread.
- Michael proposed a narrower jumbling refactor that retained existing filenames and kept AppendJumble() private in #38; Andrei supported that direction and suggested future callback-based generalization in #39.
- Sami extracted the plugin-facing plan-ID infrastructure into thread #51055, where Michael's submission #586831 became 2a0cd38da5 unchanged; although descended from this thread's broader proposal, that landing belongs to the other thread and leaves core plan computation, SQL exposure, EXPLAIN output, and the example extension uncommitted.
- After a long gap, Андрей Казачков revived the remaining core plan-ID work in #41, retaining existing jumbling filenames, incorporating newer infrastructure, and fixing empty-array hashing; #42 immediately repackaged the same changes as one patch.
- Michael reiterated in #43 that the meaning of a generally useful plan identifier remained unsettled, but suggested that EXPLAIN might display a nonzero plugin-supplied identifier independently of core computation.
- At the thread's end, Lukas supported that narrower EXPLAIN proposal in #44, while Sami noted that existing per-plan hooks already allowed extensions to emit identifiers in #45; the supporting infrastructure had landed, but core plan hashing and the example extension remained uncommitted.