Re: Running explain analyze in a transaction

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Tim Uckun <timuckun(at)gmail(dot)com>
Cc: "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Running explain analyze in a transaction
Date: 2015-04-10 14:50:52
Message-ID: CAECtzeWVK=fz9TSmi_Z-UjCpH6thK+BCNTrK6_1i8DAB2pikLw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Melvin Davidson 2015-04-10 18:32:12 Re: Running explain analyze in a transaction
Previous Message Tim Uckun 2015-04-09 23:13:36 Running explain analyze in a transaction