Dave Cole <davejohncole(at)gmail(dot)com> writes:
> It would be really cool if you could direct the EXPLAIN ANALYZE output to a
> temporary table so that the query being analyzed could execute normally.
What happens if the current transaction rolls back?
If you want noninvasive explain data, contrib/auto_explain offers
a solution right now. The info goes to the postmaster log, which is
perhaps less convenient than a temp table for interactive use, but
it doesn't have the rollback problem --- and you can capture data
about queries issued by a live application, without hacking the app.
regards, tom lane