Documentation

Keisen parses and visualizes EXPLAIN output so you can understand how your database executes a query.

Running EXPLAIN

Click the EXPLAIN button in the editor toolbar or prefix your query with EXPLAIN. Keisen runs the appropriate EXPLAIN syntax for your engine and parses the result.

Tree view

The default view shows the query plan as a hierarchical tree. Each node displays:

• Node type — the operation (e.g. Seq Scan, Index Scan, Nested Loop)
• Relation — the table being accessed
• Filter — any filter conditions applied
• Estimated rows vs actual rows (when available)
• Cost and timing information

Flat view

Switch to the flat view for a tabular breakdown with columns:

Column	Description
Node Type	Operation being performed
Relation	Table or index name
Index	Index used (if any)
Filter	Filter condition
Rows Estimated	Planner's row estimate
Rows Actual	Actual rows processed
Time (ms)	Execution time
Loops	Number of loop iterations
Cost	Estimated cost

Engine-specific behavior

PostgreSQL — runs EXPLAIN (FORMAT JSON, ANALYZE) for full execution statistics including actual times, row counts, and buffer usage.

MySQL / MariaDB — runs EXPLAIN FORMAT=JSON for structured plan output with nested loop details, ordering, and grouping operations.

SQLite — runs EXPLAIN QUERY PLAN and parses the id/parent/detail output into a tree structure.