cheapest total path: NestLoop(ct it mc mi_idx t) rows=111 cost=16318.71..54239.03 clauses: mc.movie_id = t.id Gather(ct it mc mi_idx) rows=111 cost=16318.28..54173.49 HashJoin(ct it mc mi_idx) rows=46 cost=15318.28..53162.39 clauses: mc.company_type_id = ct.id HashJoin(it mc mi_idx) rows=185 cost=15317.21..53160.33 clauses: mc.movie_id = mi_idx.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))