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?
This is nice! Did you use a library for the visualization part (the dotted background with the zoom/pan)?
This looks so cool, thanks for sharing! So grateful for little tools like this.
Great result. Can’t wait to use this on my codebase!
would love to see examples
Very cool!
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.