Re: Extremely slow HashAggregate in simple UNION query

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Extremely slow HashAggregate in simple UNION query
Дата
Msg-id 6839.1566675663@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Extremely slow HashAggregate in simple UNION query  (Jeff Janes <jeff.janes@gmail.com>)
Ответы Re: Extremely slow HashAggregate in simple UNION query
Список pgsql-performance
Jeff Janes <jeff.janes@gmail.com> writes:
> Most of the time is not after the clock stops, but before the stepwise
> ANALYZE clock starts.  If you just do an EXPLAIN rather than EXPLAIN
> ANALYZE, that is also slow.  The giant hash table is created during the
> planning step (or somewhere around there

It's in executor startup, I believe.

            regards, tom lane



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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: Extremely slow HashAggregate in simple UNION query
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Extremely slow HashAggregate in simple UNION query