SQLite EXPLAIN plan is indeed represented as a table, but I don’t find it necess... | Hacker News

Hacker Timesnew | past | comments | ask | show | jobs | submit

jiehong on April 30, 2024 | parent | context | favorite | on: Why SQLite Uses Bytecode

SQLite EXPLAIN plan is indeed represented as a table, but I don’t find it necessarily that much easier to read and understand.

I often miss having the cardinality and the amount of bytes read for each part of the query like Oracle query plans provide.

Or is everyone really that happy with SQLite query plans?

bvrmn on April 30, 2024 [–]

There is EXPLAIN QUERY PLAN which outputs usual high level plan description. But there is no easily reached disk/cache usage stats.

Consider applying for YC's Fall 2026 batch! Applications are open till July 27.
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact