"Scott Carey" <scott@richrelevance.com> writes:
> Under what conditions does EXPLAIN ANALYZE report spilling work_mem to
> disk?
For hash joins, it doesn't. You might be thinking of the additional
reporting we added for sorts recently; but there's no comparable
logging for hash ...
regards, tom lane