Does anyone know if there is a way to log the queries explain plan(like .eqp) with python?

I know the python function set_trace_callback, which can be used to log all the SQL statements out. But when debugging, it could make sense to also see the chosen access plan by the optimizer.

Have you tried just prefacing your SQL with EXPLAIN QUERY PLAN and then just following with your SQL and logging the response?

And then resubmit your SQL should you so desire.

I've tried that, but the SQL statement with EXPLAIN QUERY PLAN wasn't logged by the set_trace_callback function and I was looking for a more easy way to just turn it on/off on a session level.

But I haven't spent a lot of time yet to dig into the issue. Was just curious if there is a well known easy way to do it.

What do you man by 'log' here ?

EXPLAIN QUERY PLAN returns a table, like a SELECT statement. If you execute it the way you would a SELECT statement, it should return the same data structure your library would get from any other query. Do what you like with it, including processing it in a callback.

However, SQLite does not do all the processing needed to neatly format what EXPLAIN QUERY PLAN returns every time you do a SELECT. If you want to know the query plan for every SELECT you do, you're going to have to execute two statements for every SELECT you do.

By the way, do not depend on the format of EXPLAIN QUERY PLAN in a production system. It's intended for programmers only. The things it returns can change between versions of SQLite.