From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Stephen Frost <sfrost(at)snowman(dot)net> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: ToDo: log plans of cancelled queries |
Date: | 2013-01-11 16:20:39 |
Message-ID: | CAFj8pRALMbnwHgrceC3vw98ZmhuCmW7wUGk7AzBncALp2JnCnw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
2013/1/11 Stephen Frost <sfrost(at)snowman(dot)net>:
> * Pavel Stehule (pavel(dot)stehule(at)gmail(dot)com) wrote:
>> 2013/1/11 Stephen Frost <sfrost(at)snowman(dot)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.
yes, it is possible solution
Pavel
>
> Thanks,
>
> Stephen
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2013-01-11 16:24:11 | Re: ToDo: log plans of cancelled queries |
Previous Message | Tom Lane | 2013-01-11 16:20:23 | Re: ToDo: log plans of cancelled queries |