Jessi Berkelhammer <jberkelhammer@xxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
