Hi, > Are the fields in the trace file documented? Like so: > /*SQL l:1829 #:564 t:5*/ > What are l, #, and t?
The fields are not documented, except in the source code (Trace.java). They are: length of statement, number (count) and time. > Is "time" the wall-clock time, or cpu time given to h2? It is wall-clock time. You can't easily get the CPU time in Java. > How are self & accu related to time? What are they percentages of? Do you know java -Xrunhprof? It's basically the same. See http://docs.oracle.com/javase/7/docs/technotes/samples/hprof.html Regards, Thomas On Mon, Oct 7, 2013 at 8:54 PM, Brian Craft <[email protected]> wrote: > Also not sure what the translated stats mean > > -- SQL Statement Statistics > -- time: total time in milliseconds (accumulated) > -- count: how many times the statement ran > -- result: total update count or row count > ----------------------------------------- > -- self accu time count result sql > -- 86% 86% 8936 257 1542 SELECT [snipped ....] > -- 13% 99% 1360 264 148896 SELECT [snipped ....] > -- 0% 100% 25 249 249 SELECT [snipped ....] > > Is "time" the wall-clock time, or cpu time given to h2? > > How are self & accu related to time? What are they percentages of? > > On Monday, October 7, 2013 11:18:24 AM UTC-7, Brian Craft wrote: >> >> Are the fields in the trace file documented? Like so: >> >> /*SQL l:1829 #:564 t:5*/ >> >> What are l, #, and t? >> >> >> -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/groups/opt_out. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
