MySQL Bugs: #120451: Partitioning Information In EXPLAIN

Bug #120451	Partitioning Information In EXPLAIN
Submitted:	11 May 17:56
Reporter:	Øystein Grøvlen	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Optimizer	Severity:	S4 (Feature request)
Version:	10.x	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Add partition pruning information to iterator-based EXPLAIN output.

Traditional EXPLAIN already reports the selected partitions in the partitions column, and legacy JSON EXPLAIN exposes the same information through a partitions property. The tree-based EXPLAIN output, including hypergraph plans and EXPLAIN ANALYZE, currently omits this information. The new iterator-based JSON format, used by JSON format version 2 and hypergraph JSON output, also does not expose the selected partitions today.

This work should make partition information visible on relevant table access nodes in tree-based EXPLAIN and in the new JSON format, so all EXPLAIN formats provide consistent visibility into partition pruning.

How to repeat:
N/A