create table t1 (a int, b int);
create index i_t1 (a int);
create table t2 (like t1 including indexes);
create table t3 (like t1 including indexes);
create table t4 (like t1 including indexes);
create table t5 (like t1 including indexes);
create table t6 (like t1 including indexes);
create table t7 (like t1 including indexes);
create table t8 (like t1 including indexes);
create table t9 (like t1 including indexes);
create table t10 (like t1 including indexes);


insert into t1 (a,b) select a, a * 10 from generate_series(0, 100) a(a);
insert into t2 (select a * 10, a * 20 from generate_series(0, 100) a);
insert into t3 (select a * 10, a * 20 from generate_series(0, 100) a);
insert into t4 (select a * 10, a * 20 from generate_series(0, 100) a);
insert into t5 (select a * 10, a * 20 from generate_series(0, 100) a);
insert into t6 (select a * 10, a * 20 from generate_series(0, 100) a);
insert into t7 (select a * 10, a * 20 from generate_series(0, 100) a);
insert into t8 (select a * 10, a * 20 from generate_series(0, 100) a);
insert into t9 (select a * 10, a * 20 from generate_series(0, 100) a);
insert into t10 (select a * 10, a * 20 from generate_series(0, 100) a);


explain analyze select t1.a, t10.b from t1 join t2 on (t1.b = t2.a) join t3 on (t2.b = t3.a) join t4 on (t3.b = t4.a) join t5 on (t4.b = t5.a) join t6 on (t5.b = t6.a) join t7 on (t6.b = t7.a) join t8 on (t7.b = t8.a) join t9 on (t8.b = t9.a) join t10 on (t9.b = t10.a);