Nested Loop (cost=0.00..499.16 rows=1 width=32) Join Filter: true -> Seq Scan on bar (cost=0.00..431.01 rows=334 width=12) -> Result (cost=0.00..68.14 rows=1 width=20) -> Sequence (cost=0.00..68.14 rows=1 width=16) -> Partition Selector for foo (dynamic scan id: 1) (cost=10.00..100.00 rows=34 width=4) Partitions selected: 5 (out of 5) -> Dynamic Bitmap Heap Scan on foo (dynamic scan id: 1) (cost=0.00..68.14 rows=1 width=16) Recheck Cond: (dist_a = bar.dist_e) Filter: (bar.f = b) -> Dynamic Bitmap Index Scan on foo_idx_ad (cost=0.00..0.00 rows=0 width=0) Index Cond: (dist_a = bar.dist_e) ]]>