sql>trace select distinct relation_members_way.relation as relation from relation_members_way left join ways on relation_members_way.to_way = ways.id where ways.id is NULL; | 3 usec mdb.setTimer(true); | | 5 usec barrier _83 := language.dataflow(); | | 10 usec _1 := sql.bind("sys","relation_members_way","relation",0); | | 4 usec _6 := sql.bind("sys","relation_members_way","relation",1); | | 18 usec _8 := algebra.kunion(:bat[:oid,:int][435327],:bat[:oid,:int][0]); | | 3 usec _1 := nil; | | 3 usec _6 := nil; | | 4 usec _9 := sql.bind("sys","relation_members_way","relation",2); | | 6 usec _11 := algebra.kdifference([435327],:bat[:oid,:int][0]); | | 9 usec _8 := nil; | | 5 usec _12 := algebra.kunion([435327],:bat[:oid,:int][0]); | | 4 usec _11 := nil; | | 2 usec _9 := nil; | | 4 usec _13 := sql.bind_dbat("sys","relation_members_way",1); | | 5 usec _14 := bat.reverse(:bat[:oid,:oid][0]); | | 2 usec _13 := nil; | | 6 usec _15 := algebra.kdifference([435327],<~tmp_3005>[0]); | | 4 usec _16 := sql.bind("sys","relation_members_way","to_way",0); | | 3 usec _18 := sql.bind("sys","relation_members_way","to_way",1); | | 7 usec _19 := algebra.kunion(:bat[:oid,:int][435327],:bat[:oid,:int][0]); | | 3 usec _16 := nil; | | 2 usec _18 := nil; | | 3 usec _20 := sql.bind("sys","relation_members_way","to_way",2); | | 6 usec _21 := algebra.kdifference([435327],:bat[:oid,:int][0]); | | 4 usec _19 := nil; | | 5 usec _22 := algebra.kunion([435327],:bat[:oid,:int][0]); | | 4 usec _21 := nil; | | 2 usec _20 := nil; | | 6 usec _23 := algebra.kdifference([435327],<~tmp_3005>[0]); | | 3 usec _22 := nil; | | 3 usec _14 := nil; | | 5 usec _24 := sql.bind("sys","ways","id",0); | | 3 usec _27 := sql.bind("sys","ways","id",1); | | 7 usec _28 := algebra.kunion(:bat[:oid,:int][22859478],:bat[:oid,:int][0]); | | 3 usec _24 := nil; | | 2 usec _27 := nil; | | 3 usec _29 := sql.bind("sys","ways","id",2); | | 7 usec _30 := algebra.kdifference([22859478],:bat[:oid,:int][0]); | | 4 usec _28 := nil; | | 6 usec _31 := algebra.kunion([22859478],:bat[:oid,:int][0]); | | 4 usec _30 := nil; | | 2 usec _29 := nil; | | 3 usec _32 := sql.bind_dbat("sys","ways",1); | | 3 usec _33 := bat.reverse(:bat[:oid,:oid][0]); | | 2 usec _32 := nil; | | 6 usec _34 := algebra.kdifference([22859478],<~tmp_3005>[0]); | | 3 usec _33 := nil; | | 2 usec _35 := bat.reverse([22859478]); | | 2 usec _34 := nil; | | 184167 usec _36 := algebra.join([435327],<~tmp_3357>[22859478]); | | 12 usec _23 := nil; | | 4 usec _35 := nil; | | 8 usec _38 := algebra.markT([435282],0@0); | | 14940 usec _39 := algebra.kdifference([435327],[435282]); | | 15 usec _15 := nil; | | 10 usec _40 := algebra.markT([45],0@0); | | 3 usec _39 := nil; | | 4 usec _41 := bat.reverse([45]); | | 2 usec _40 := nil; | | 12 usec _43 := algebra.project(<~tmp_3376>[45],nil); | | 2 usec _44 := bat.reverse([435282]); | | 2 usec _36 := nil; | | 14 usec _45 := algebra.markT(<~tmp_3402>[435282],0@0); | | 2 usec _44 := nil; | | 3 usec _46 := bat.reverse([435282]); | | 2 usec _45 := nil; | | 10069 usec _47 := algebra.join(<~tmp_3404>[435282],[22859478]); | | 10 usec _46 := nil; | | 4 usec _31 := nil; | | 1 usec exit _83; | | 2660 usec bat.append([435327],[45],true); | | 26 usec _43 := nil; | | 656 usec _50 := algebra.uselect([435327],nil); | | 5 usec _47 := nil; | | 11 usec _51 := algebra.markT([45],0@0); | | 2 usec _50 := nil; | | 4 usec _52 := bat.reverse([45]); | | 2 usec _51 := nil; | | 17 usec _53 := algebra.join(<~tmp_3376>[45],[435327]); | | 1475 usec _41 := nil; | | 4 usec _54 := bat.reverse([435282]); | | 2 usec _38 := nil; | | 2052 usec _55 := algebra.join(<~tmp_3357>[435282],[435327]); | | 337242 usec _54 := nil; | | 17 usec _12 := nil; | | 1572 usec bat.append([435327],[45],true); | | 9 usec _53 := nil; | | 19 usec _57 := algebra.join(<~tmp_3373>[45],[435327]); | | 3826 usec _52 := nil; | | 8 usec _55 := nil; | | 6 usec _58 := bat.reverse([45]); | | 13 usec _59 := algebra.kunique(<~tmp_3400>[45]); | | 3 usec _58 := nil; | | 2 usec _60 := bat.reverse([29]); | | 2 usec _59 := nil; | | 11 usec _61 := bat.mirror(<~tmp_3150>[29]); | | 3 usec _60 := nil; | | 30 usec _62 := algebra.join([29],[45]); | | 5 usec _61 := nil; | | 3 usec _57 := nil; | | 7 usec _63 := sql.resultSet(1,1,[29]); | | 7 usec sql.rsColumn(51,"sys.relation_members_way","relation","int",32,0,[29]); | | 3 usec _62 := nil; | | 2 usec _68 := io.stdout(); | +---------------------------------------------------------------------------------------------------------------------------------------------+ | 4788 | | 8790 | | 8867 | | 10717 | | 18162 | | 18443 | | 20496 | | 20869 | | 20990 | | 21359 | | 22309 | | 22488 | | 27416 | | 28945 | | 30893 | | 35183 | | 36191 | | 36739 | | 36857 | | 36891 | | 36947 | | 37703 | | 37728 | | 38718 | | 41778 | | 42047 | | 48130 | | 49377 | | 50556 | | 33 usec sql.exportResult(43426160,51,""); | | 562735 usec user.s33_1(); | +---------------------------------------------------------------------------------------------------------------------------------------------+