"Jeremy Haile" <jhaile(at)fastmail(dot)fm> writes:
> I have a query made by joining two subqueries where the outer query
> performing the join takes significantly longer to run than the two
> subqueries.
Please show EXPLAIN ANALYZE results, not just EXPLAIN.
Also, have you analyzed your tables recently?
regards, tom lane