Postgres Pro
Downloads
Home   >   mailing lists

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

From Tim Uckun
Subject Running explain analyze in a transaction
Date
Msg-id CAGuHJrNRhbi6zcuy=-k2RFsemuugDy1M=WRRsh-wGiARMHk-+g@mail.gmail.com
Whole thread Raw
Responses Re: Running explain analyze in a transaction  (Guillaume Lelarge <guillaume@lelarge.info>)
Re: Running explain analyze in a transaction  (Melvin Davidson <melvin6925@yahoo.com>)
List pgadmin-support
Tree view
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?

pgadmin-support by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: Enabling debugger plugin on pgAdmin III
Next
From: Guillaume Lelarge
Date:
Subject: Re: Running explain analyze in a transaction