Postgres Pro
Downloads
Home   >   mailing lists

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 CAECtzeWVK=fz9TSmi_Z-UjCpH6thK+BCNTrK6_1i8DAB2pikLw@mail.gmail.com
Whole thread Raw
In response to Running explain analyze in a transaction  (Tim Uckun <timuckun@gmail.com>)
Responses Re: Running explain analyze in a transaction  (Tim Uckun <timuckun@gmail.com>)
List pgadmin-support
Tree view
Hi,

2015-04-10 1:13 GMT+02:00 Tim Uckun <timuckun@gmail.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.


--

pgadmin-support by date:

Previous
From: Tim Uckun
Date:
Subject: Running explain analyze in a transaction
Next
From: Melvin Davidson
Date:
Subject: Re: Running explain analyze in a transaction