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

From: Piotr Gasidło <quaker(at)barbara(dot)eu(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Difference between EXPLAIN ANALYZE SELECT ... total runtime and SELECT ... runtime
Date: 2010-07-22 19:24:52
Message-ID: AANLkTinPGuJwr3TPy70WyCTXSanDtxoeJlNTSNLFXquT@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Oleg Bartunov 2010-07-22 19:28:13 Re: Clarification of the "simple" dictionary
Previous Message Geoffrey 2010-07-22 19:23:28 Re: locating cities within a radius of another