Postgres Pro
Downloads
Home   >   mailing lists

Re: Difference between EXPLAIN ANALYZE SELECT ... total runtime and SELECT ... runtime - Mailing list pgsql-general

From Szymon Guz
Subject Re: Difference between EXPLAIN ANALYZE SELECT ... total runtime and SELECT ... runtime
Date
Msg-id AANLkTiltoNxT2K_LH6vi3NxRggIQP2dbzyVcvMbSBmwi@mail.gmail.com
Whole thread Raw
In response to Difference between EXPLAIN ANALYZE SELECT ... total runtime and SELECT ... runtime  (Piotr Gasidło <quaker@barbara.eu.org>)
Responses Re: Difference between EXPLAIN ANALYZE SELECT ... total runtime and SELECT ... runtime  (Piotr Gasidło <quaker@barbara.eu.org>)
List pgsql-general
Tree view


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 by date:

Previous
From: Piotr Gasidło
Date:
Subject: Difference between EXPLAIN ANALYZE SELECT ... total runtime and SELECT ... runtime
Next
From: John Gage
Date:
Subject: Re: Clarification of the "simple" dictionary