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) ]]>