Ads were blocked by your webbrowser.

This is not a problem, but keep in mind that developing HeidiSQL, user support and hosting takes time and money.

You may want to send a donation instead.

New feature: Send EXPLAIN output to MariaDB's Analyzer

ansgar's profile image 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's profile image 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's profile image 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.


Ads were blocked by your webbrowser.

This is not a problem, but keep in mind that developing HeidiSQL, user support and hosting takes time and money.

You may want to send a donation instead.
GSnyder's profile image GSnyder posted 7 years ago
Sounds great - thanks for working on this!
ansgar's profile image ansgar posted 7 years ago
Done in r4190.
GSnyder's profile image GSnyder posted 7 years ago
Seems to work very well for me.

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