Skip to content

Adding Generic Plan for EXPLAIN in Postgres V16 Upgrade#1265

Open
yaojiejia wants to merge 5 commits intosqlancer:mainfrom
yaojiejia:psql_v16_explain_generic
Open

Adding Generic Plan for EXPLAIN in Postgres V16 Upgrade#1265
yaojiejia wants to merge 5 commits intosqlancer:mainfrom
yaojiejia:psql_v16_explain_generic

Conversation

@yaojiejia
Copy link
Copy Markdown
Contributor

Closes #1044 point 3

JOIN_COLLAPSE_LIMIT("join_collapse_limit", (r) -> r.getInteger(1, Integer.MAX_VALUE)),
PARALLEL_LEADER_PARTICIPATION("parallel_leader_participation", (r) -> Randomly.fromOptions(1, 0)),
FORCE_PARALLEL_MODE("force_parallel_mode", (r) -> Randomly.fromOptions("off", "on", "regress")),
// FORCE_PARALLEL_MODE("force_parallel_mode", (r) -> Randomly.fromOptions("off", "on", "regress")),
Copy link
Copy Markdown
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Looks good to me except this unrelated change. It seems there is also a conflict, so we can't yet merge.

mrigger added a commit that referenced this pull request Apr 6, 2026
Based on PR #1265, which adds GENERIC_PLAN support for EXPLAIN.
This reimplements the feature with the following bugs fixed:

- EXPLAIN options were each wrapped in separate parentheses
  (e.g. EXPLAIN (ANALYZE) (FORMAT JSON) ...) instead of a single
  comma-separated list (EXPLAIN (ANALYZE, FORMAT JSON) ...)
- BUFFERS and TIMING were generated without ANALYZE, which is required
- GENERIC_PLAN and ANALYZE were not treated as mutually exclusive

Closes #1044 point 3

Co-Authored-By: Claude Opus 4.6 <[email protected]>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

Add support for Postgres v16

2 participants