MySQL Bugs: #58021: GUI for EXPLAIN

Bug #58021	GUI for EXPLAIN
Submitted:	5 Nov 2010 19:42	Modified:	6 Feb 2013 20:12
Reporter:	Flavio Oliveira	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S4 (Feature request)
Version:	5.2.29	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	EXECUTIONPLAN, explain, GUI

Description:
This sugestion tries to find easy way to understand what is happening on my queries at the moment of the server execution, and understand what can i change on my query to get better performance.

Just to take a little comparation with what i mean for this feature, is something like the execution plan of MS SQL Server that gives a very detailed information about everything done on a query with a hierarchical kind of picture.

when i run more than one query "at the same time" this execution plan not only shows for each query the own percentage cost on total execution, that is great when i've to campre two queries for the same result, but also if possible something like "on this last version of MS SQL Server", sugest some enhancements for this query/table/DB like "create an index with field xxx and yyy will increase about XXpercent of performance", ...

I think the explain works well, but if i'm not an expert on database architacture, the ways to get better performce queries are a lot harder, with this functionality we can get a better way to understand what is happening with my performance and what can i do to get it better.

thanks in advance.

How to repeat:
Feature request

Suggested fix:
Feature request

* When i say "MS SQL Server" i mean the "MS SQL SERVER Management Studio"
thanks

Thank you for the feature request.

This feature is available in the latest version of WB, when using MySQL server 5.6

Fixed as of MySQL Workbench 5.2.45, and here's the changelog entry:

The "Visual Explain Current Statement" feature was added. It's similar to
the existing "Explain Current Statement" feature, except this visual
version generates a flowchart based on an "EXTENDED" "EXPLAIN" statement
where "FORMAT = JSON". This feature requires MySQL Server 5.6.5 or above.

Thank you for the bug report.