Re: Difference between explain analyze and real execution time

Поиск
Список
Период
Сортировка
Искать
От
Robert Haas
Тема
Re: Difference between explain analyze and real execution time
Дата
Msg-id
AANLkTim=wpohtfWkNx-=22jcagXndrfTwjvogNt9=f0D@mail.gmail.com
Ответ на
Difference between explain analyze and real execution time (Artur Zając)
Список
Дерево обсуждения
Difference between explain analyze and real execution time Artur Zając <azajac@ang.com.pl>
Re: Difference between explain analyze and real execution time Tom Lane <tgl@sss.pgh.pa.us>
Re: Difference between explain analyze and real execution time Artur Zając <azajac@ang.com.pl>
Re: Difference between explain analyze and real execution time Tobias Brox <tobixen@gmail.com>
Re: Difference between explain analyze and real execution time Robert Haas <robertmhaas@gmail.com>
Re: Difference between explain analyze and real execution time Artur Zając <azajac@ang.com.pl>
Re: Difference between explain analyze and real execution time Tom Lane <tgl@sss.pgh.pa.us>
Re: Difference between explain analyze and real execution time Artur Zając <azajac@ang.com.pl> 
2010/11/15 Artur Zając :
> Why there is so big difference between explain analyze (0.710 ms) and real
> execution time (3309 ms)? Any suggestions?

Could it be that it takes a long time to plan for some reason?  How
fast is a plain EXPLAIN?

What happens if you start up psql, turn on \timing, and then run
EXPLAIN ANALYZE from within an interactive session?  That's usually a
better way to test, as it avoids counting the session-startup
overhead.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
В списке pgsql-performance по дате отправления
Предыдущее
От: Robert Haas
Дата:
Следующее
От: Artur Zając
Дата:
FAQ