Re: Running explain analyze in a transaction

Поиск
Список
Период
Сортировка
Искать
От
Melvin Davidson
Тема
Re: Running explain analyze in a transaction
Дата
Msg-id
484938569.577213.1428690732561.JavaMail.yahoo@mail.yahoo.com
Ответ на
Running explain analyze in a transaction (Tim Uckun)
Список
Дерево обсуждения
Running explain analyze in a transaction Tim Uckun <timuckun@gmail.com>
Re: Running explain analyze in a transaction Melvin Davidson <melvin6925@yahoo.com>
Re: Running explain analyze in a transaction Guillaume Lelarge <guillaume@lelarge.info>
Re: Running explain analyze in a transaction Tim Uckun <timuckun@gmail.com>
Re: Running explain analyze in a transaction Guillaume Lelarge <guillaume@lelarge.info>
What you need to do is leave off ROLLBACK until
you examine the output.

Or perhaps just redirect the output to capture the results.

IE:
\o some_result_file
BEGIN;
EXPLAIN ANALYZE blah;
ROLLBACK;

However, perhaps a better thing to do is just leave out the ANALYZE as that is what causes the execution and only adds timing to the results.
 
Melvin Davidson


Folk Alley - All Folk - 24 Hours a day
www.folkalley.com


From: Tim Uckun <timuckun@gmail.com>
To: "pgadmin-support@postgresql.org" <pgadmin-support@postgresql.org>
Sent: Thursday, April 9, 2015 7:13 PM
Subject: [pgadmin-support] Running explain analyze in a transaction

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 по дате отправления
Предыдущее
От: Guillaume Lelarge
Дата:
Следующее
От: Tim Uckun
Дата:
FAQ