Re: [PERFORM] sub-select in IN clause results in sequential scan

[Grzegorz Jaśkiewicz]

for explains, use http://explain.depesz.com/
besides, why are you using left join ?

equivlent of IN () is just JOIN, not LEFT JOIN.

And please, format your query so it readable without twisting eyeballs
before sending.