Bug #97282 Integrate TREE explain format and EXPLAIN ANALYZE in Workbench
Submitted: 18 Oct 2019 8:43 Modified: 30 Oct 2019 13:11
Reporter: Georgi Sotirov Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench Severity:S4 (Feature request)
Version:8.0.18 OS:Any
Assigned to: CPU Architecture:Any
Triage: Needs Triage: D5 (Feature request)

[18 Oct 2019 8:43] Georgi Sotirov
Description:
There is currently no possibility to run EXPLAIN with FORMAT=TREE and EXPLAIN ANALYZE directly from MySQL Workbench's user interface. It would be nice to have these new features integrated into Workbench like traditional and JSON explain formats are currently integrated as tabular and visual explain plans.

How to repeat:
Try to receive explain plan in TREE format or run EXPLAIN ANALYZE from the SQL editor toolbar in MySQL Workbench.

Suggested fix:
1. Have a new value "Tree explain" as in the combo box selecting explain output format.
2. Have a new button for EXPLAIN ANALYZE just next to button EXPLAIN in the toolbar. For the icon I could suggest the same as for EXPLAIN, but with a timer.
[18 Oct 2019 12:37] Umesh Shastry
Hello Georgi Sotirov,

Thank you for the reasonable feature request.

Thanks,
Umesh
[30 Oct 2019 13:11] Georgi Sotirov
Looking at the section "High Level Architecture" of WL#4168 (see https://dev.mysql.com/worklog/task/?id=4168) I see that it was envisioned to support EXPLAIN ANALYZE in JSON format (and this could serve TREE format as well). This would allow for easier support of TREE and EXPLAIN ANALYZE in MySQL Workbench. The section is marked for "future" implementation.