[Monetdb-developers] Another big group by query

Stefan de Konink stefan at konink.de
Mon Apr 13 02:30:44 CEST 2009


Martin Kersten wrote:
> You can trace the execution even for a server started already using
> the stethoscope.

p[ 605303,      mt,     # name
[ 51,    "_30 := bat.mirror(ext35=<tmp_4076>[362105182]);" ]
[ 1282955,       "grp20 := nil;"]
[ 13,   955,     "grp20 := nil;" ]
[ 13,    "ext35 := nil;" ]
[ 103806553,     "_31 := 
aggr.count(_17=<tmp_4101>[365652137],grp33=<tmp_3722>[365652137],_30=<tmp_4021>[362105182]);" 
]
[ 14,    "_17 := nil;" ]
[ 1088736,       "grp33 := nil;" ]
[ 2605761,       "_33 := 
algebra.thetauselect(_31=<tmp_3737>:bat[:oid,:wrd][362105182],_32=2:wrd,">");" 
]
[ 45,    "_36 := algebra.markT(_33=<tmp_4024>[6054],0 at 0);" ]
[ 7,     "_37 := bat.reverse(_36=<tmp_3722>[6054]);" ]
[ 8,     "_33 := nil;" ]
[ 9,     "_36 := nil;" ]
[ 17917,         "_38 := 
algebra.join(_37=<tmpr_3722>[6054],_31=<tmp_3737>:bat[:oid,:wrd][362105182]);" 
]
[ 1283903,       "_31 := nil;" ]
[ 1314255,       "_39 := 
algebra.joinPath(_37=<tmpr_3722>[6054],_30=<tmp_4021>[362105182],_16=<tmp_4101>[365652137]);" 
]
[ 1314255,       "_40 := 
algebra.joinPath(_37=<tmpr_3722>[6054],_30=<tmp_4021>[362105182],_27=<tmp_3742>[365652137]);" 
]
[ 67,    "_37 := nil;" ]
[ 967626,        "_27 := nil;" ]
[ 1205150,       "_16 := nil;" ]
[ 1360389,       "_30 := nil;" ]
[ 28,    "_41 := sql.resultSet(3,1,_38=<tmp_3736>[6054]);" ]
[ 10, 
"sql.rsColumn(_41=32,"sys.way_nds","L6","wrd",32,0,_38=<tmp_3736>[6054]);" ]
[ 7,     "_38 := nil;" ]
[ 6, 
"sql.rsColumn(_41=32,"sys.way_nds","way","int",32,0,_39=<tmp_4103>[6054]);" 
]
[ 2,     "_39 := nil;" ]
[ 5, 
"sql.rsColumn(_41=32,"sys.way_nds","to_node","int",32,0,_40=<tmp_4100>[6054]);" 
]
[ 2,     "_40 := nil;" ]
[ 2,     "_51 := io.stdout();" ]
[ 12489,         "sql.exportResult(_51=27443088,_41=32);" ]
[ 2,     "end s27_1;" ]



Stefan




More information about the developers-list mailing list