Re: Explain analyze

sql>trace select 1; +--------------+ | single_value | +==============+ | 1 | +--------------+ 1 tuple (3.545ms) +-------+--------------------------------------------------------------------------------------+ | ticks | statement | +=======+======================================================================================+ | 1 | X_10=0@0:void := querylog.define("trace select 1;":str,"default_pipe":str,4:int); | | 6 | sql.resultSet(".L":str,"single_value":str,"tinyint":str,8:int,0:int,7:int,A0=1:bte); | | 1 | end user.s2_1; | | 751 | function user.s2_1{autoCommit=true}(A0:bte):void; | | 886 | X_4=0@0:void := user.s2_1(1:bte); | +-------+--------------------------------------------------------------------------------------+ 5 tuples (3.659ms) sql>select * from sys.tracelog(); +-------+---------------+---------------+--------+-------+-------+------+-------+--------+--------+--------+-------+--------------------------------------------------------------------------------------+ | event | clk | pc | thread | ticks | rrsmb | vmmb | reads | writes | minflt | majflt | nvcsw | stmt | +=======+===============+===============+========+=======+=======+======+=======+========+========+========+=======+======================================================================================+ | 0 | 10:37:07.375 | user.s2_1[1]5 | 3 | 1 | 53 | 0 | 0 | 0 | 0 | 0 | 0 | X_10=0@0:void := querylog.define("trace select 1;":str,"default_pipe":str,4:int); | | 1 | 10:37:07.375 | user.s2_1[2]5 | 3 | 6 | 53 | 0 | 0 | 80 | 10 | 0 | 0 | sql.resultSet(".L":str,"single_value":str,"tinyint":str,8:int,0:int,7:int,A0=1:bte); | | 2 | 10:37:07.375 | user.s2_1[3]5 | 3 | 1 | 53 | 0 | 0 | 0 | 0 | 0 | 0 | end user.s2_1; | | 3 | 10:37:07.375 | user.s2_1[0]5 | 3 | 751 | 53 | 0 | 0 | 0 | 0 | 0 | 0 | function user.s2_1{autoCommit=true}(A0:bte):void; | | 4 | 10:37:07.375 | user.main[3]4 | 3 | 886 | 53 | 0 | 0 | 0 | 0 | 0 | 0 | X_4=0@0:void := user.s2_1(1:bte); | +-------+---------------+---------------+--------+-------+-------+------+-------+--------+--------+--------+-------+--------------------------------------------------------------------------------------+ 5 tuples (4.906ms) ----- On May 1, 2016, at 9:12 PM, Shmagi Kavtaradze kavtaradze.s@gmail.com wrote:

Still not sure how to do it. Tried "TRACE inblock, outblock from (select bitand(a.sentddec, b.sentddec) as res from chunks10000 a, chunks10000 b where a.chunkid=b.chunkid AND a.sentid

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |