TE
科技回声
首页24小时热榜最新最佳问答展示工作
GitHubTwitter
首页

科技回声

基于 Next.js 构建的科技新闻平台,提供全球科技新闻和讨论内容。

GitHubTwitter

首页

首页最新最佳问答展示工作

资源链接

HackerNews API原版 HackerNewsNext.js

© 2025 科技回声. 版权所有。

Show HN: I made a tool to visualize MySQL EXPLAIN query plans

19 点作者 tpetry10 个月前
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?

6 条评论

tpetry10 个月前
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.
cddotdotslash10 个月前
This is nice! Did you use a library for the visualization part (the dotted background with the zoom/pan)?
评论 #40970643 未加载
iambateman10 个月前
This looks so cool, thanks for sharing! So grateful for little tools like this.
rawfan10 个月前
Great result. Can’t wait to use this on my codebase!
nektro10 个月前
would love to see examples
评论 #40952193 未加载
PeterZaitsev10 个月前
Very cool!