SQLize Online / PHPize Online  /  SQLtest Online

create table tab1(id numeric, val numeric); create index id_idx on tab1 (id); create index tab1_val_idx on tab1 (val); insert into tab1 select g.x, round(random() * 1000000) from generate_series(1, 1000000, 1) g(x); create table tab2(id numeric, field1 numeric, field2 numeric, measure numeric, constraint pk primary key (id, field1, field2)); create index tab2_field1_nd on tab2 (field1, field2, measure); insert into tab2 select g.x, round(random() * 1000), round(random()), random() from generate_series(1, 1000000, 1) g(x); create view tab2_view as select tab2.id, tab1.val, field2, measure from tab2 left join tab1 on tab1.id = tab2.field1; create table tab_other(id numeric, val numeric); create index tab_other_val_idx on tab_other(val); insert into tab_other (select row_number() over (), val from tab2_view limit 100); analyze tab1; analyze tab2; analyze tab_other; explain select tab_other.val, sum(tab2_view.measure) from tab_other left join tab2_view on tab2_view.val = tab_other.val group by tab_other.val;