Re: Difference between explain analyze and real execution time

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Difference between explain analyze and real execution time
Дата
Msg-id 13814.1289833979@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Difference between explain analyze and real execution time  (Artur Zając <azajac@ang.com.pl>)
Ответы Re: Difference between explain analyze and real execution time
Re: Difference between explain analyze and real execution time
Список pgsql-performance
Дерево обсуждения 
=?iso-8859-2?Q?Artur_Zaj=B1c?= <azajac@ang.com.pl> writes:
> Why there is so big difference between explain analyze (0.710 ms) and real
> execution time (3309 ms)?

EXPLAIN ANALYZE doesn't account for all of the runtime involved.  In
this case, I'd bet that session startup/shutdown is a big part of the
difference.

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Running PostgreSQL as fast as possible no matter the consequences
Следующее
От: Artur Zając
Дата:
Сообщение: Re: Difference between explain analyze and real execution time