sql - How can I analyse a Sqlite query execution?

Question

I have a Sqlite database which I want to check the indexes are correct. MS SQL Analyser is great at breaking down the query execution and utilised indexes.

Is there a similar tool for Sqlite?

Answer 1

As outis said:

EXPLAIN QUERY PLAN SELECT * FROM FOO

Does the trick with a more readable output, if like me you're simply using it to ensure you're hitting your indexes (indices?)