Running explain analyze in a transaction

From: Tim Uckun <timuckun(at)gmail(dot)com>
To: "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
Subject: Running explain analyze in a transaction
Date: 2015-04-09 23:13:36
Message-ID: CAGuHJrNRhbi6zcuy=-k2RFsemuugDy1M=WRRsh-wGiARMHk-+g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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?

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Guillaume Lelarge 2015-04-10 14:50:52 Re: Running explain analyze in a transaction
Previous Message Melvin Davidson 2015-04-08 19:19:04 Re: Enabling debugger plugin on pgAdmin III