Explain query plan

sql

EXPLAIN QUERY PLAN
SELECT id, created_at
FROM notes
WHERE user_id = 42
ORDER BY created_at DESC
LIMIT 20;

Explanation

SQLite reports whether it scans a table, searches with an index, or can use a covering index optimization.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Planner tools

Populate or refresh planner statistics.

Open In sheetsqlsame section

Ask the SQLite shell for index advice.

Open In sheetbashsame section

Add a basic lookup index.

Open In sheetsql1 tag match

Index a computed expression used in the query.

Open In sheetsql1 tag match

Index only matching rows.

Open In sheetsql1 tag match