Profiling Results

From MonetDB
Jump to navigationJump to search

Own Code[edit]

Call Count total t Instr
1 1020118 function user.main();
23 1020089 rcl.main();
20 613445 (lJoin=<tmpr_5641>[309825],rJoin=<tmpr_5634>[309825]) := algebra.join(o_orderkey_select_values=<tmp_5614>[77229],l_orderkey_slice=<tmpr_5622>[534151]);
20 139606 months_select_values=<tmp_5621>[77229] := batmtime.month(o_orderdate_select_values==\<tmp_5504>\:date[77229]);
20 69059 (g=<tmp_5612>[309825],e=<tmp_5635>[3],h=<tmp_5632>[3]) := group.subgroupdone(months_join_values=<tmp_5611>[309825]);
20 48185 newSums=<tmp_5632>[3] := aggr.subsum(l_extendedprice_join_values=<tmp_5630>[309825],g=<tmp_5612>[309825],e=<tmp_5635>[3],true,true);
20 32096 o_orderdate_join_values=<tmp_5624>[309825] := algebra.leftfetchjoin(lJoin=<tmpr_5641>[309825],o_orderdate_select_values==\<tmp_5504>\:date[77229]);
20 29941 months_join_values=<tmp_5611>[309825] := algebra.leftfetchjoin(lJoin=<tmpr_5641>[309825],months_select_values=<tmp_5621>[77229]);
20 16954 l_extendedprice_join_values=<tmp_5630>[309825] := algebra.leftfetchjoin(rJoin=<tmpr_5634>[309825],l_extendedprice_slice=<tmpr_5636>[534151]);
10 3412 o_orderkey_select_values=<tmp_5614>[77229] := algebra.leftfetchjoin(o_orderdate_select=<tmp_5615>[77229],o_orderkey_slice=<tmpr_5640>[133388]);
10 3026 o_orderdate_select=<tmp_5615>[77229] := algebra.subselect(o_orderdate_slice==\<tmpr_5642>\:date[133388],lowDate==\1997-01-01\:date,highDate==\1998-01-01\:date,true,true,false);
10 2823 o_orderdate_select_values=<tmp_5504>[77229] := algebra.leftfetchjoin(o_orderdate_select=<tmp_5615>[77229],o_orderdate_slice==\<tmpr_5642>\:date[133388]);
20 2028 redo cont := rcl.shouldContinue(i=nil,j=nil);
1 1304 (r1=<tmp_5473>[115],r2=<tmp_5470>[115],r3=<tmp_5472>[115],r4=<tmp_5474>[115],r5=<tmp_5475>[115],r6=<tmp_5451>[115],r7=<tmp_5457>[115],r8=<tmp_5460>[115],r9=<tmp_5450>[115],r10=<tmp_5447>[115]) := rec.testClustering(i1=<tmp_4575>:bat[:oid,:int][575],i2=<tmp_4602>:bat[:oid,:oid][575],i3=<tmp_4550>:bat[:oid,:oid][575],i4==\<tmp_4574>\:bat[:oid,:date][575],i5==\<tmp_4607>\:bat[:oid,:date][575],i6=<tmp_4572>:bat[:oid,:int][5750],i7=<tmp_4563>:bat[:oid,:oid][5750],i8=<tmp_4552>:bat[:oid,:oid][5750],i9==\<tmp_4546>\:bat[:oid,:date][5750],i10==\<tmp_4601>\:bat[:oid,:date][5750]);
20 393 o_orderdate_slice=<tmpr_5642>[133388] := algebra.slice(o_orderdate==\<tmp_3674>\:bat[:oid,:date][15000000],leftBegin=13820221@0,leftEnd=13953609@0);
20 355 newMonths=<tmp_5626>[3] := algebra.leftfetchjoin(e=<tmp_5635>[3],months_join_values=<tmp_5611>[309825]);
20 318 (x,leftBegin,leftEnd) := rec.getGroupOIDs(oGroupIDs=<tmp_5466>[20],oBegins=<tmp_5462>[20],oEnds=<tmp_5452>[20],i=104);
20 224 o_orderkey_slice=<tmpr_5640>[133388] := algebra.slice(o_orderkey=<tmp_3700>:bat[:oid,:int][15000000],leftBegin=13820221@0,leftEnd=13953609@0);
20 215 l_orderkey_slice=<tmpr_5622>[534151] := algebra.slice(l_orderkey=<tmp_3720>:bat[:oid,:int][59986052],rightBegin=55266908@0,rightEnd=55801059@0);
20 202 (y,rightBegin,rightEnd) := rec.getGroupOIDs(lGroupIDs=<tmp_5476>[20],lBegins=<tmp_5477>[20],lEnds=<tmp_5500>[20],j=104);
20 191 l_extendedprice_slice=<tmpr_5636>[534151] := algebra.slice(l_extendedprice=<tmp_3713>:bat[:oid,:dbl][59986052],rightBegin=55266908@0,rightEnd=55801059@0);
1 184 barrier cont := rcl.shouldContinue(i=85,j=85);
20 105 bat.append(globalSums=<tmp_5501>[75],newSums=<tmp_5632>[3]);
20 97 j := grp.getNextGroupID(lGroupIDs=<tmp_5476>[20],j=nil);
20 69 bat.append(globalMonths=<tmp_5436>[75],newMonths=<tmp_5626>[3]);
20 67 i := grp.getNextGroupID(oGroupIDs=<tmp_5466>[20],i=nil);
22 66 retVal := calc.and(iIsNotNil=false,jIsNotNil=false);
23 60 end main;
20 59 barrier shouldSel := algebra.exist(oRunSelOnRev=<tmpr_5444>[10],i=104);
1 52 (lGroupIDs=<tmp_5476>[20],lBegins=<tmp_5477>[20],lEnds=<tmp_5500>[20],lRunSelOn=<tmp_5501>[10]) := grp.restrictBySelectOnExtrema(r6=<tmp_5451>[115],r7=<tmp_5457>[115],r8=<tmp_5460>[115],r9==\<tmp_5450>\:date[115],r10==\<tmp_5447>\:date[115],lowDate==\1997-01-01\:date,highDate==\1998-01-01\:date,1,1);
1 50 (oGroupIDs=<tmp_5466>[20],oBegins=<tmp_5462>[20],oEnds=<tmp_5452>[20],oRunSelOn=<tmp_5444>[10]) := grp.restrictBySelectOnExtrema(r1=<tmp_5473>[115],r2=<tmp_5470>[115],r3=<tmp_5472>[115],r4==\<tmp_5474>\:date[115],r5==\<tmp_5475>\:date[115],lowDate==\1997-01-01\:date,highDate==\1998-01-01\:date,1,1);
20 42 h := nil;
20 37 o_orderdate_select_values=<tmpr_5642>[133388] := o_orderdate_slice==\<tmpr_5642>\:date[133388];
20 33 # barrier lessThan := i < j;
22 29 return shouldContinue := retVal=false;
20 29 o_orderkey_select_values=<tmpr_5640>[133388] := o_orderkey_slice=<tmpr_5640>[133388];
20 24 # i := grp.getNextGroupID(oGroupIDs, i);
20 22 x := nil;
20 21 y := nil;
20 19 # redo cont := shouldContinue(i, j);
20 19 # redo cont := shouldContinue(i, j);
20 19 # exit lessThan;
20 17 # exit greaterThan;
20 16 # barrier greaterThan := i > j;
20 13 # j := grp.getNextGroupID(lGroupIDs, j);
1 12 lowDate := calc.date(\1997-01-01\);
1 10 (groups=<tmp_5620>[75],extents=<tmp_5631>[12],histo=<tmp_5606>[12]) := group.subgroupdone(globalMonths=<tmp_5436>[75]);
10 10 exit shouldSel;
1 9 o_orderdate:bat[:oid,:date] =<tmp_3674>[15000000] := sql.bind(mvc=0,\tpch\,\c_orders\,\c_o_orderdate\,0);
1 8 l_orderkey:bat[:oid,:int] =<tmp_3720>[59986052] := sql.bind(mvc=0,\tpch\,\c_lineitem\,\c_l_orderkey\,0);
1 8 i6:bat[:oid,:int] =<tmp_4572>[5750] := sql.bind(mvc=0,\tpch\,\g_lineitem\,\g_l_groupid\,0);
1 8 globalSums=<tmp_5501>[0] := bat.new(:oid,:dbl);
1 7 globalMonths=<tmp_5436>[0] := bat.new(:oid,:int);
1 6 result=<tmp_5606>[12] := aggr.subsum(globalSums=<tmp_5501>[75],groups=<tmp_5620>[75],extents=<tmp_5631>[12],true,true);
1 6 l_extendedprice:bat[:oid,:dbl] =<tmp_3713>[59986052] := sql.bind(mvc=0,\tpch\,\c_lineitem\,\c_l_extendedprice\,0);
1 6 i9:bat[:oid,:date] =<tmp_4546>[5750] := sql.bind(mvc=0,\tpch\,\g_lineitem\,\g_l_min_7_o_orderdate\,0);
1 6 i8:bat[:oid,:oid] =<tmp_4552>[5750] := sql.bind(mvc=0,\tpch\,\g_lineitem\,\g_l_end\,0);
1 6 i7:bat[:oid,:oid] =<tmp_4563>[5750] := sql.bind(mvc=0,\tpch\,\g_lineitem\,\g_l_begin\,0);
1 5 o_orderkey:bat[:oid,:int] =<tmp_3700>[15000000] := sql.bind(mvc=0,\tpch\,\c_orders\,\c_o_orderkey\,0);
1 5 i5:bat[:oid,:date] =<tmp_4607>[575] := sql.bind(mvc=0,\tpch\,\g_orders\,\g_o_max_o_orderdate\,0);
1 5 i4:bat[:oid,:date] =<tmp_4574>[575] := sql.bind(mvc=0,\tpch\,\g_orders\,\g_o_min_o_orderdate\,0);
1 5 i10:bat[:oid,:date] =<tmp_4601>[5750] := sql.bind(mvc=0,\tpch\,\g_lineitem\,\g_l_max_7_o_orderdate\,0);
1 4 oRunSelOnRev=<tmpr_5444>[10] := bat.reverse(oRunSelOn=<tmp_5444>[10]);
1 4 i := grp.getFirstGroupID(oGroupIDs=<tmp_5466>[20]);
1 4 highDate := calc.date(\1998-01-01\);
1 3 j := grp.getFirstGroupID(lGroupIDs=<tmp_5476>[20]);
1 2 lRunSelOn := nil;
1 1 return main=<tmp_5606>[12] := result=<tmp_5606>[12];
1 1 histo := nil;
1 1 exit cont;

