distal-attribute
distal-attribute
distal-attribute
distal-attribute

New feature: Send EXPLAIN output to MariaDB's Analyzer

User, date Message
Written by ansgar
2 years ago
Category: News
5045 posts since Fri, 07 Apr 06
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!
Written by GSnyder
2 years ago
3 posts since Sat, 25 Aug 12
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.
Written by ansgar
2 years ago
5045 posts since Fri, 07 Apr 06
I'm planning to add a context menu item in the query panels, where you also find the "Run current query" item.
Written by GSnyder
2 years ago
3 posts since Sat, 25 Aug 12
Sounds great - thanks for working on this!
Written by ansgar
2 years ago
5045 posts since Fri, 07 Apr 06
Done in r4190.
Written by GSnyder
2 years ago
3 posts since Sat, 25 Aug 12
Seems to work very well for me.
 

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