Show HN: I made a tool to visualize MySQL EXPLAIN query plans (mysqlexplain.com)

19 points by tpetry ↗ HN
I was always confused when trying to optimize a slow MySQL query as the output of the EXPLAIN command is so cryptic and totally useless. And there wasn't any tool that could help visualize what a query does - compared to PostgreSQL which has multiple... So, I started developing such a tool for MySQL. But boy, I didn't expect how complicated this is in reality. There were so many things hiding in tiny information pieces that I had to understand. But it also confirmed me in that a tool should try to understand the EXPLAIN output and not a human as it is too easy to oversee something. After months of work, I've now finished the first iteration of my vision. Whats your opinion about it?

8 comments

[ 7.5 ms ] story [ 37.9 ms ] thread
Great result. Can’t wait to use this on my codebase!
This looks so cool, thanks for sharing! So grateful for little tools like this.
Oh totally forgot to mention: There‘s also an API to skip the manual steps needed on the website. So I plan on integrating it into database tools like DataGrip etc.
would love to see examples
There are examples: Directly at the bottom of the black frame where you have to input the data.