phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pranavan (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, 16 Jun 2016 15:39:05 GMT

    [ https://issues.apache.org/jira/browse/PHOENIX-2178?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15334009#comment-15334009
] 

Pranavan commented on PHOENIX-2178:
-----------------------------------

I made a PR to HR - https://github.com/apache/incubator-htrace/pull/10/files. We can merge
the PR - https://github.com/apache/phoenix/pull/173 after it gets merged.

> 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