See whether SQLite scans or uses an index.
Section: Inspect query plans
Explain a query plan
sql
sql
EXPLAIN QUERY PLAN
SELECT * FROM posts WHERE user_id = 42 ORDER BY created_at DESC LIMIT 10;Explanation
High-signal first step when a query feels slower than expected.
Learn the surrounding workflow
Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.
Related commands
Same sheet · prioritizing Inspect query plans