phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James Taylor (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-2178) Tracing - total time listed for a certain trace does not correlate with query wall clock time
Date Thu, 17 Mar 2016 00:29:33 GMT

    [ 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)

Mime
View raw message