Re: Extremely slow HashAggregate in simple UNION query

Tom Lane <[email protected]>
Newsgroups gmane.comp.db.postgresql.performance
Message-ID <[email protected]> 
Jeff Janes <[email protected]> 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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.