cheapest total path: NestLoop(ct it mc mi_idx t) rows=111 cost=16318.71..54273.73 clauses: mc.movie_id = t.id HashJoin(ct it mc mi_idx) rows=111 cost=16318.28..54208.19 clauses: mc.company_type_id = ct.id Gather(it mc mi_idx) rows=444 cost=16317.21..54204.73 HashJoin(it mc mi_idx) rows=185 cost=15317.21..53160.33 clauses: mi_idx.movie_id = mc.movie_id SeqScan(mc) rows=7320 cost=0.00..37814.90 HashJoin(it mi_idx) rows=5089 cost=2.43..15253.60 clauses: it.id = mi_idx.info_type_id SeqScan(mi_idx) rows=575015 cost=0.00..13685.15 SeqScan(it) rows=1 cost=0.00..2.41 SeqScan(ct) rows=1 cost=0.00..1.05 IdxScan(t) required_outer (mi_idx) rows=1 cost=0.43..0.58 pathkeys: ((t.id, mc.movie_id, mi_idx.movie_id))