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