"Dave North" <DNorth@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