I've read the runhprof docs, but it wasn't clear to me how it related to sql.
So, if accu is less than 100%, the rest of the time went where? Other threads, IO, etc.? Or is IO time counted against the query time? And if self is less than accu in hprof it has to do with sub-function execution time, I believe, but I'm not sure what it means in h2. Function calls? Subselects? Something else? None of these queries have function calls or subselects, so something else. What? On Monday, October 7, 2013 12:54:59 PM UTC-7, Thomas Mueller wrote: > > 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]<javascript:> > > 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] <javascript:>. >> To post to this group, send email to [email protected]<javascript:> >> . >> 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.
