Re: Running explain analyze in a transaction - Mailing list pgadmin-support

From Guillaume Lelarge
Subject Re: Running explain analyze in a transaction
Date
Msg-id CAECtzeUKi3B4zFTox1yq9aRP34jXfSfdpzHUgsRFKvj_De=kTg@mail.gmail.com
Whole thread Raw
In response to Re: Running explain analyze in a transaction  (Tim Uckun <timuckun@gmail.com>)
List pgadmin-support
<p dir="ltr">Le 11 avr. 2015 01:44, "Tim Uckun" <<a href="mailto:timuckun@gmail.com">timuckun@gmail.com</a>> a
écrit :<br/> ><br /> > I have been it in two steps but sometimes I jump on to another task and forget that I have
anopen transaction and shut down the app. <br /> ><p dir="ltr">This shouldn't be an issue because the rollback is
automaticthis way.<p dir="ltr">> Anyway I would like to request a feature to let me see intermediate results because
forme anyway it's not unusual to chain multiple statements together.<br /> ><p dir="ltr">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
onhis hands.<p dir="ltr">> Thanks.<br /> ><br /> > On Sat, Apr 11, 2015 at 2:50 AM, Guillaume Lelarge <<a
href="mailto:guillaume@lelarge.info">guillaume@lelarge.info</a>>wrote:<br /> >><br /> >> Hi,<br />
>><br/> >> 2015-04-10 1:13 GMT+02:00 Tim Uckun <<a
href="mailto:timuckun@gmail.com">timuckun@gmail.com</a>>:<br/> >>><br /> >>> I want to to do the
following.<br/> >>><br /> >>> begin;<br /> >>> explain analyze blah<br /> >>>
rollback;<br/> >>><br /> >>> If I do this I don't get the results of the analyze.<br />
>>><br/> >>> I have been resorting to commenting out the rollback and running it separately but it's
abit of a pain.<br /> >>><br /> >>> Is there an easier way to do this?<br /> >>><br />
>><br/> >> Nope. The query tool gets the result of the last query only. So you need to do it in two
steps.<br/> >><br /> >><br /> >> -- <br /> >> Guillaume.<br /> >>   <a
href="http://blog.guillaume.lelarge.info">http://blog.guillaume.lelarge.info</a><br/> >>   <a
href="http://www.dalibo.com">http://www.dalibo.com</a><br/> ><br /> ><br /> 

pgadmin-support by date:

Previous
From: Tim Uckun
Date:
Subject: Re: Running explain analyze in a transaction
Next
From: Sergey P
Date:
Subject: PgAdmin 1.20 crash on start(OS X 10.10.1)