Brendan Curran <brendan.curran@gmail.com> writes:
> So much time is being spent in the Unique and Sort leaves... I would
> think that it wouldn't need to do the unique portion, since there is no
> DISTINCT clause...
There's nothing in that query suggesting that suppress.email is unique.
If you know that it is, try using a plain join instead of an IN.
regards, tom lane