2013/1/11 Stephen Frost <sfr...@snowman.net>: > * Pavel Stehule (pavel.steh...@gmail.com) wrote: >> 2013/1/11 Stephen Frost <sfr...@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.
but still - if this is a auto_explain feature - then we need to return execution to auto_explain after cancelled query - and it is probably impossible now Regards Pavel > > Thanks, > > Stephen -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers