Re: EXPLAIN ANALYZE much slower than running query normally

Am Dienstag, 5. Oktober 2004 08:49 schrieb Chris Hutchinson:
> Running a trivial query in v7.4.2 (installed with fedora core2) using
> EXPLAIN ANALYZE is taking considerably longer than just running the query
> (2mins vs 6 secs). I was using this query to quickly compare a couple of
> systems after installing a faster disk.
>
> Is this sort of slowdown to be expected?

no.

did you run VACCUM ANALYZE before? you should do it after pg_restore your db
to a new filesystem

in which order did you ran the queries. If you start your server and run two
equal queries, the second one will be much faster because of some or even all
data needed to answer the query is still in the shared buffers.

janning