Re: Running explain analyze in a transaction

Le 11 avr. 2015 01:44, "Tim Uckun" <timuckun(at)gmail(dot)com> a écrit :
>
> I have been it in two steps but sometimes I jump on to another task and
forget that I have an open transaction and shut down the app.
>

This shouldn't be an issue because the rollback is automatic this way.

> Anyway I would like to request a feature to let me see intermediate
results because for me anyway it's not unusual to chain multiple statements
together.
>

That feature is frequently asked, quite possible, but hard to do. Mostly on
the UI part. You need to find someone quite motivated and who has time on
his hands.

> Thanks.
>
> On Sat, Apr 11, 2015 at 2:50 AM, Guillaume Lelarge <guillaume(at)lelarge(dot)info>
wrote:
>>
>> Hi,
>>
>> 2015-04-10 1:13 GMT+02:00 Tim Uckun <timuckun(at)gmail(dot)com>:
>>>
>>> I want to to do the following.
>>>
>>> begin;
>>> explain analyze blah
>>> rollback;
>>>
>>> If I do this I don't get the results of the analyze.
>>>
>>> I have been resorting to commenting out the rollback and running it
separately but it's a bit of a pain.
>>>
>>> Is there an easier way to do this?
>>>
>>
>> Nope. The query tool gets the result of the last query only. So you need
to do it in two steps.
>>
>>
>> --
>> Guillaume.
>> http://blog.guillaume.lelarge.info
>> http://www.dalibo.com
>
>