model-writtenrun 8828 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Maciek Sakrejda reported that parallel-sort EXPLAIN plans emitted duplicate Workers fields in structured formats, causing common JSON parsers to discard sort information #1.
- Andres Freund proposed collecting output in per-worker buffers and combining sort, execution, and buffer statistics into coherent worker groups, including in TEXT output, and identified related JIT reporting problems #2.
- Maciek implemented buffering for structured formats and added JSON regression tests, initially leaving TEXT and JIT output unchanged #3.
- After the patch entered commitfest review, Georgios Kokolatos identified an integration issue with hide_workers, and Maciek rebased the patch #7 #8.
- Georgios requested additional format coverage but withdrew the YAML-test suggestion because of unstable output; Maciek then added combined TEXT worker output and corresponding tests #9 #11 #12.
- Georgios's detailed review led to private helpers and style improvements, while Maciek restored a missing hide_workers check and unified buffer reporting; Georgios subsequently reported passing tests and marked the patch ready for a committer #13 #16 #17.
- Maciek corrected incomplete filtering of volatile buffer counts after a Windows test failure, but Tom Lane explained that unpredictable worker availability made the proposed expected output fundamentally unreliable #18 #19.
- Tom substantially rewrote the implementation to preserve each worker's formatting state, fix force_parallel_mode=regress behavior, and retain existing TEXT spacing, temporarily omitting the disputed tests #21.
- Tom extended the rewrite to merge per-worker JIT information into the same worker groups, fixing missing Gather Merge reporting and placing JIT details on the child node alongside other worker statistics #23.
- Tom committed 1001368497 from #23 with a comment adjustment and rewritten regression tests that validate JSON before stripping variable worker details and add XML and YAML coverage; the commit was restricted to the development branch because changing EXPLAIN output in minor releases could disrupt users #24.
- After the commit, Andres suggested further refactoring and a worker-acquisition retry setting; Tom deferred exposing private helpers without a concrete use case and ended the thread proposing a general timeout setting to improve both production behavior and regression-test stability, leaving that follow-up unimplemented here #25 #26 #27.