[
https://issues.apache.org/jira/browse/PHOENIX-2178?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15332982#comment-15332982
]
Pranavan commented on PHOENIX-2178:
-----------------------------------
Colin has opened a jira for the nano time granularity. I am working on it. The
jira link in HTrace - https://issues.apache.org/jira/browse/HTRACE-376
> 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)
