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 <timuckun@gmail.com>) |
| Список | pgadmin-support |
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
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;В списке pgadmin-support по дате отправления: