Re: Running explain analyze in a transaction

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.

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.

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
>