SQLite memo

query_plan.py

import sqlite3

conn = sqlite3.connect(":memory:")
conn.row_factory = sqlite3.Row

def print_query_plan(query, bindings={}):
    depth_of = {0: -1}
    result = conn.execute("EXPLAIN QUERY PLAN " + query, bindings).fetchall()
    for r in result:
        depth = depth_of[r['parent']] + 1
        depth_of[r['id']] = depth
        print('|  ' * depth + r['detail'])