[ https://issues.apache.org/jira/browse/PHOENIX-2178?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15198230#comment-15198230 ]
Ashish Tiwari commented on PHOENIX-2178: ---------------------------------------- [~jamestaylor] > Tracing - total time listed for a certain trace does not correlate with query > wall clock time > --------------------------------------------------------------------------------------------- > > Key: PHOENIX-2178 > URL: https://issues.apache.org/jira/browse/PHOENIX-2178 > Project: Phoenix > Issue Type: Sub-task > Affects Versions: 4.5.0 > Reporter: Mujtaba Chohan > Labels: gsoc2016, tracing > > Wall clock for a count * takes over a large table takes 30000+ms however > total sum(end_time - start_time) is less than 250ms for trace_id generated > for this count * query. > {code} > Output of trace table: > select sum(end_time - start_time),count(*), description from > SYSTEM.TRACING_STATS WHERE TRACE_ID=X group by description; > +------------------------------------------+------------------------------------------+------------------------------------------+ > | SUM((END_TIME - START_TIME)) | COUNT(1) > | DESCRIPTION | > +------------------------------------------+------------------------------------------+------------------------------------------+ > | 0 | 3 > | ClientService.Scan | > | 240 | 253879 > | HFileReaderV2.readBlock | > | 1 | 1 > | Scanner opened on server | > +------------------------------------------+------------------------------------------+------------------------------------------+ > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)