"Dave North" <dno...@signiant.com> writes:
> The outstanding question here is why does the explain analyze take
> (quite a bit) longer than just executing the query?
EXPLAIN ANALYZE has nontrivial measurement overhead, especially on
platforms with slow gettimeofday(). Old/cheap PC hardware, in particular,
tends to suck in this respect.
regards, tom lane
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
