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

[11 May 17:56] Øystein Grøvlen 
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
[26 May 10:20] Kajori Banerjee 
Ppt

Attachment: Kajori_explain_partition_pruning_v4.pptx (application/vnd.openxmlformats-officedocument.presentationml.presentation, text), 5.11 MiB.