[DRILL-5352] Extend test framework profile parser printer for multi-fragment queries

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.10.0
• Fix Version/s: 1.11.0
• Labels: ready-to-commit
• Assignee: Paul Rogers
• Reporter: Paul Rogers
• Reviewer: Boaz Ben-Zvi
• Created: 14/Mar/17 03:17
• Updated: 20/Mar/17 19:54
• Resolved: 20/Mar/17 19:54

Description

The recently added test framework has a tool called the ProfileParser which started as a tool for analyzing run times of single-fragment queries. Over time, it evolved to compare planned and actual cost for multi-fragment queries.

This ticket requests that multi-fagment support be added to the printing of run times.

If a query is single-thread, print the query as in the prior version:

Op: 0 Screen
  Setup:   0 - 0%, 0%
  Process: 35 - 0%, 0%
  Wait:    16
  Memory: 10
Op: 1 Project
  Setup:   22 - 1%, 0%
  Process: 41 - 0%, 0%
  Memory: 5
...

If the query is multi-fragment and forms a tree, use the format used to display planning vs. actual info:

03-09 . . Project
                              Setup:        0 ms -   0%,   0%
                              Process:      0 ms -   0%,   0%
03-10 . . HashJoin (HASH JOIN)
                              Setup:        0 ms -   0%,   0%
                              Process: 5,097,619 ms - 326770%,  73%
03-12 . . . . Project
                              Setup:       36 ms -   2%,   0%
                              Process:    180 ms -  11%,   0%

Issue Links

• links to: GitHub Pull Request #782