MySQL Bugs: #97282: Integrate TREE explain format and EXPLAIN ANALYZE in Workbench

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

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.

Hello Georgi Sotirov,

Thank you for the reasonable feature request.

Thanks,
Umesh

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.