Skip to content

feat(explain): visual query plan (Plan | Text) for PostgreSQL, MySQL, SQLite #1164

Closed

Description

@ZhuchkaTriplesix

Problem

Explain shows the plan as lines of text in the result grid (QUERY PLAN column, generic_sql_workspace.dart:590). Finding the expensive node in a nested plan means reading indentation.

Scope

  • Plan formats: PostgreSQL EXPLAIN (FORMAT JSON) (and ANALYZE, BUFFERS behind an explicit Explain analyze action with the destructive-query rules, since it executes the query), MySQL EXPLAIN FORMAT=JSON / EXPLAIN ANALYZE (8.0.18+), SQLite EXPLAIN QUERY PLAN (id, parent, detail already form a tree).
  • Plan view: a tree (top-down) of nodes with operation, relation, rows (estimated / actual), cost / time; node colour by share of total cost; the most expensive path highlighted. Click a node: details panel with all fields.
  • Text view kept (today's lines), switch Plan | Text.

Acceptance

  • PostgreSQL, MySQL, SQLite: a join of 3 tables renders as a tree with the right parent / child structure.
  • The most expensive node is highlighted.
  • Parser unit tests on recorded plans per dialect.

Activity

  1. added
    enhancementNew feature or request
    editorCode/SQL editor
    uiUser interface components and widgets
    P3Low priority / Polish & Enhancements
    on Oct 8, 2026
  2. ZhuchkaTriplesix commented on Oct 9, 2026

    @ZhuchkaTriplesix
    MemberAuthor

    Closed by #1249: recorded plans for PostgreSQL, MySQL and SQLite, with tree, cost and highlight tests.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    P3Low priority / Polish & EnhancementseditorCode/SQL editorenhancementNew feature or requestuiUser interface components and widgets

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions