sqlite3 app.db '.eqp on'

Category: Databases & SQL

sqlite3 app.db '.eqp on'

Show the query plan before every statement

Like EXPLAIN QUERY PLAN but automatic: each executed query prints its plan first. Flip off with .eqp off. Related: EXPLAIN QUERY PLAN.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.