Re: Extremely slow HashAggregate in simple UNION query - Mailing list 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