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 7142.1289855035@sss.pgh.pa.us
Whole thread Raw
In response to Re: 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 
=?iso-8859-2?Q?Artur_Zaj=B1c?= <azajac@ang.com.pl> writes:
> I've changed default_statistics_target to 10000 and I think that is a
> reason.

That's certainly going to cost you something, but this seems like a
mighty large slowdown, especially for a non-join query.  What datatype
is te.idtr, anyway?

            regards, tom lane

pgsql-performance by date:

Previous
From: Artur Zając
Date:
Subject: Re: Difference between explain analyze and real execution time
Next
From: Artur Zając
Date:
Subject: Re: Difference between explain analyze and real execution time