Skip site navigation (1) Skip section navigation (2)

Re: Difference between explain analyze and real execution time

From: Artur Zając <azajac(at)ang(dot)com(dot)pl>
To: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "'Robert Haas'" <robertmhaas(at)gmail(dot)com>,<pgsql-performance(at)postgresql(dot)org>
Subject: Re: Difference between explain analyze and real execution time
Date: 2010-11-15 21:30:32
Message-ID: 009f01cb850c$55f962e0$01ec28a0$@ang.com.pl (view raw or flat)
Thread:
Lists: pgsql-performance

> 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?

Integer not null and primary key of t_positions table.

Table t_positions has about 1500000 records, table t_st about 130000
records.


-------------------------------------------
Artur Zajac



In response to

pgsql-performance by date

Next:From: Jayadevan MDate: 2010-11-16 07:00:54
Subject: Re:
Previous:From: Tom LaneDate: 2010-11-15 21:03:55
Subject: Re: Difference between explain analyze and real execution time

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group