How can I analyse a Sqlite query execution?

sql sqlite query-optimization sql-execution-plan
Phil Hannent picture Phil Hannent · Sep 21, 2009 · Viewed 18.1k times · Source

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

Chris picture Chris · Aug 4, 2011

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?)

Related questions

Increment counter or insert row in one statement, in SQLite

In SQLite, given this database schema CREATE TABLE observations ( src TEXT, dest TEXT, verb TEXT, occurrences INTEGER ); CREATE UNIQUE INDEX observations_index ON observations (src, dest, verb); whenever a new observation tuple (:src, :dest, :verb) comes in, I want to …

Read More
Select first row in each GROUP BY group?

As the title suggests, I'd like to select the first row of each set of rows grouped with a GROUP BY. Specifically, if I've got a purchases table that looks like this: SELECT * FROM purchases; My Output: id | customer | total …

Read More
How to list the tables in a SQLite database file that was opened with ATTACH?

What SQL can be used to list the tables, and the rows within those tables in an SQLite database file - once I have attached it with the ATTACH command on the SQLite 3 command line tool?

Read More