[
https://issues.apache.org/jira/browse/IMPALA-13137?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17874108#comment-17874108
]
Surya Hebbar commented on IMPALA-13137:
---------------------------------------
IMPALA-13137: Add additional client fetch metrics columns to the queries page
For helping users to better understand query execution times,
the following columns have been added to the queries page.
- First Fetch (First row fetched)
- Client Fetch Duration (Client Fetch Wait Timer's value)
The duration needed to fetch the first row is already present in the
query state record. This timestamp has to be found by matching the label
"First row fetched" within the query state record's 'event_sequence'.
The time taken for the client to fetch all rows since the first row is
monitored by the "ClientFetchWaitTimer" in client request state.
To incorporate this into the query state record, the following
new attribute has been added.
- client_fetch_wait_time_ns
In order to constantly retrieve and update this value, a new method has
been added to expose the private counter holding "ClientFetchWaitTimer".
The duration for both these columns is printed in human readable format,
i.e. seconds, minutes, hours, etc., after converting from nanoseconds.
Tips for the two additional columns, mentioning relation between the
profile's labels and column names have also been added to the queries
page.
Change-Id: I74a9393a7b38750de0c3f6230b6e5e048048c4b5
Reviewed-on: http://gerrit.cloudera.org:8080/21482
Reviewed-by: Impala Public Jenkins <[email protected]>
Tested-by: Impala Public Jenkins <[email protected]>
> Add additional client fetch metrics columns to the queries page
> ---------------------------------------------------------------
>
> Key: IMPALA-13137
> URL: https://issues.apache.org/jira/browse/IMPALA-13137
> Project: IMPALA
> Issue Type: New Feature
> Components: Backend
> Reporter: Surya Hebbar
> Assignee: Surya Hebbar
> Priority: Major
> Fix For: Impala 4.5.0
>
> Attachments: completed_queries_new_column_names.png,
> completed_query.png, in_flight_queries_new_column_names.png,
> in_flight_query_1.png, in_flight_query_2.png, in_flight_query_3.png,
> very_short_fetch_timer.png
>
>
> For helping users to better understand query execution times, it would be
> helpful to add the following columns on the queries page.
> * First row fetched time - Time taken for the client to fetch the first row
> * Client fetch wait time - Time taken for the client to fetch all rows
> Additional details -
> https://jira.cloudera.com/browse/DWX-18295
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
