Re: ToDo: log plans of cancelled queries - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: ToDo: log plans of cancelled queries
Date
Msg-id CAFj8pRD+wtUY+bWmRMJo3b9PDoc0_MdjLsS0w2C04toTZLiYQQ@mail.gmail.com
Whole thread Raw
In response to Re: ToDo: log plans of cancelled queries  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
2013/1/11 Stephen Frost <sfrost@snowman.net>:
> * 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.

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



pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: ToDo: log plans of cancelled queries
Next
From: Stephen Frost
Date:
Subject: Re: ToDo: log plans of cancelled queries