Open asm0dey opened 2 years ago
This is not so easy since eqp, since it's a special command. One will have to create some "storage" for eqp varaible and probably insert EXPLAIN QUERY PLAN before the query. Once can't just do:
cursor.execute(".eqp on")
The underlying C / Python binding don't allow it.
Do I understand correctly that SQLite doesn't expose these query plans over API and they are somehow hardcoded into the CLI?
I haven't looked into the SQLite code itself. However it's not exposed in the python driver, not even with apsew.
There is an awesome
.eqp on
command in the defaultsqlite3
shell. It works like this:As you can see it outputs the execution plan tree on each request. Would be nice to support it in litecli too