Menu
I know that query execution plan visualizer exists.
But never see it for mysql. Do you know one?
431
To view a visual explain execution plan, execute your query from the SQL editor and then select Execution Plan within the query results tab. The execution plan defaults to Visual Explain , but it also includes a Tabular Explain view that is similar to what you see when executing EXPLAIN in the MySQL client.
The EXPLAIN keyword is used to obtain information about how our SQL databases execute the queries in MySQL. It is synonyms to the DESCRIBE statement. In practice, the DESCRIBE keyword provides table structure information, whereas the EXPLAIN keyword gives the query execution plan.
The MySQL Query Analyzer enables you to monitor SQL statements executed on a MySQL server and displays the details of each query, number of executions and execution times. Similar queries with different literal values are combined for reporting purposes.
The filtered column indicates an estimated percentage of table rows that will be filtered by the table condition. That is, rows shows the estimated number of rows examined and rows × filtered / 100 shows the number of rows that will be joined with previous tables.
I know this is an old question, but if you're using MySQL workbench, have a look at their tools: https://www.mysql.com/products/workbench/performance/
The explain plan shows the operations MySQL performs when it runs SQL statements. This information can help optimize SQL performance. MySQLWorkbench Visualize Explain plans graphically show and highlight how SQL statements execute within MySQL.
In my version (6.3 on a mac), it's the Query option from the top menu, then "Explain current statement" - use this on the actual query, not the EXPLAIN ... query.
See also https://opensourcedba.wordpress.com/2012/11/09/visual-explain-part-2/
Hope that helps (:
128
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
