Jessi Berkelhammer <jberkelhammer(at)desc(dot)org> writes:
> The hold-up seems to be in a 'Nested Loop Left Join', which is only in
> the plan for the slow query.
> Here are the first two lines of EXPLAIN ANALYZE on the slow query:
So you've left out all the information that would let anyone guess what
the problem is ...
Let's see the *whole* EXPLAIN ANALYZE output for all three of the
queries you mentioned. It would also be appropriate to mention
exactly which PG version you're using.
regards, tom lane