On Mon, Feb 09, 2009 at 02:14:39PM -0500, dariuszs wrote:
Hi, Here is the log of processing just 10 records for all the fields - I'm a newbie to this software but what this looks like is that for every record the software is scanning all columns and then joins them? Please take a look. Thanks. Dariusz.
This looks wrong, ie I would have expected to slice to be pushed under the joins. Which version are you using? Niels
Niels Nes wrote:
On Mon, Feb 09, 2009 at 01:29:04PM -0500, dariuszs wrote:
Hi, I'm running this on Windows x64 and yes there is activity it's just writing out like 5MB/s. Dariusz.
Windows isn't exactly our day to day platform. But clearly we should do some heavy debugging/testing on Windows. Maybe I can get some tests running tomorrow.
Niels
Niels Nes wrote:
On Mon, Feb 09, 2009 at 12:56:56PM -0500, dariuszs wrote:
Hi, Not at all - I've got 48GB of memory and the memory goes up slowly - right now about 9GB, cpu usage is about 6%, page file usage is about 2.6GB. When I select let's say 50 fields memory goes up quickly and cpu usage goes to 100 in no time. Dariusz.
strange. Do you see io activity (iostat or iotop)?
Niels
Niels Nes wrote:
On Mon, Feb 09, 2009 at 12:30:34PM -0500, dariuszs wrote:
> Hi, > Could you please help me here. I've got 300 fields, 100 > million records, 800 bytes per row in a table. Exporting 60 > fields into a table takes about 1 minute and selecting * from > table takes very long time, and I don't see lots of cpu usage > when exporting all records. Thanks. Dariusz. > Did MonetDB run out of memory, ie do you see any swap activity?
Niels
> ------------------------------------------------------------------------------ > Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) > software. With Adobe AIR, Ajax developers can use existing skills and code to > build responsive, highly engaging applications that combine the power of local > resources and data with the reach of the web. Download the Adobe AIR SDK and > Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com > _______________________________________________ > MonetDB-users mailing list > MonetDB-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-users >
------------------------------------------------------------------------------ Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------------ Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
:0[0]:W Strace copy select * from trw100 limit 10 into 'd:/x1.txt'; :3297[0]:R [ 0 usec mdb.setTimer(true); ] [ 32000 usec _1 := sql.bind("sys","trw100","f1",0); ] [ 15000 usec _6 := sql.bind("sys","trw100","f1",1); ] [ 16000 usec _8 := algebra.kunion(
:bat[:oid,:str][96240405], :bat[:oid,:str][0]); ] [ 0 usec _1 := nil; ] [ 15000 usec _6 := nil; ] [ 16000 usec _9 := sql.bind("sys","trw100","f1",2); ] [ 16000 usec _11 := algebra.kdifference( [96240405], :bat[:oid,:str][0]); ] [ 0 usec _8 := nil; ] [ 15000 usec _12 := algebra.kunion( [96240405], :bat[:oid,:str][0]); ] [ 16000 usec _11 := nil; ] [ 16000 usec _9 := nil; ] [ 15000 usec _13 := sql.bind_dbat("sys","trw100",1); ] [ 0 usec _14 := bat.reverse( :bat[:oid,:oid][0]); ] [ 16000 usec _13 := nil; ] [ 15000 usec _15 := algebra.kdifference( [96240405],<~tmp_27261>[0]); ] [ 16000 usec _12 := nil; ] [ 16000 usec _14 := nil; ] [ 0 usec _16 := bat.reverse( [96240405]); ] [ 15000 usec _17 := bat.reverse(<~tmp_27520>[96240405]); ] [ 16000 usec _16 := nil; ] [ 16000 usec _19 := algebra.markT( [96240405],0@0); ] [ 0 usec _17 := nil; ] [ 15000 usec _20 := bat.reverse( [96240405]); ] [ 16000 usec _19 := nil; ] [ 15000 usec _21 := algebra.join(<~tmp_27517>[96240405], [96240405]); ] [ 16000 usec _24 := algebra.slice( [96240405],0,9); ] [ 0 usec _21 := nil; ] [ 16000 usec _25 := sql.bind("sys","trw100","f2",0); ] [ 15000 usec _27 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 16000 usec _25 := nil; ] [ 16000 usec _28 := algebra.semijoin( [96240405], [10]); ] [ 0 usec _27 := nil; ] [ 15000 usec _29 := sql.bind("sys","trw100","f3",0); ] [ 16000 usec _31 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 15000 usec _29 := nil; ] [ 16000 usec _32 := algebra.semijoin( [96240405], [10]); ] [ 0 usec _31 := nil; ] [ 16000 usec _33 := sql.bind("sys","trw100","f4",0); ] [ 15000 usec _35 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 16000 usec _33 := nil; ] [ 16000 usec _36 := algebra.semijoin( [96240405], [10]); ] [ 0 usec _35 := nil; ] [ 15000 usec _37 := sql.bind("sys","trw100","f5",0); ] [ 16000 usec _39 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 15000 usec _37 := nil; ] [ 16000 usec _40 := algebra.semijoin( [96240405], [10]); ] [ 0 usec _39 := nil; ] [ 16000 usec _41 := sql.bind("sys","trw100","f6",0); ] [ 15000 usec _43 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 16000 usec _41 := nil; ] [ 0 usec _44 := algebra.semijoin( [96240405], [10]); ] [ 16000 usec _43 := nil; ] [ 15000 usec _45 := sql.bind("sys","trw100","f7",0); ] [ 16000 usec _47 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 15000 usec _45 := nil; ] [ 0 usec _48 := algebra.semijoin( [96240405], [10]); ] [ 16000 usec _47 := nil; ] [ 16000 usec _49 := sql.bind("sys","trw100","f8",0); ] [ 15000 usec _51 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 16000 usec _49 := nil; ] [ 0 usec _52 := algebra.semijoin( [96240405], [10]); ] [ 16000 usec _51 := nil; ] [ 15000 usec _53 := sql.bind("sys","trw100","f9",0); ] [ 16000 usec _55 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 15000 usec _53 := nil; ] [ 0 usec _56 := algebra.semijoin( [96240405], [10]); ] [ 16000 usec _55 := nil; ] [ 16000 usec _57 := sql.bind("sys","trw100","f10",0); ] [ 15000 usec _59 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 16000 usec _57 := nil; ] [ 0 usec _60 := algebra.semijoin( [96240405], [10]); ] [ 16000 usec _59 := nil; ] [ 15000 usec _61 := sql.bind("sys","trw100","f11",0); ] [ 16000 usec _63 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 0 usec _61 := nil; ] [ 15000 usec _64 := algebra.semijoin( [96240405], [10]); ] [ 16000 usec _63 := nil; ] [ 16000 usec _65 := sql.bind("sys","trw100","f12",0); ] [ 15000 usec _67 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 0 usec _65 := nil; ] [ 16000 usec _68 := algebra.semijoin( [96240405], [10]); ] [ 16000 usec _67 := nil; ] [ 15000 usec _69 := sql.bind("sys","trw100","f13",0); ] [ 16000 usec _71 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 0 usec _69 := nil; ] [ 15000 usec _72 := algebra.semijoin( [96240405], [10]); ] [ 16000 usec _71 := nil; ] [ 16000 usec _73 := sql.bind("sys","trw100","f14",0); ] [ 15000 usec _75 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 0 usec _73 := nil; ] [ 16000 usec _76 := algebra.semijoin( [96240405], [10]); ] [ 16000 usec _75 := nil; ] [ 15000 usec _77 := sql.bind("sys","trw100","f15",0); ] [ 0 usec _79 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 16000 usec _77 := nil; ] [ 15000 usec _80 := algebra.semijoin( [96240405], [10]); ] [ 16000 usec _79 := nil; ] [ 16000 usec _81 := sql.bind("sys","trw100","f16",0); ] [ 0 usec _83 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 15000 usec _81 := nil; ] [ 16000 usec _84 := algebra.semijoin( [96240405], [10]); ] [ 16000 usec _83 := nil; ] [ 15000 usec _85 := sql.bind("sys","trw100","f17",0); ] [ 16000 usec _87 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 0 usec _85 := nil; ] [ 15000 usec _88 := algebra.semijoin( [96240405], [10]); ] [ 16000 usec _87 := nil; ] [ 16000 usec _89 := sql.bind("sys","trw100","f18",0); ] [ 15000 usec _91 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 0 usec _89 := nil; ] [ 16000 usec _92 := algebra.semijoin( [96240405], [10]); ] [ 16000 usec _91 := nil; ] [ 15000 usec _93 := sql.bind("sys","trw100","f19",0); ] [ 0 usec _95 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 16000 usec _93 := nil; ] [ 15000 usec _96 := algebra.semijoin( [96240405], [10]); ] [ 16000 usec _95 := nil; ] [ 16000 usec _97 := sql.bind("sys","trw100","f20",0); ] [ 0 usec _99 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 15000 usec _97 := nil; ] [ 16000 usec _100 := algebra.semijoin( [96240405], [10]); ] [ 16000 usec _99 := nil; ] [ 15000 usec _101 := sql.bind("sys","trw100","f21",0); ] [ 0 usec _103 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 16000 usec _101 := nil; ] [ 15000 usec _104 := algebra.semijoin( [96240405], [10]); ] [ 16000 usec _103 := nil; ] [ 16000 usec _105 := sql.bind("sys","trw100","f22",0); ] [ 0 usec _107 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 15000 usec _105 := nil; ] [ 16000 usec _108 := algebra.semijoin( [96240405], [10]); ] [ 16000 usec _107 := nil; ] [ 15000 usec:4891[0]:R _109 := sql.bind("sys","trw100","f23",0); ] [ 0 usec _111 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 16000 usec _109 := nil; ] [ 15000 usec _112 := algebra.semijoin( [96240405], [10]); ] [ 16000 usec _111 := nil; ] [ 0 usec _113 := sql.bind("sys","trw100","f24",0); ] [ 16000 usec _115 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 15000 usec _113 := nil; ] [ 16000 usec _116 := algebra.semijoin( [96240405], [10]); ] [ 16000 usec _115 := nil; ] [ 0 usec _117 := sql.bind("sys","trw100","f25",0); ] [ 15000 usec _119 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 16000 usec _117 := nil; ] [ 15000 usec _120 := algebra.semijoin( [96240405], [10]); ] [ 16000 usec _119 := nil; ] [ 0 usec _121 := sql.bind("sys","trw100","f26",0); ] [ 16000 usec _123 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 15000 usec _121 := nil; ] [ 16000 usec _124 := algebra.semijoin( [96240405], [10]); ] [ 16000 usec _123 := nil; ] [ 0 usec _125 := sql.bind("sys","trw100","f27",0); ] [ 15000 usec _127 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 16000 usec _125 := nil; ] [ 15000 usec _128 := algebra.semijoin( [96240405], [10]); ] [ 16000 usec _127 := nil; ] [ 0 usec _129 := sql.bind("sys","trw100","f28",0); ] [ 16000 usec _131 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 15000 usec _129 := nil; ] [ 16000 usec _132 := algebra.semijoin( [96240405], [10]); ] [ 0 usec _131 := nil; ] [ 16000 usec _133 := sql.bind("sys","trw100","f29",0); ] [ 15000 usec _135 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 16000 usec _133 := nil; ] [ 15000 usec _136 := algebra.semijoin( [96240405], [10]); ] [ 0 usec _135 := nil; ] [ 16000 usec _137 := sql.bind("sys","trw100","f30",0); ] [ 16000 usec _139 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 15000 usec _137 := nil; ] [ 16000 usec _140 := algebra.semijoin( [96240405], [10]); ] [ 0 usec _139 := nil; ] [ 16000 usec _141 := sql.bind("sys","trw100","f31",0); ] [ 15000 usec _143 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 16000 usec _141 := nil; ] [ 15000 usec _144 := algebra.semijoin( [96240405], [10]); ] [ 0 usec _143 := nil; ] [ 16000 usec _145 := sql.bind("sys","trw100","f32",0); ] [ 16000 usec _147 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 15000 usec _145 := nil; ] [ 0 usec _148 := algebra.semijoin( [96240405], [10]); ] [ 16000 usec _147 := nil; ] [ 16000 usec _149 := sql.bind("sys","trw100","f33",0); ] [ 15000 usec _151 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 16000 usec _149 := nil; ] [ 0 usec _152 := algebra.semijoin( [96240405], [10]); ] [ 15000 usec _151 := nil; ] [ 16000 usec _153 := sql.bind("sys","trw100","f34",0); ] [ 16000 usec _155 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 15000 usec _153 := nil; ] [ 0 usec _156 := algebra.semijoin( [96240405], [10]); ] [ 16000 usec _155 := nil; ] [ 16000 usec _157 := sql.bind("sys","trw100","f35",0); ] [ 15000 usec _159 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 16000 usec _157 := nil; ] [ 0 usec _160 := algebra.semijoin( [96240405], [10]); ] [ 15000 usec _159 := nil; ] [ 16000 usec _161 := sql.bind("sys","trw100","f36",0); ] [ 16000 usec _163 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 15000 usec _161 := nil; ] [ 0 usec _164 := algebra.semijoin( [96240405], [10]); ] [ 16000 usec _163 := nil; ] [ 16000 usec _165 := sql.bind("sys","trw100","f37",0); ] [ 15000 usec _167 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 0 usec _165 := nil; ] [ 16000 usec _168 := algebra.semijoin( [96240405], [10]); ] [ 15000 usec _167 := nil; ] [ 16000 usec _169 := sql.bind("sys","trw100","f38",0); ] [ 16000 usec _171 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 0 usec _169 := nil; ] [ 15000 usec _172 := algebra.semijoin( [96240405], [10]); ] [ 16000 usec _171 := nil; ] [ 16000 usec _173 := sql.bind("sys","trw100","f39",0); ] [ 15000 usec _175 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 0 usec _173 := nil; ] [ 16000 usec _176 := algebra.semijoin( [96240405], [10]); ] [ 15000 usec _175 := nil; ] [ 16000 usec _177 := sql.bind("sys","trw100","f40",0); ] [ 16000 usec _179 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 0 usec _177 := nil; ] [ 15000 usec _180 := algebra.semijoin( [96240405], [10]); ] [ 16000 usec _179 := nil; ] [ 16000 usec _181 := sql.bind("sys","trw100","f41",0); ] [ 0 usec _183 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 15000 usec _181 := nil; ] [ 16000 usec _184 := algebra.semijoin( [96240405], [10]); ] [ 15000 usec _183 := nil; ] [ 16000 usec _185 := sql.bind("sys","trw100","f42",0); ] [ 0 usec _187 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 16000 usec _185 := nil; ] [ 15000 usec _188 := algebra.semijoin( [96240405], [10]); ] [ 16000 usec _187 := nil; ] [ 16000 usec _189 := sql.bind("sys","trw100","f43",0); ] [ 0 usec _191 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 15000 usec _189 := nil; ] [ 16000 usec _192 := algebra.semijoin( [96240405], [10]); ] [ 15000 usec _191 := nil; ] [ 16000 usec _193 := sql.bind("sys","trw100","f44",0); ] [ 0 usec _195 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 16000 usec _193 := nil; ] [ 15000 usec _196 := algebra.semijoin( [96240405], [10]); ] [ 16000 usec _195 := nil; ] [ 0 usec _197 := sql.bind("sys","trw100","f45",0); ] [ 16000 usec _199 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 15000 usec _197 := nil; ] [ 16000 usec _200 := algebra.semijoin( [96240405], [10]); ] [ 15000 usec _199 := nil; ] [ 0 usec _201 := sql.bind("sys","trw100","f46",0); ] [ 16000 usec _203 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 16000 usec _201 := nil; ] [ 15000 usec _204 := algebra.semijoin( [96240405], [10]); ] [ 16000 usec _203 := nil; ] [ 0 usec _205 := sql.bind("sys","trw100","f47",0); ] [ 16000 usec _207 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 15000 usec _205 := nil; ] [ 16000 usec _208 := algebra.semijoin( [96240405], [10]); ] [ 0 usec _207 := nil; ] [ 15000 usec _209 := sql.bind("sys","trw100","f48",0); ] [ 16000 usec _211 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 16000 usec _209 := nil; ] [ :6469[0]:R 15000 usec _212 := algebra.semijoin( [96240405], [10]); ] [ 16000 usec _211 := nil; ] [ 16000 usec _213 := sql.bind("sys","trw100","f49",0); ] [ 0 usec _215 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 15000 usec _213 := nil; ] [ 16000 usec _216 := algebra.semijoin( [96240405], [10]); ] [ 15000 usec _215 := nil; ] [ 16000 usec _217 := sql.bind("sys","trw100","f50",0); ] [ 16000 usec _219 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 15000 usec _217 := nil; ] [ 16000 usec _220 := algebra.semijoin( [96240405], [10]); ] [ 16000 usec _219 := nil; ] [ 0 usec _221 := sql.bind("sys","trw100","f51",0); ] [ 15000 usec _223 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 16000 usec _221 := nil; ] [ 15000 usec _224 := algebra.semijoin( [96240405], [10]); ] [ 0 usec _223 := nil; ] [ 16000 usec _225 := sql.bind("sys","trw100","f52",0); ] [ 16000 usec _227 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 15000 usec _225 := nil; ] [ 16000 usec _228 := algebra.semijoin( [96240405], [10]); ] [ 0 usec _227 := nil; ] [ 16000 usec _229 := sql.bind("sys","trw100","f53",0); ] [ 15000 usec _231 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 16000 usec _229 := nil; ] [ 15000 usec _232 := algebra.semijoin( [96240405], [10]); ] [ 0 usec _231 := nil; ] [ 16000 usec _233 := sql.bind("sys","trw100","f54",0); ] [ 16000 usec _235 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 15000 usec _233 := nil; ] [ 0 usec _236 := algebra.semijoin( [96240405], [10]); ] [ 0 usec _235 := nil; ] [ 16000 usec _237 := sql.bind("sys","trw100","f55",0); ] [ 15000 usec _239 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 16000 usec _237 := nil; ] [ 0 usec _240 := algebra.semijoin( [96240405], [10]); ] [ 15000 usec _239 := nil; ] [ 16000 usec _241 := sql.bind("sys","trw100","f56",0); ] [ 16000 usec _243 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 15000 usec _241 := nil; ] [ 0 usec _244 := algebra.semijoin( [96240405], [10]); ] [ 16000 usec _243 := nil; ] [ 16000 usec _245 := sql.bind("sys","trw100","f57",0); ] [ 15000 usec _247 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 16000 usec _245 := nil; ] [ 0 usec _248 := algebra.semijoin( [96240405], [10]); ] [ 15000 usec _247 := nil; ] [ 16000 usec _249 := sql.bind("sys","trw100","f58",0); ] [ 16000 usec _251 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 15000 usec _249 := nil; ] [ 0 usec _252 := algebra.semijoin( [96240405], [10]); ] [ 16000 usec _251 := nil; ] [ 16000 usec _253 := sql.bind("sys","trw100","f59",0); ] [ 15000 usec _255 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 0 usec _253 := nil; ] [ 16000 usec _256 := algebra.semijoin( [96240405], [10]); ] [ 15000 usec _255 := nil; ] [ 16000 usec _257 := sql.bind("sys","trw100","f60",0); ] [ 16000 usec _259 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 0 usec _257 := nil; ] [ 15000 usec _260 := algebra.semijoin( [96240405], [10]); ] [ 16000 usec _259 := nil; ] [ 16000 usec _261 := sql.bind("sys","trw100","f61",0); ] [ 15000 usec _263 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 0 usec _261 := nil; ] [ 16000 usec _264 := algebra.semijoin( [96240405], [10]); ] [ 15000 usec _263 := nil; ] [ 16000 usec _265 := sql.bind("sys","trw100","f62",0); ] [ 16000 usec _267 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 0 usec _265 := nil; ] [ 15000 usec _268 := algebra.semijoin( [96240405], [10]); ] [ 16000 usec _267 := nil; ] [ 16000 usec _269 := sql.bind("sys","trw100","f63",0); ] [ 0 usec _271 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 15000 usec _269 := nil; ] [ 16000 usec _272 := algebra.semijoin( [96240405], [10]); ] [ 15000 usec _271 := nil; ] [ 16000 usec _273 := sql.bind("sys","trw100","f64",0); ] [ 0 usec _275 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 16000 usec _273 := nil; ] [ 15000 usec _276 := algebra.semijoin( [96240405], [10]); ] [ 16000 usec _275 := nil; ] [ 16000 usec _277 := sql.bind("sys","trw100","f65",0); ] [ 0 usec _279 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 15000 usec _277 := nil; ] [ 16000 usec _280 := algebra.semijoin( [96240405], [10]); ] [ 15000 usec _279 := nil; ] [ 16000 usec _281 := sql.bind("sys","trw100","f66",0); ] [ 0 usec _283 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 16000 usec _281 := nil; ] [ 15000 usec _284 := algebra.semijoin( [96240405], [10]); ] [ 16000 usec _283 := nil; ] [ 0 usec _285 := sql.bind("sys","trw100","f67",0); ] [ 16000 usec _287 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 15000 usec _285 := nil; ] [ 16000 usec _288 := algebra.semijoin( [96240405], [10]); ] [ 15000 usec _287 := nil; ] [ 0 usec _289 := sql.bind("sys","trw100","f68",0); ] [ 16000 usec _291 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 16000 usec _289 := nil; ] [ 15000 usec _292 := algebra.semijoin( [96240405], [10]); ] [ 16000 usec _291 := nil; ] [ 0 usec _293 := sql.bind("sys","trw100","f69",0); ] [ 16000 usec _295 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 15000 usec _293 := nil; ] [ 16000 usec _296 := algebra.semijoin( [96240405], [10]); ] [ 15000 usec _295 := nil; ] [ 0 usec _297 := sql.bind("sys","trw100","f70",0); ] [ 16000 usec _299 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 16000 usec _297 := nil; ] [ 15000 usec _300 := algebra.semijoin( [96240405], [10]); ] [ 0 usec _299 := nil; ] [ 16000 usec _301 := sql.bind("sys","trw100","f71",0); ] [ 16000 usec _303 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 15000 usec _301 := nil; ] [ 16000 usec _304 := algebra.semijoin( [96240405], [10]); ] [ 0 usec _303 := nil; ] [ 15000 usec _305 := sql.bind("sys","trw100","f72",0); ] [ 16000 usec _307 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 16000 usec _305 := nil; ] [ 15000 usec _308 := algebra.semijoin( [96240405], [10]); ] [ 0 usec _307 := nil; ] [ 16000 usec _309 := sql.bind("sys","trw100","f73",0); ] [ 16000 usec _311 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 15000 usec _309 := nil; ] [ 16000 usec _312 := algebra.semijoin( [96240405], [10]); ] [ 0 usec _311 := nil; ] [ 15000 usec _313 := sql.bind("sys","trw100","f74",0); ] [ 16000 u:8079[0]:R sec _315 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 16000 usec _313 := nil; ] [ 15000 usec _316 := algebra.semijoin( [96240405], [10]); ] [ 16000 usec _315 := nil; ] [ 16000 usec _317 := sql.bind("sys","trw100","f75",0); ] [ 15000 usec _319 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 16000 usec _317 := nil; ] [ 0 usec _320 := algebra.semijoin( [96240405], [10]); ] [ 15000 usec _319 := nil; ] [ 16000 usec _321 := sql.bind("sys","trw100","f76",0); ] [ 16000 usec _323 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 15000 usec _321 := nil; ] [ 0 usec _324 := algebra.semijoin( [96240405], [10]); ] [ 16000 usec _323 := nil; ] [ 16000 usec _325 := sql.bind("sys","trw100","f77",0); ] [ 15000 usec _327 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 16000 usec _325 := nil; ] [ 0 usec _328 := algebra.semijoin( [96240405], [10]); ] [ 15000 usec _327 := nil; ] [ 16000 usec _329 := sql.bind("sys","trw100","f78",0); ] [ 16000 usec _331 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 0 usec _329 := nil; ] [ 15000 usec _332 := algebra.semijoin( [96240405], [10]); ] [ 16000 usec _331 := nil; ] [ 16000 usec _333 := sql.bind("sys","trw100","f79",0); ] [ 15000 usec _335 := algebra.join(<~tmp_27517>[96240405], :bat[:oid,:str][96240405]); ] [ 0 usec _333 := nil; ] [ 16000 usec _336 := algebra.semijoin(