Re: Capturing EXPLAIN ANALYZE for a query without discarding the normal result set

On Tue, Jan 14, 2014 at 5:06 AM, Dave Cole <davejohncole@gmail.com> wrote:
> 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.

You can use the auto_explain contrib module to log the query plans of
slow(er) queries:
http://www.postgresql.org/docs/current/static/auto-explain.html

If you Really Need To, you can use the csvlog log format and import
that to a table, but really it's easier to use less/grep/etc.

Regards,
Marti