Show query plans in the Linux SQL editor
维护者通常 1 天内回复
@J2TeamNNL 已经在做这个了。
开始于 2026年10月31日。
评估
- 难度
- 5/5
- 预计耗时
- 一周以上
- 新手友好度
- 35/100
调研方向
Start with linux/crates/core/src/statement/statement_builder.rs and the macOS reference features/explain-visualization.mdx; the issue also points to linux/ROADMAP.md. Trace how statements and results are built in the Linux app, then compare each engine’s required plan format. Done means Explain renders a PostgreSQL join as a tree with row estimates and works across the listed engines.
由索引模型根据 Issue 内容生成。
描述
Problem
The Linux app has no way to show a query plan. The user can type EXPLAIN in the editor and read the plan as rows of text, but nothing draws it, and each engine has its own format: text or JSON on PostgreSQL and MySQL, XML on SQL Server, a list of steps on SQLite. The only EXPLAIN in the code is a unit test (linux/crates/core/src/statement/statement_builder.rs:166).
It is not on the roadmap: neither the backlog nor the Ideas list (linux/ROADMAP.md, Backlog, Ideas) mentions it. The macOS app draws plans (features/explain-visualization.mdx).
Proposed solution
- Explain in the editor, for the statement at the cursor or the selection, with a shortcut.
- Each engine runs its own form:
EXPLAIN (FORMAT JSON)on PostgreSQL,EXPLAIN FORMAT=JSONon MySQL and MariaDB,SET SHOWPLAN_XML ONon SQL Server,EXPLAINon ClickHouse, andEXPLAIN QUERY PLANon SQLite. - The plan shows as a tree of nodes in a results entry, built from GTK list widgets, with each node's estimated rows and cost where the engine gives them, and the costliest node marked.
- Explain Analyze, where the engine has it, runs the statement, so it asks first. On a statement that writes, it is refused on a read-only connection and otherwise runs inside a transaction that is rolled back.
- The raw plan text stays one click away, for copying.
Done means: on PostgreSQL, Explain on a join shows a tree with row estimates, and the same action works on the other engines with their own plan formats.
Alternatives considered
Run EXPLAIN by hand in the editor and read the rows.
Platform
Linux
Related database type
N/A / General
- 主要语言
- Swift
- 星标
- 6.2k
- 派生
- 412
- 平均合并
- 3 小时 56 分钟
- 30 天内合并 PR
- 669
环境准备
这个项目没有提供开发容器、Dockerfile 或贡献指南，环境需要你自己搭建：先看它的 README，通用步骤见我们的新手贡献指南。
从这里开始
- 先读完整个 Issue，再读项目的贡献指南。
- 在 Issue 下留言说明你要接手 —— 这能避免两个人做同样的事。
- Fork 仓库，在一个分支上完成修改。
- 提交 Pull Request，并在描述里引用这个 Issue 编号。
TableProApp/TablePro 的其他 Issue
-
Linux: Remember Password fails silently when there is no default keyring可能已有人在做 @datlechin 今天认领。 未关闭bug platform-linux
难度 2/5 1-3 小时 新手友好度 75/100
TableProApp/TablePro#4098 ·
维护者通常 1 天内回复
-
bug platform-linux
难度 2/5 1-3 小时 新手友好度 35/100
TableProApp/TablePro#4101 ·
维护者通常 1 天内回复
-
bug platform-linux
难度 4/5 3-5 天 新手友好度 48/100
TableProApp/TablePro#4099 · 3 条评论 ·
维护者通常 1 天内回复
-
enhancement platform-macos
难度 5/5 一周以上 新手友好度 25/100
TableProApp/TablePro#4071 ·
维护者通常 1 天内回复
-
enhancement platform-macos
难度 3/5 1-2 天 新手友好度 66/100
TableProApp/TablePro#4070 ·
维护者通常 1 天内回复
查看 TableProApp/TablePro 的全部 Issue
相似的 Issue
-
难度 2/5 1-3 小时 新手友好度 83/100
OneBusAway/vehicle-positions#260 ·
维护者通常 1 天内回复
-
难度 1/5 1 小时以内 新手友好度 85/100
eliasstravik/herdr-projects#789 · 1 条评论 ·
-
follow-up needs-triage S3: minor
难度 1/5 1-3 小时 新手友好度 85/100
manaflow-ai/cmux#38032 · 1 条评论 ·
维护者通常 1 天内回复
-
难度 2/5 1-3 小时 新手友好度 67/100
arkavo-org/ArkavoKit#70 ·
维护者通常 1 天内回复
-
bug
难度 2/5 1-3 小时 新手友好度 70/100
vorssaint/vorssaint-utils#3933 · 1 条评论 ·
维护者通常 2 天内回复