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