In my dreams the plan would be something like this:
Nested Loop
-> Index Scan using dealers_pkey on dealers
Index Cond: (id = ANY ('{54,12,456,315,468}'::integer[]))
-> Append
-> Bitmap Heap Scan on bikes
Recheck Cond: (dealer_name =
dealers.name)
Filter: (frame_size = 52)
Rows Removed by Filter: 91
-> Bitmap Index Scan on bikes_dealer_name_idx
Index Cond: (dealer_name =
dealers.name)
-> Bitmap Heap Scan on cars
Recheck Cond: (dealer_name =
dealers.name)
-> Bitmap Index Scan on cars_dealer_name_idx
Index Cond: (dealer_name =
dealers.name)