=?iso-8859-2?Q?Artur_Zaj=B1c?= <azajac@xxxxxxxxxx> writes: > Why there is so big difference between explain analyze (0.710 ms) and real > execution time (3309 ms)? EXPLAIN ANALYZE doesn't account for all of the runtime involved. In this case, I'd bet that session startup/shutdown is a big part of the difference. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance