[jira] [Created] (PHOENIX-2178) Tracing - total time listed for a certain trace does not correlate with query wall clock time

["Mujtaba Chohan (JIRA)" <ji...@apache.org>]

Mujtaba Chohan created PHOENIX-2178:
---------------------------------------

             Summary: 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


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)