Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-5352

Extend test framework profile parser printer for multi-fragment queries

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.10.0
    • Fix Version/s: 1.11.0
    • Component/s: None
    • Labels:

      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%
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                paul-rogers Paul Rogers
                Reporter:
                paul-rogers Paul Rogers
                Reviewer:
                Boaz Ben-Zvi
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: