Postgres Pro
Downloads
Home   >   mailing lists

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

From Piotr Gasidło
Subject Difference between EXPLAIN ANALYZE SELECT ... total runtime and SELECT ... runtime
Date
Msg-id AANLkTinPGuJwr3TPy70WyCTXSanDtxoeJlNTSNLFXquT@mail.gmail.com
Whole thread Raw
Responses Re: Difference between EXPLAIN ANALYZE SELECT ... total runtime and SELECT ... runtime  (Szymon Guz <mabewlun@gmail.com>)
Re: Difference between EXPLAIN ANALYZE SELECT ... total runtime and SELECT ... runtime  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: Clarification of the "simple" dictionary
Next
From: Szymon Guz
Date:
Subject: Re: Difference between EXPLAIN ANALYZE SELECT ... total runtime and SELECT ... runtime