Free SQLite query plan visualizer
Query Plan Visualizer
Run SQLite in your browser and see how it finds your rows. Your schema and SQL stay in your browser.
Examples
lower(email) makes SQLite scan the customers table.
PostgreSQL and MySQL use different plan terms and may choose different work, but the same questions about scans, searches and sorts still apply.
Enter CREATE TABLE, CREATE INDEX, and optional INSERT statements.
Schema and sample data
10 lines
Loading SQL editor…
Query
Loading SQL editor…
Query plan
lower(email) changes the value SQLite compares, so it cannot use idx_customers_email and reads every customer instead. Choose Direct index lookup to compare.
Query result
1 row
| id | name |
|---|---|
| 1 | Ada Lovelace |