sqlite3 app.db '.timer on'

Category: Databases & SQL

sqlite3 app.db '.timer on'

Print timing for each executed statement

Shows CPU time per statement in the interactive session — a quick way to compare query performance. Related: EXPLAIN QUERY PLAN.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.