Re: Difference between explain analyze and real execution time

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Difference between explain analyze and real execution time
Дата
Msg-id 7142.1289855035@sss.pgh.pa.us
обсуждение исходный текст
Ответ на 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
Список pgsql-performance
Дерево обсуждения 
=?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 по дате отправления:

Предыдущее
От: Artur Zając
Дата:
Сообщение: Re: Difference between explain analyze and real execution time
Следующее
От: Artur Zając
Дата:
Сообщение: Re: Difference between explain analyze and real execution time