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

Поиск
Список
Период
Сортировка
От Piotr Gasidło
Тема Difference between EXPLAIN ANALYZE SELECT ... total runtime and SELECT ... runtime
Дата
Msg-id AANLkTinPGuJwr3TPy70WyCTXSanDtxoeJlNTSNLFXquT@mail.gmail.com
обсуждение исходный текст
Ответы Re: Difference between EXPLAIN ANALYZE SELECT ... total runtime and SELECT ... runtime
Re: Difference between EXPLAIN ANALYZE SELECT ... total runtime and SELECT ... runtime
Список pgsql-general
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.

--
Piotr Gasidło

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