Re: Running explain analyze in a transaction

Поиск
Список
Период
Сортировка
От Guillaume Lelarge
Тема Re: Running explain analyze in a transaction
Дата
Msg-id CAECtzeWVK=fz9TSmi_Z-UjCpH6thK+BCNTrK6_1i8DAB2pikLw@mail.gmail.com
обсуждение исходный текст
Ответ на Running explain analyze in a transaction  (Tim Uckun <timuckun@gmail.com>)
Ответы Re: Running explain analyze in a transaction
Список pgadmin-support
Дерево обсуждения
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 по дате отправления:

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