SQL Unsorted[edit]

Call Count total t Instr
1 3058699 function user.s5_1(A0=\1997-01-01\,A1=\1998-01-01\);
1 2586729 (X_35=<tmpr_4176>[9123318],r1_42=<tmpr_4153>[9123318]) := algebra.join(X_25=<tmp_3707>[2281743],X_34=<tmp_4034>[59986052]);
1 161524 X_48:bat[:oid,:int] =<tmp_4172>[2281743] := batmtime.month(X_47==\<tmp_4034>\:date[2281743]);
1 77385 (X_50=<tmp_4172>[9123318],r1_60=<tmp_4176>[12],r2_60=<tmp_4153>[12]) := group.subgroupdone(X_49=<tmp_4034>[9123318]);
1 61831 X_46=<tmp_4161>[9123318] := algebra.leftfetchjoin(r1_42=<tmpr_4153>[9123318],X_45=<tmp_4034>[59986052]);
1 45965 X_53:bat[:oid,:dbl] =<tmp_4034>[12] := aggr.subsum(X_46=<tmp_4161>[9123318],X_50=<tmp_4172>[9123318],r1_60=<tmp_4176>[12],true,true);
1 31048 X_49=<tmp_4034>[9123318] := algebra.leftfetchjoin(X_35=<tmpr_4176>[9123318],X_48=<tmp_4172>:bat[:oid,:int][2281743]);
1 30649 X_79=<tmp_4172>[2281743] := algebra.subselect(X_8==\<tmp_3041>\:date[15000000],X_5=<tmp_4034>:bat[:oid,:oid][15000000],X_16==\1997-01-01\:date,X_17==\1998-01-01\:date,true,true,false);
1 16056 X_25=<tmp_3707>[2281743] := sql.projectdelta(X_18=<tmp_4172>[2281743],X_20=<tmp_3261>[15000000],X_22=<tmp_2101>[0],r1_26=<tmp_1701>[0],X_24=<tmp_1701>[0]);
1 12451 X_47=<tmp_4034>[2281743] := sql.projectdelta(X_18=<tmp_4172>[2281743],X_8==\<tmp_3041>\:date[15000000],X_11=<tmp_2101>[0],r1_11==\<tmp_2346>\:date[0],X_14==\<tmp_2346>\:date[0]);
1 46 sql.exportResult(X_61==\104d2\:streams,X_55=17);
1 19 X_26:bat[:oid,:oid] =<tmp_4161>[59986052] := sql.tid(X_4=0,\tpch\,\lineitem\);
1 17 X_45=<tmp_4034>[59986052] := sql.projectdelta(X_26=<tmp_4161>:bat[:oid,:oid][59986052],X_37=<tmp_3207>[59986052],X_40=<tmp_2101>[0],r1_47=<tmp_2320>[0],X_43=<tmp_2320>[0]);
1 12 X_8=<tmp_3041>[15000000] := sql.bind(X_4=0,\tpch\,\orders\,\o_orderdate\,0);
1 11 X_37=<tmp_3207>[59986052] := sql.bind(X_4=0,\tpch\,\lineitem\,\l_extendedprice\,0);
1 11 (X_11=<tmp_2101>[0],r1_11=<tmp_2346>[0]) := sql.bind(X_4=0,\tpch\,\orders\,\o_orderdate\,2);
1 9 X_80=<tmp_4161>[0] := algebra.subselect(r1_11==\<tmp_2346>\:date[0],X_16==\1997-01-01\:date,X_17==\1998-01-01\:date,true,true,false);
1 8 X_5:bat[:oid,:oid] =<tmp_4034>[15000000] := sql.tid(X_4=0,\tpch\,\orders\);
1 7 X_55 := sql.resultSet(1,1,X_53=<tmp_4034>:bat[:oid,:dbl][12]);
1 7 X_34=<tmp_4034>[59986052] := sql.projectdelta(X_26=<tmp_4161>:bat[:oid,:oid][59986052],X_28=<tmp_3175>[59986052],X_30=<tmp_2101>[0],r1_36=<tmp_1701>[0],X_32=<tmp_1701>[0]);
1 6 sql.rsColumn(X_55=17,\tpch.L1\,\L1\,\double\,53,0,X_53=<tmp_4034>:bat[:oid,:dbl][12]);
1 5 X_28=<tmp_3175>[59986052] := sql.bind(X_4=0,\tpch\,\lineitem\,\l_orderkey\,0);
1 4 (X_40=<tmp_2101>[0],r1_47=<tmp_2320>[0]) := sql.bind(X_4=0,\tpch\,\lineitem\,\l_extendedprice\,2);
1 4 (X_30=<tmp_2101>[0],r1_36=<tmp_1701>[0]) := sql.bind(X_4=0,\tpch\,\lineitem\,\l_orderkey\,2);
1 4 X_20=<tmp_3261>[15000000] := sql.bind(X_4=0,\tpch\,\or

SQL profile, Merge Join (Because sorted)[edit]

Count Total t Instr
1 1482066 function user.s1_1(A0=\1997-01-01\,A1=\1998-01-01\);
1 1011305 (X_20=<tmpr_5763>[9123318],r1_22=<tmpr_5757>[9123318]) := algebra.join(X_16=<tmp_5460>[2281743],X_17=<tmp_1600>[59986052]);
1 150221 X_26:bat[:oid,:int] =<tmp_5624>[2281743] := batmtime.month(X_25==\<tmp_5757>\:date[2281743]);
1 94335 (X_28=<tmp_5624>[9123318],r1_32=<tmp_5763>[12],r2_32=<tmp_5762>[12]) := group.subgroupdone(X_27=<tmp_5757>[9123318]);
1 59933 X_24=<tmp_5460>[9123318] := algebra.leftfetchjoin(r1_22=<tmpr_5757>[9123318],X_22=<tmp_2045>[59986052]);
1 42877 X_31:bat[:oid,:dbl] =<tmp_5757>[12] := aggr.subsum(X_24=<tmp_5460>[9123318],X_28=<tmp_5624>[9123318],r1_32=<tmp_5763>[12],true,true);
1 41675 X_12=<tmp_5624>[2281743] := algebra.subselect(X_5==\<tmp_2015>\:date[15000000],X_10==\1997-01-01\:date,X_11==\1998-01-01\:date,true,true,false);
1 27828 X_27=<tmp_5757>[9123318] := algebra.leftfetchjoin(X_20=<tmpr_5763>[9123318],X_26=<tmp_5624>:bat[:oid,:int][2281743]);
1 8923 X_16=<tmp_5460>[2281743] := algebra.leftfetchjoin(X_12=<tmp_5624>[2281743],X_14=<tmp_1625>[15000000]);
1 8807 X_25=<tmp_5757>[2281743] := algebra.leftfetchjoin(X_12=<tmp_5624>[2281743],X_5==\<tmp_2015>\:date[15000000]);
1 44 sql.exportResult(X_41==\104d2\:streams,X_33=1);
1 17 X_14=<tmp_1625>[15000000] := sql.bind(X_4=0,\tpch\,\orders\,\o_orderkey\,0);
1 15 X_17=<tmp_1600>[59986052] := sql.bind(X_4=0,\tpch\,\lineitem\,\l_orderkey\,0);
1 10 X_5=<tmp_2015>[15000000] := sql.bind(X_4=0,\tpch\,\orders\,\o_orderdate\,0);
1 10 X_22=<tmp_2045>[59986052] := sql.bind(X_4=0,\tpch\,\lineitem\,\l_extendedprice\,0);
1 6 X_33 := sql.resultSet(1,1,X_31=<tmp_5757>:bat[:oid,:dbl][12]);
1 6 X_10 := calc.date(A0=\1997-01-01\);
1 6 sql.rsColumn(X_33=1,\tpch.L1\,\L1\,\double\,53,0,X_31=<tmp_5757>:bat[:oid,:dbl][12]);
1 4 X_11 := calc.date(A1=\1998-01-01\);
1 3 X_4 := sql.mvc();
1 2 end s1_1;
1 1 X_41 := io.stdout();