Free SQLite query plan visualizer

Query Plan Visualizer

Run SQLite in your browser and see how it executes your query.

Your schema, SQL, results, and query plan stay in your browser.

SQLite, PostgreSQL, and MySQL use different plan terms and may choose different work. The same basic questions still help. Look for a table scan, an index search, repeated join work, or a temporary sort.

Try an example

lower(email) makes SQLite scan the customers table.

Learn how to read the plan

Read a query execution plan
Understand covering indexes
Use SQLite EXPLAIN QUERY PLAN

Schema and sample data

Enter CREATE TABLE, CREATE INDEX, and optional INSERT statements.

Loading SQL editor…

Query

Loading SQL editor…

Query result and plan

Run the query to see its rows and query plan.