Re: Difference between EXPLAIN ANALYZE SELECT ... total runtime and SELECT ... runtime

Поиск
Список
Период
Сортировка
От Szymon Guz
Тема Re: Difference between EXPLAIN ANALYZE SELECT ... total runtime and SELECT ... runtime
Дата
Msg-id AANLkTiltoNxT2K_LH6vi3NxRggIQP2dbzyVcvMbSBmwi@mail.gmail.com
обсуждение исходный текст
Ответ на Difference between EXPLAIN ANALYZE SELECT ... total runtime and SELECT ... runtime  (Piotr Gasidło <quaker@barbara.eu.org>)
Ответы Re: Difference between EXPLAIN ANALYZE SELECT ... total runtime and SELECT ... runtime  (Piotr Gasidło <quaker@barbara.eu.org>)
Список pgsql-general
Дерево обсуждения


W dniu 22 lipca 2010 21:24 użytkownik Piotr Gasidło <quaker@barbara.eu.org> napisał:
Hello,

I have strange problem.

I test/optimize my queries with EXPLAIN ANALYZE. I get for example:

Total runtime: 40.794 ms

But when I run query without EXPLAIN ANALYZE i get, for example:

Time: 539.252 ms

Query returns 33 rows. Why?

I do checks with psql connected using socket to postgresql server. No SSL.

Using PostgreSQL 8.4.4.


Hi,
maybe the query waits on a lock or maybe the returned rows are very big.

regards
Szymon Guz

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

Предыдущее
От: Piotr Gasidło
Дата:
Сообщение: Difference between EXPLAIN ANALYZE SELECT ... total runtime and SELECT ... runtime
Следующее
От: John Gage
Дата:
Сообщение: Re: Clarification of the "simple" dictionary