sql>trace Select distinct relation from relation_members_way where to_way not in (select id from ways);
|       5 usec      mdb.setTimer(true);                                                                                                       |
|      13 usec  barrier _76 := language.dataflow();                                                                                           |
|      10 usec      _1 := sql.bind("sys","relation_members_way","to_way",0);                                                                  |
|     698 usec      _7 := algebra.selectNotNil(<tmp_3303>:bat[:oid,:int][435327]);                                                            |
|       7 usec      _1 := nil;                                                                                                                |
|       8 usec      _8 := sql.bind("sys","relation_members_way","to_way",1);                                                                  |
|       4 usec      _10 := algebra.selectNotNil(<tmp_3003>:bat[:oid,:int][0]);                                                                |
|       2 usec      _8 := nil;                                                                                                                |
|      18 usec      _11 := algebra.kunion(<tmp_3303>[435327],<tmp_3003>[0]);                                                                  |
|       3 usec      _7 := nil;                                                                                                                |
|       2 usec      _10 := nil;                                                                                                               |
|       4 usec      _12 := sql.bind("sys","relation_members_way","to_way",2);                                                                 |
|       7 usec      _14 := algebra.kdifference(<tmp_3373>[435327],<tmp_3002>:bat[:oid,:int][0]);                                              |
|       8 usec      _11 := nil;                                                                                                               |
|       2 usec      _15 := algebra.selectNotNil(<tmp_3002>:bat[:oid,:int][0]);                                                                |
|       2 usec      _12 := nil;                                                                                                               |
|       6 usec      _16 := algebra.kunion(<tmp_3376>[435327],<tmp_3002>[0]);                                                                  |
|       4 usec      _14 := nil;                                                                                                               |
|       3 usec      _15 := nil;                                                                                                               |
|       5 usec      _17 := sql.bind_dbat("sys","relation_members_way",1);                                                                     |
|       4 usec      _18 := bat.reverse(<tmp_3005>:bat[:oid,:oid][0]);                                                                         |
|       2 usec      _17 := nil;                                                                                                               |
|       7 usec      _19 := algebra.kdifference(<tmp_3373>[435327],<~tmp_3005>[0]);                                                            |
|       4 usec      _16 := nil;                                                                                                               |
|       2 usec      _18 := nil;                                                                                                               |
|       9 usec      _20 := sql.bind("sys","ways","id",0);                                                                                     |
|       3 usec      _23 := sql.bind("sys","ways","id",1);                                                                                     |
|       8 usec      _24 := algebra.kunion(<tmp_1136>:bat[:oid,:int][22859478],<tmp_3003>:bat[:oid,:int][0]);                                  |
|       3 usec      _20 := nil;                                                                                                               |
|       3 usec      _23 := nil;                                                                                                               |
|       3 usec      _25 := sql.bind("sys","ways","id",2);                                                                                     |
|       5 usec      _26 := algebra.kdifference(<tmp_3373>[22859478],<tmp_3002>:bat[:oid,:int][0]);                                            |
|       4 usec      _24 := nil;                                                                                                               |
|       5 usec      _27 := algebra.kunion(<tmp_3357>[22859478],<tmp_3002>:bat[:oid,:int][0]);                                                 |
|       3 usec      _26 := nil;                                                                                                               |
|       2 usec      _25 := nil;                                                                                                               |
|       4 usec      _28 := sql.bind_dbat("sys","ways",1);                                                                                     |
|       3 usec      _29 := bat.reverse(<tmp_3005>:bat[:oid,:oid][0]);                                                                         |
|       2 usec      _28 := nil;                                                                                                               |
|       6 usec      _30 := algebra.kdifference(<tmp_3373>[22859478],<~tmp_3005>[0]);                                                          |
|       3 usec      _29 := nil;                                                                                                               |
|       7 usec      _32 := algebra.markT(<tmp_3357>[22859478],0@0);                                                                           |
|       3 usec      _30 := nil;                                                                                                               |
|       2 usec      _33 := bat.reverse(<tmp_3400>[22859478]);                                                                                 |
|       2 usec      _32 := nil;                                                                                                               |
|      19 usec      _34 := algebra.join(<~tmp_3400>[22859478],<tmp_3373>[22859478]);                                                          |
|       5 usec      _33 := nil;                                                                                                               |
|       3 usec      _27 := nil;                                                                                                               |
|       2 usec  exit _76;                                                                                                                     |
|       6 usec      _35 := bat.new(nil,nil);                                                                                                  |
|  540655 usec      bat.append(<tmp_3375>:bat[:oid,:int][22859478],<tmp_3374>[22859478],true);                                                |
|       8 usec  barrier _79 := language.dataflow();                                                                                           |
|      12 usec      _34 := nil;                                                                                                               |
|       4 usec      _39 := bat.reverse(<tmp_3375>:bat[:oid,:int][22859478]);                                                                  |
|       3 usec      _35 := nil;                                                                                                               |
|  169990 usec      _40 := algebra.join(<tmp_3376>[435327],<~tmp_3375>[22859478]);                                                            |
|       8 usec      _39 := nil;                                                                                                               |
|   14703 usec      _41 := algebra.kdifference(<tmp_3376>[435327],<tmp_3374>[435282]);                                                        |
|      15 usec      _19 := nil;                                                                                                               |
|  343851 usec      _40 := nil;                                                                                                               |
|      23 usec      _42 := algebra.markT(<tmp_3373>[45],0@0);                                                                                 |
|       3 usec      _41 := nil;                                                                                                               |
|       4 usec      _43 := bat.reverse(<tmp_3374>[45]);                                                                                       |
|       2 usec      _42 := nil;                                                                                                               |
|      27 usec      _44 := sql.bind("sys","relation_members_way","relation",0);                                                               |
|       4 usec      _46 := sql.bind("sys","relation_members_way","relation",1);                                                               |
|      13 usec      _47 := algebra.kunion(<tmp_3300>:bat[:oid,:int][435327],<tmp_3003>:bat[:oid,:int][0]);                                    |
|       3 usec      _44 := nil;                                                                                                               |
|       2 usec      _46 := nil;                                                                                                               |
|       4 usec      _48 := sql.bind("sys","relation_members_way","relation",2);                                                               |
|       7 usec      _49 := algebra.kdifference(<tmp_3376>[435327],<tmp_3002>:bat[:oid,:int][0]);                                              |
|       7 usec      _47 := nil;                                                                                                               |
|       5 usec      _50 := algebra.kunion(<tmp_3400>[435327],<tmp_3002>:bat[:oid,:int][0]);                                                   |
|       3 usec      _49 := nil;                                                                                                               |
|       2 usec      _48 := nil;                                                                                                               |
|      37 usec      _51 := algebra.join(<~tmp_3374>[45],<tmp_3376>[435327]);                                                                  |
|    1494 usec      _43 := nil;                                                                                                               |
|       4 usec      _50 := nil;                                                                                                               |
|       3 usec      _52 := bat.reverse(<tmp_3400>[45]);                                                                                       |
|      11 usec      _53 := algebra.kunique(<~tmp_3400>[45]);                                                                                  |
|       3 usec      _52 := nil;                                                                                                               |
|       2 usec      _54 := bat.reverse(<tmp_3150>[29]);                                                                                       |
|       2 usec      _53 := nil;                                                                                                               |
|       7 usec      _55 := bat.mirror(<~tmp_3150>[29]);                                                                                       |
|       2 usec      _54 := nil;                                                                                                               |
|      24 usec      _56 := algebra.join(<tmp_3376>[29],<tmp_3400>[45]);                                                                       |
|       5 usec      _55 := nil;                                                                                                               |
|       2 usec      _51 := nil;                                                                                                               |
|       2 usec  exit _79;                                                                                                                     |
|       5 usec      _57 := sql.resultSet(1,1,<tmp_3163>[29]);                                                                                 |
|       7 usec      sql.rsColumn(50,"sys.relation_members_way","relation","int",32,0,<tmp_3163>[29]);                                         |
|       3 usec      _56 := nil;                                                                                                               |
|       2 usec      _62 := 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                                                                                                                                      |
|      32 usec      sql.exportResult(43426160,50,"");                                                                                         |
|  1441315 usec      user.s32_1();                                                                                                            |
+---------------------------------------------------------------------------------------------------------------------------------------------+