2 ---------------------------------------------------------------------------
3 Merge Join (cost=xxx rows=100 width=19)
4 Merge Cond: (t1.c1 = t2.c1)
5 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1000 width=15)
6 -> Sort (cost=xxx rows=100 width=4)
8 -> Seq Scan on t2 (cost=xxx rows=100 width=4)
12 ---------------------------------------------------------------------------
13 Merge Join (cost=xxx rows=100 width=19)
14 Merge Cond: (t1.c1 = t2.c1)
15 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1000 width=15)
16 -> Sort (cost=xxx rows=100 width=4)
18 -> Seq Scan on t2 (cost=xxx rows=100 width=4)
22 ---------------------------------------------------------------------------
23 Merge Join (cost=xxx rows=1 width=19)
24 Merge Cond: (t1.c1 = t2.c1)
25 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1000 width=15)
26 -> Sort (cost=xxx rows=100 width=4)
28 -> Seq Scan on t2 (cost=xxx rows=100 width=4)