nomad at null.net wrote: > I wanted to see how SELECT queries within triggers are using indexes > (or not) which of course lead me to https://www.sqlite.org/eqp.html: > > EXPLAIN QUERY PLAN is most useful on a SELECT statement, but may > also be appear with other statements that read data from database > tables (e.g. UPDATE, DELETE, INSERT INTO ... SELECT).
That page does not mention triggers. > However I don't get any output from EQP on non-SELECT queries: > explain query plan insert into t(a,b) values(4,4); > -- No output! explain query plan insert into t(a,b) select * from (select 4, 4); 0|0|0|SCAN SUBQUERY 1 > Is there some way to see what my triggers are doing? Well, there is EXPLAIN, which is probably not very useful. Regards, Clemens
