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

From: Szymon Guz <mabewlun(at)gmail(dot)com>
To: Piotr Gasidło <quaker(at)barbara(dot)eu(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Difference between EXPLAIN ANALYZE SELECT ... total runtime and SELECT ... runtime
Date: 2010-07-22 19:34:00
Message-ID: AANLkTiltoNxT2K_LH6vi3NxRggIQP2dbzyVcvMbSBmwi@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

W dniu 22 lipca 2010 21:24 użytkownik Piotr Gasidło
<quaker(at)barbara(dot)eu(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Gage 2010-07-22 19:38:22 Re: Clarification of the "simple" dictionary
Previous Message Oleg Bartunov 2010-07-22 19:28:13 Re: Clarification of the "simple" dictionary