3 ms·
Show HN: I made a tool to visualize MySQL EXPLAIN query plans
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?
- rawfan 2y agoGreat result. Can’t wait to use this on my codebase!
- iambateman 2y agoThis looks so cool, thanks for sharing! So grateful for little tools like this.
- tpetry 2y agoOh 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.
- PeterZaitsev 2y agoVery cool!
- nektro 2y agowould love to see examples
- tpetry 2y agoThere are examples: Directly at the bottom of the black frame where you have to input the data.
- cddotdotslash 2y agoThis is nice! Did you use a library for the visualization part (the dotted background with the zoom/pan)?
- 0x073 2y agoShould be https://reactflow.dev https://reactflow.dev