[
https://issues.apache.org/jira/browse/PHOENIX-2178?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15198477#comment-15198477
]
James Taylor commented on PHOENIX-2178:
---------------------------------------
Thanks, [~ashishtiwari88] - we appreciate the proposal. A good way to find
things in Phoenix is to use the search box on our home page:
http://phoenix.apache.org/. When you enter "tracing" there, the first hit that
comes up is our documentation for this feature. Another good way is to search
in JIRA for any issue containing the word "tracing" in the summary. This will
point you to the git commits that were made to build this feature. HTH.
[~mujtabachohan] - would you mind advising [~ashishtiwari88] and reviewing the
proposal?
> 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)
