search

tursodatabase / libsql-shell-go

7 stars 7 forks source link

fix: explain query plan formatting #147

Open douglasmdev opened 11 months ago

douglasmdev commented 11 months ago

Description

Adds an ASCII tree representation to the output of EXPLAIN QUERY PLAN ...

Related Issues

Visual reference

Here's an example

→ CREATE TABLE t1 (t TEXT);
→ CREATE INDEX i1 ON t1 (t);
→ CREATE TABLE t2 (v text);
→ CREATE INDEX i2 ON t2 (v);
→  SELECT 1; EXPLAIN QUERY PLAN SELECT t FROM t1 UNION SELECT v FROM t2; SELECT 2;
1 
1     
QUERY PLAN
COMPOUND QUERY
  LEFT-MOST SUBQUERY
    SCAN t1
  UNION USING TEMP B-TREE
    SCAN t2
2 
2