Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Difference between explain analyze and real execution time
Date
Msg-id 13814.1289833979@sss.pgh.pa.us
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>)
Re: Difference between explain analyze and real execution time  (Tobias Brox <tobixen@gmail.com>)
List pgsql-performance
Tree view 
=?iso-8859-2?Q?Artur_Zaj=B1c?= <azajac@ang.com.pl> writes:
> Why there is so big difference between explain analyze (0.710 ms) and real
> execution time (3309 ms)?

EXPLAIN ANALYZE doesn't account for all of the runtime involved.  In
this case, I'd bet that session startup/shutdown is a big part of the
difference.

            regards, tom lane

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