this:
begin;
explain select * from catalog_items limit 5;
commit;
return this:
-- Executing query:
begin;
explain select * from catalog_items limit 5;
commit;
Query result with 2 rows discarded.
Query returned successfully with no result in 58 ms.
I'm interested in explain inside a transaction because:
1) the query I'd like to explain depends on previous statements
2) it modify the DB and I'd like to keep a consistent state. If the
following queries fail I'd like to roll it back.
explain analyze doesn't make any difference in the output.
I didn't find anything in the log.
Any alternative approach?
--
Ivan Sergio Borgonovo
http://www.webthatworks.it