Re: oddly slow query

Jessi Berkelhammer <jberkelhammer@desc.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