You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@impala.apache.org by "Tim Armstrong (Jira)" <ji...@apache.org> on 2020/01/21 21:29:00 UTC
[jira] [Resolved] (IMPALA-3005) Incorrect timings in query profile
possibly related to delayed fragment start
[ https://issues.apache.org/jira/browse/IMPALA-3005?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tim Armstrong resolved IMPALA-3005.
-----------------------------------
Resolution: Fixed
I think enough additional info has been added over time
{noformat}
Instance c642a53ab50757a5:ecb7491300000000 (host=tarmstrong-box:22000):(Total: 308.739ms, non-child: 535.985us, % non-child: 0.17%)
Last report received time: 2020-01-21 12:15:09.193
Fragment Instance Lifecycle Event Timeline: 308.947ms
- Prepare Finished: 489.920us (489.920us)
- Open Finished: 308.806ms (308.316ms)
- First Batch Produced: 308.825ms (19.077us)
- First Batch Sent: 308.827ms (2.438us)
- ExecInternal Finished: 308.947ms (119.347us) {noformat}
> Incorrect timings in query profile possibly related to delayed fragment start
> -----------------------------------------------------------------------------
>
> Key: IMPALA-3005
> URL: https://issues.apache.org/jira/browse/IMPALA-3005
> Project: IMPALA
> Issue Type: Bug
> Components: Backend
> Affects Versions: Impala 2.5.0
> Reporter: Mostafa Mokhtar
> Assignee: Henry Robinson
> Priority: Minor
> Labels: supportability
> Attachments: primitive_filter_string_selective.test.2.out
>
>
> The fragment reported time of 2s343ms is lower than min:8s749ms
> {code}
> Averaged Fragment F00:(Total: 2s343ms, non-child: 0.000ns, % non-child: 0.00%)
> split sizes: min: 10.63 GB, max: 10.97 GB, avg: 10.83 GB, stddev: 99.07 MB
> completion times: min:8s749ms max:11s273ms mean: 10s208ms stddev:753.549ms
> {code}
> Seems related to
> {code}
> Query Timeline: 14s410ms
> - Start execution: 39.252us (39.252us)
> - Planning finished: 25.859ms (25.820ms)
> - Ready to start 20 remote fragments: 282.288ms (256.428ms)
> - All 20 remote fragments started: 4s179ms (3s897ms)
> - Rows available: 14s358ms (10s178ms)
> - First row fetched: 14s400ms (42.847ms)
> - Unregister query: 14s404ms (3.513ms)
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)