Postgres Pro
Downloads
Home   >   mailing lists

Re: Difference between explain analyze and real execution time - Mailing list pgsql-performance

From Robert Haas
Subject Re: Difference between explain analyze and real execution time
Date
Msg-id AANLkTim=wpohtfWkNx-=22jcagXndrfTwjvogNt9=f0D@mail.gmail.com
Whole thread Raw
In response to Difference between explain analyze and real execution time  (Artur Zając <azajac@ang.com.pl>)
Responses Re: Difference between explain analyze and real execution time  (Artur Zając <azajac@ang.com.pl>)
List pgsql-performance
Tree view 
2010/11/15 Artur Zając <azajac@ang.com.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

pgsql-performance by date:

Previous
From: Robert Haas
Date:
Subject: Re: Running PostgreSQL as fast as possible no matter the consequences
Next
From: Artur Zając
Date:
Subject: Re: Difference between explain analyze and real execution time