MySQL EXPLAIN Visualization with mktools-visual-explain

EXPLAIN statement visualization is something I love about Aqua Data Studio (we use it a lot with DB2) and SQL Server Management Studio. It takes the result of your EXPLAIN and displays it in an easier to understand diagram. Here’s example output from SQL Server:

visual-explain-ssms.png

Aqua Data Studio doesn’t support MySQL Visual Explains (yet). The only way I’ve been able to find EXPLAIN visualization is with maatkit and mk-visual-explain.

Here’s an explain from one of the queries in a project (columns have changed names)

Here’s the output with mk-visual-explain

Which one is easier to understand?

Advertisements

About andyhillky
I'm cool.

One Response to MySQL EXPLAIN Visualization with mktools-visual-explain

  1. adam says:

    bofe.org got taken over by russian spam bots 😦

%d bloggers like this: