Re: Interpreting EXPLAIN ANALYSE

Поиск
Список
Период
Сортировка
От Henry C.
Тема Re: Interpreting EXPLAIN ANALYSE
Дата
Msg-id 53b26a55cd89566003801a85518895da.squirrel@zenmail.co.za
обсуждение исходный текст
Ответ на Re: Interpreting EXPLAIN ANALYSE  (tv@fuzzy.cz)
Ответы Re: Interpreting EXPLAIN ANALYSE  (tv@fuzzy.cz)
Список pgsql-general
On Fri, June 3, 2011 13:57, tv@fuzzy.cz wrote:
> There's something very wrong with snames - the planner expects 22 rows but
> gets 164147851. Which probably causes a bad plan choice or something like that.
> Try to analyze the snames table (and maybe increase the statistics
> target on the columns).

ANALYZE is your friend indeed, like a nice cold beer...  from over 500k ms to
1 ms.

I was running ANALYZE on one of the tables in the join, but not the others...
<sigh>


В списке pgsql-general по дате отправления:

Предыдущее
От: David Boreham
Дата:
Сообщение: Re: Mixed up protocol packets in server response?
Следующее
От: tv@fuzzy.cz
Дата:
Сообщение: Re: Interpreting EXPLAIN ANALYSE