2010/11/15 Artur Zając <azajac(at)ang(dot)com(dot)pl>:
> Why there is so big difference between explain analyze (0.710 ms) and real
> execution time (3309 ms)? Any suggestions?
Could it be that it takes a long time to plan for some reason? How
fast is a plain EXPLAIN?
What happens if you start up psql, turn on \timing, and then run
EXPLAIN ANALYZE from within an interactive session? That's usually a
better way to test, as it avoids counting the session-startup
overhead.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company