QUERY PLAN ----------------------------------------------------------------------------------------------- Aggregate (cost=xxx rows=1 width=4) -> Nested Loop (cost=xxx rows=1 width=4) Join Filter: (t1.c1 = t4.c1) -> Nested Loop (cost=xxx rows=1 width=12) Join Filter: (t1.c1 = t3.c1) -> Merge Join (cost=xxx rows=1 width=8) Merge Cond: (t1.c1 = t2.c1) -> Nested Loop (cost=xxx rows=6 width=4) -> Index Scan using t1_i1 on t1 (cost=xxx rows=1 width=4) Filter: (ctid = '(1,1)'::tid) -> Seq Scan on r3 (cost=xxx rows=6 width=0) Filter: (c1 = 1) -> Sort (cost=xxx rows=1 width=4) Sort Key: t2.c1 -> Seq Scan on t2 (cost=xxx rows=1 width=4) Filter: (ctid = '(1,1)'::tid) -> Tid Scan on t3 (cost=xxx rows=1 width=4) TID Cond: (ctid = '(1,1)'::tid) -> Tid Scan on t4 (cost=xxx rows=1 width=4) TID Cond: (ctid = '(1,1)'::tid) Aggregate (cost=xxx rows=1 width=4) -> Nested Loop (cost=xxx rows=1 width=4) Join Filter: (t1.c1 = t4.c1) -> Nested Loop (cost=xxx rows=1 width=12) Join Filter: (t1.c1 = t3.c1) -> Merge Join (cost=xxx rows=1 width=8) Merge Cond: (t1.c1 = t2.c1) -> Nested Loop (cost=xxx rows=6 width=4) -> Index Scan using t1_i1 on t1 (cost=xxx rows=1 width=4) Filter: (ctid = '(1,1)'::tid) -> Seq Scan on r3 (cost=xxx rows=6 width=0) Filter: (c1 = 1) -> Sort (cost=xxx rows=1 width=4) Sort Key: t2.c1 -> Seq Scan on t2 (cost=xxx rows=1 width=4) Filter: (ctid = '(1,1)'::tid) -> Tid Scan on t3 (cost=xxx rows=1 width=4) TID Cond: (ctid = '(1,1)'::tid) -> Tid Scan on t4 (cost=xxx rows=1 width=4) TID Cond: (ctid = '(1,1)'::tid) Aggregate (cost=xxx rows=1 width=4) -> Nested Loop (cost=xxx rows=1 width=4) Join Filter: (t1.c1 = t4.c1) -> Nested Loop (cost=xxx rows=1 width=12) Join Filter: (t1.c1 = t3.c1) -> Merge Join (cost=xxx rows=1 width=8) Merge Cond: (t1.c1 = t2.c1) -> Nested Loop (cost=xxx rows=6 width=4) -> Index Scan using t1_i1 on t1 (cost=xxx rows=1 width=4) Filter: (ctid = '(1,1)'::tid) -> Seq Scan on r3 (cost=xxx rows=6 width=0) Filter: (c1 = 1) -> Sort (cost=xxx rows=1 width=4) Sort Key: t2.c1 -> Seq Scan on t2 (cost=xxx rows=1 width=4) Filter: (ctid = '(1,1)'::tid) -> Tid Scan on t3 (cost=xxx rows=1 width=4) TID Cond: (ctid = '(1,1)'::tid) -> Tid Scan on t4 (cost=xxx rows=1 width=4) TID Cond: (ctid = '(1,1)'::tid) (62 rows) QUERY PLAN --------------------------------------------------------------------------------- Aggregate (cost=xxx rows=1 width=4) -> Nested Loop (cost=xxx rows=2 width=4) Join Filter: (t1.c1 = t4.c1) -> Tid Scan on t4 (cost=xxx rows=1 width=4) TID Cond: (ctid = '(1,1)'::tid) -> Nested Loop (cost=xxx rows=2 width=12) Join Filter: (t1.c1 = t3.c1) -> Tid Scan on t3 (cost=xxx rows=1 width=4) TID Cond: (ctid = '(1,1)'::tid) -> Nested Loop (cost=xxx rows=2 width=8) Join Filter: (t1.c1 = t2.c1) -> Seq Scan on t2 (cost=xxx rows=1 width=4) Filter: (ctid = '(1,1)'::tid) -> Nested Loop (cost=xxx rows=2 width=4) -> Tid Scan on t1 (cost=xxx rows=1 width=4) TID Cond: (ctid = '(1,1)'::tid) -> Seq Scan on r3 (cost=xxx rows=6 width=0) Filter: (c1 = 1) Aggregate (cost=xxx rows=1 width=4) -> Nested Loop (cost=xxx rows=2 width=4) Join Filter: (t1.c1 = t4.c1) -> Tid Scan on t4 (cost=xxx rows=1 width=4) TID Cond: (ctid = '(1,1)'::tid) -> Nested Loop (cost=xxx rows=2 width=12) Join Filter: (t1.c1 = t3.c1) -> Tid Scan on t3 (cost=xxx rows=1 width=4) TID Cond: (ctid = '(1,1)'::tid) -> Nested Loop (cost=xxx rows=2 width=8) Join Filter: (t1.c1 = t2.c1) -> Seq Scan on t2 (cost=xxx rows=1 width=4) Filter: (ctid = '(1,1)'::tid) -> Nested Loop (cost=xxx rows=2 width=4) -> Tid Scan on t1 (cost=xxx rows=1 width=4) TID Cond: (ctid = '(1,1)'::tid) -> Seq Scan on r3 (cost=xxx rows=6 width=0) Filter: (c1 = 1) Aggregate (cost=xxx rows=1 width=4) -> Nested Loop (cost=xxx rows=2 width=4) Join Filter: (t1.c1 = t4.c1) -> Tid Scan on t4 (cost=xxx rows=1 width=4) TID Cond: (ctid = '(1,1)'::tid) -> Nested Loop (cost=xxx rows=2 width=12) Join Filter: (t1.c1 = t3.c1) -> Tid Scan on t3 (cost=xxx rows=1 width=4) TID Cond: (ctid = '(1,1)'::tid) -> Nested Loop (cost=xxx rows=2 width=8) Join Filter: (t1.c1 = t2.c1) -> Seq Scan on t2 (cost=xxx rows=1 width=4) Filter: (ctid = '(1,1)'::tid) -> Nested Loop (cost=xxx rows=2 width=4) -> Tid Scan on t1 (cost=xxx rows=1 width=4) TID Cond: (ctid = '(1,1)'::tid) -> Seq Scan on r3 (cost=xxx rows=6 width=0) Filter: (c1 = 1) (56 rows) QUERY PLAN ---------------------------------------------------------------------------------------------------- Aggregate (cost=xxx rows=1 width=4) -> Nested Loop (cost=xxx rows=1 width=4) Join Filter: (b1t1.c1 = b1t4.c1) -> Nested Loop (cost=xxx rows=1 width=12) Join Filter: (b1t1.c1 = b1t3.c1) -> Merge Join (cost=xxx rows=1 width=8) Merge Cond: (b1t1.c1 = b1t2.c1) -> Nested Loop (cost=xxx rows=6 width=4) -> Index Scan using t1_i1 on t1 b1t1 (cost=xxx rows=1 width=4) Filter: (ctid = '(1,1)'::tid) -> Seq Scan on r3_ (cost=xxx rows=6 width=0) Filter: (c1 = 1) -> Sort (cost=xxx rows=1 width=4) Sort Key: b1t2.c1 -> Seq Scan on t2 b1t2 (cost=xxx rows=1 width=4) Filter: (ctid = '(1,1)'::tid) -> Tid Scan on t3 b1t3 (cost=xxx rows=1 width=4) TID Cond: (ctid = '(1,1)'::tid) -> Tid Scan on t4 b1t4 (cost=xxx rows=1 width=4) TID Cond: (ctid = '(1,1)'::tid) Aggregate (cost=xxx rows=1 width=4) -> Nested Loop (cost=xxx rows=1 width=4) Join Filter: (b2t1.c1 = b2t4.c1) -> Nested Loop (cost=xxx rows=1 width=12) Join Filter: (b2t1.c1 = b2t3.c1) -> Merge Join (cost=xxx rows=1 width=8) Merge Cond: (b2t1.c1 = b2t2.c1) -> Nested Loop (cost=xxx rows=6 width=4) -> Index Scan using t1_i1 on t1 b2t1 (cost=xxx rows=1 width=4) Filter: (ctid = '(1,1)'::tid) -> Seq Scan on r3_ (cost=xxx rows=6 width=0) Filter: (c1 = 1) -> Sort (cost=xxx rows=1 width=4) Sort Key: b2t2.c1 -> Seq Scan on t2 b2t2 (cost=xxx rows=1 width=4) Filter: (ctid = '(1,1)'::tid) -> Tid Scan on t3 b2t3 (cost=xxx rows=1 width=4) TID Cond: (ctid = '(1,1)'::tid) -> Tid Scan on t4 b2t4 (cost=xxx rows=1 width=4) TID Cond: (ctid = '(1,1)'::tid) Aggregate (cost=xxx rows=1 width=4) -> Nested Loop (cost=xxx rows=1 width=4) Join Filter: (b3t1.c1 = b3t4.c1) -> Nested Loop (cost=xxx rows=1 width=12) Join Filter: (b3t1.c1 = b3t3.c1) -> Merge Join (cost=xxx rows=1 width=8) Merge Cond: (b3t1.c1 = b3t2.c1) -> Nested Loop (cost=xxx rows=6 width=4) -> Index Scan using t1_i1 on t1 b3t1 (cost=xxx rows=1 width=4) Filter: (ctid = '(1,1)'::tid) -> Seq Scan on r3_ (cost=xxx rows=6 width=0) Filter: (c1 = 1) -> Sort (cost=xxx rows=1 width=4) Sort Key: b3t2.c1 -> Seq Scan on t2 b3t2 (cost=xxx rows=1 width=4) Filter: (ctid = '(1,1)'::tid) -> Tid Scan on t3 b3t3 (cost=xxx rows=1 width=4) TID Cond: (ctid = '(1,1)'::tid) -> Tid Scan on t4 b3t4 (cost=xxx rows=1 width=4) TID Cond: (ctid = '(1,1)'::tid) (62 rows) QUERY PLAN ------------------------------------------------------------------------------------- Aggregate (cost=xxx rows=1 width=4) -> Nested Loop (cost=xxx rows=2 width=4) Join Filter: (b1t1.c1 = b1t4.c1) -> Tid Scan on t4 b1t4 (cost=xxx rows=1 width=4) TID Cond: (ctid = '(1,1)'::tid) -> Nested Loop (cost=xxx rows=2 width=12) Join Filter: (b1t1.c1 = b1t3.c1) -> Tid Scan on t3 b1t3 (cost=xxx rows=1 width=4) TID Cond: (ctid = '(1,1)'::tid) -> Nested Loop (cost=xxx rows=2 width=8) Join Filter: (b1t1.c1 = b1t2.c1) -> Seq Scan on t2 b1t2 (cost=xxx rows=1 width=4) Filter: (ctid = '(1,1)'::tid) -> Nested Loop (cost=xxx rows=2 width=4) -> Tid Scan on t1 b1t1 (cost=xxx rows=1 width=4) TID Cond: (ctid = '(1,1)'::tid) -> Seq Scan on r3_ (cost=xxx rows=6 width=0) Filter: (c1 = 1) Aggregate (cost=xxx rows=1 width=4) -> Nested Loop (cost=xxx rows=2 width=4) Join Filter: (b2t1.c1 = b2t4.c1) -> Tid Scan on t4 b2t4 (cost=xxx rows=1 width=4) TID Cond: (ctid = '(1,1)'::tid) -> Nested Loop (cost=xxx rows=2 width=12) Join Filter: (b2t1.c1 = b2t3.c1) -> Tid Scan on t3 b2t3 (cost=xxx rows=1 width=4) TID Cond: (ctid = '(1,1)'::tid) -> Nested Loop (cost=xxx rows=2 width=8) Join Filter: (b2t1.c1 = b2t2.c1) -> Seq Scan on t2 b2t2 (cost=xxx rows=1 width=4) Filter: (ctid = '(1,1)'::tid) -> Nested Loop (cost=xxx rows=2 width=4) -> Tid Scan on t1 b2t1 (cost=xxx rows=1 width=4) TID Cond: (ctid = '(1,1)'::tid) -> Seq Scan on r3_ (cost=xxx rows=6 width=0) Filter: (c1 = 1) Aggregate (cost=xxx rows=1 width=4) -> Nested Loop (cost=xxx rows=2 width=4) Join Filter: (b3t1.c1 = b3t4.c1) -> Tid Scan on t4 b3t4 (cost=xxx rows=1 width=4) TID Cond: (ctid = '(1,1)'::tid) -> Nested Loop (cost=xxx rows=2 width=12) Join Filter: (b3t1.c1 = b3t3.c1) -> Tid Scan on t3 b3t3 (cost=xxx rows=1 width=4) TID Cond: (ctid = '(1,1)'::tid) -> Nested Loop (cost=xxx rows=2 width=8) Join Filter: (b3t1.c1 = b3t2.c1) -> Seq Scan on t2 b3t2 (cost=xxx rows=1 width=4) Filter: (ctid = '(1,1)'::tid) -> Nested Loop (cost=xxx rows=2 width=4) -> Tid Scan on t1 b3t1 (cost=xxx rows=1 width=4) TID Cond: (ctid = '(1,1)'::tid) -> Seq Scan on r3_ (cost=xxx rows=6 width=0) Filter: (c1 = 1) (56 rows)