You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "James Taylor (JIRA)" <ji...@apache.org> on 2015/08/13 17:37:45 UTC
[jira] [Updated] (PHOENIX-2178) Tracing - total time listed for a
certain trace does not correlate with query wall clock time
[ https://issues.apache.org/jira/browse/PHOENIX-2178?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
James Taylor updated PHOENIX-2178:
----------------------------------
Labels: Tracing (was: )
> 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: Bug
> Affects Versions: 4.5.0
> Reporter: Mujtaba Chohan
> Labels: 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)