Hash Join (cost=0.00..1324604.40 rows=246 width=28)
Hash Cond: bar.d = part.b
-> Table Scan on bar (cost=0.00..431.06 rows=3034 width=8)
-> Hash (cost=1324172.57..1324172.57 rows=270 width=20)
-> Redistribute Motion 3:3 (slice2; segments: 3) (cost=0.00..1324172.57 rows=270 width=20)
Hash Key: part.b
-> Nested Loop (cost=0.00..1324172.56 rows=270 width=20)
Join Filter: part.c >= to_char(jazz.f, '999'::text)::integer AND part.c <= to_char(jazz.f, '999'::text)::integer
-> Partition Selector for part (dynamic scan id: 1) (cost=10.00..100.00 rows=34 width=4)
-> Broadcast Motion 3:3 (slice1; segments: 3) (cost=0.00..431.00 rows=1 width=8)
-> Table Scan on jazz (cost=0.00..431.00 rows=1 width=8)
-> Dynamic Table Scan on part (dynamic scan id: 1) (cost=0.00..431.02 rows=949 width=12)
]]>