Re: Running explain analyze in a transaction

Поиск
Список
Период
Сортировка
От Tim Uckun
Тема Re: Running explain analyze in a transaction
Дата
Msg-id CAGuHJrOaGwAA=sS-LJfUT7GJgXrMYxOvx56JcxzM8GSsahCTEg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Running explain analyze in a transaction  (Guillaume Lelarge <guillaume@lelarge.info>)
Ответы Re: Running explain analyze in a transaction  (Guillaume Lelarge <guillaume@lelarge.info>)
Список pgadmin-support
Дерево обсуждения
I have been it in two steps but sometimes I jump on to another task and forget that I have an open transaction and shut down the app.

Anyway I would like to request a feature to let me see intermediate results because for me anyway it's not unusual to chain multiple statements together.

Thanks.

On Sat, Apr 11, 2015 at 2:50 AM, Guillaume Lelarge <guillaume@lelarge.info> wrote:
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 по дате отправления:

Предыдущее
От: Melvin Davidson
Дата:
Сообщение: Re: Running explain analyze in a transaction
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: Running explain analyze in a transaction