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?

user_17160 · Answer

There's this nice graphical tool

https://github.com/asutherland/grok-sqlite-explain

Here's example of output:

Example output of explain

And associated blogpost: http://www.visophyte.org/blog/2010/04/06/performance-annotated-sqlite-explaination-visualizations-using-systemtap/

How can I analyse a Sqlite query execution?

3 Answers