Postgres Pro
Downloads
Home   >   mailing lists

Re: Capturing EXPLAIN ANALYZE for a query without discarding the normal result set - Mailing list pgsql-hackers

From Marti Raudsepp
Subject Re: Capturing EXPLAIN ANALYZE for a query without discarding the normal result set
Date
Msg-id CABRT9RDcYRT1JV7Lo-YwVzw2SLGCYq9cZqt-7urTsQy8d8yQDQ@mail.gmail.com
Whole thread Raw
In response to Capturing EXPLAIN ANALYZE for a query without discarding the normal result set  (Dave Cole <davejohncole@gmail.com>)
Responses Re: Capturing EXPLAIN ANALYZE for a query without discarding the normal result set  (Marti Raudsepp <marti@juffo.org>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Dave Cole
Date:
Subject: Capturing EXPLAIN ANALYZE for a query without discarding the normal result set
Next
From: Tom Lane
Date:
Subject: Re: Capturing EXPLAIN ANALYZE for a query without discarding the normal result set