W dniu 22 lipca 2010 21:24 użytkownik Piotr Gasidło <quaker@xxxxxxxxxxxxxx> 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
