I would like to raise for your consideration merging the EXPLAIN improvement work that was developed in the PHOENIX-7876-feature[1][2] branch. The tl;dr on this work is that it updates EXPLAIN to cover all Phoenix capabilities and significantly improves its coverage of optimizer decision making and the fidelity of the resulting execution plan representation, and introduces 'EXPLAIN FORMAT JSON' to enable better integration with automated monitoring and agentic systems.
For your consideration and review, there is a design doc [3], a branch reviewer's guide [4], a catalog of ~60 worked examples [5], and attestation of test results [6]. Although I have tested the complete suite locally, I am unsure how to test a feature branch on ASF Phoenix GitHub and would appreciate your advice and pointers in this regard. [1] https://github.com/apache/phoenix/tree/PHOENIX-7876-feature [2] https://github.com/apache/phoenix/commits/PHOENIX-7876-feature/ [3] https://docs.google.com/document/d/10H_MNWGQL7ZzsPmIVBMz7T1jJroez8AYpvwouKcBVQo/edit?tab=t.0 [4] https://issues.apache.org/jira/secure/attachment/13082781/PHOENIX_EXPLAIN_REVIEWER_GUIDE.md [5] https://issues.apache.org/jira/secure/attachment/13082782/PHOENIX_EXPLAIN_EXAMPLES.md [6] https://issues.apache.org/jira/secure/attachment/13082865/PHOENIX_7876_MERGE_TEST_REPORT.md -- Best regards, Andrew
