New feature: Send EXPLAIN output to MariaDB's Analyzer

ansgar posted 7 years ago in News
The output of an EXPLAIN SELECT ... query can be quite cryptic and difficult to understand. On the MariaDB website you can find a tool named Explain Analyzer, which helps to understand most used keywords and phrasings. HeidiSQL now offers to send the EXPLAIN output from within the processlist tab directly to that analyzer tool:

Thanks to Bryan Alsdorf at MariaDB for excellent support!
1 attachment(s):
  • explain-analyzer
GSnyder posted 7 years ago
This looks like a very interesting addition. But if I may kibitz, wouldn't it be more generally useful if it were available from Query panels as well?

I'm probably missing something within HeidiSQL, but it looks like there's no obvious way to capture text-only output from an EXPLAIN query so that it can be manually pasted into the MariaDB explain analyzer.

On my system, even the mysql shell that comes up when I do "Launch command line" from within HeidiSQL has no Copy feature for output.
ansgar posted 7 years ago
I'm planning to add a context menu item in the query panels, where you also find the "Run current query" item.
GSnyder posted 7 years ago
Sounds great - thanks for working on this!
ansgar posted 7 years ago
Done in r4190.
GSnyder posted 7 years ago
Seems to work very well for me.

Please login to leave a reply, or register at first.