Re: ToDo: log plans of cancelled queries

Stephen Frost <sfrost@snowman.net>

From: Stephen Frost <sfrost@snowman.net>
To: Pavel Stehule <pavel.stehule@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2013-01-11T16:15:13Z
Lists: pgsql-hackers
* Pavel Stehule (pavel.stehule@gmail.com) wrote:
> 2013/1/11 Stephen Frost <sfrost@snowman.net>:
> > Why not an option to auto_explain (or whatever) to log an execution plan
> > right before actually executing it?  If that was something which could
> > be set with a GUC or similar, you could just do that before running
> > whatever queries you're interested in capturing the plans for.
> 
> for our OLAP usage it is probably possible, but it can be slow for OLTP usage..

If it was a GUC, you could turn it on/off at appropriate places in the
OLTP scenario.

	Thanks,

		Stephen