create  table tab1 (a int);


create  table tab2 (b int);


insert into tab1 select generate_series (1,30667722);


insert into tab2 select generate_series (1, 9783);


insert into tab2 select * from tab2;


insert into tab2 select * from tab2;


insert into tab2 select * from tab2;


analyze tab1;


analyze tab2;


explain select b from tab2 left join tab1 on a = b; 
