drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Paul Rogers (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-4909) Refinements to Drill web UI - Query profile page
Date Wed, 28 Sep 2016 02:25:20 GMT

     [ https://issues.apache.org/jira/browse/DRILL-4909?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Paul Rogers updated DRILL-4909:
-------------------------------
    Description: 
The top of the page displays histogram of minor fragment execution. However, it is hard to
infer what it displays.

* Label the x-axis. The units seem to be seconds, but a legend of: "Runtime (sec.)" would
help.
* Label the y-axis. Seems to be colored by major fragment, lines by minor fragment. But, took
some sleuthing to figure this out.
* Tooltip on each color band to identify the major fragment. (Probably too fiddly to label
minor fragment lines.)

In the tables:

* For each operator, list the number of rows processed. (Available in the details already.)
* In the table that sumarizes major fragments, have as a tool-tip the names of the minor fragments
to give the numbers some meaning. That is, hovering over 00-xx-xx should say "Project, Merging
Receiver".
* In the table that shows minor fragments for major fragments, either add a list of minor
fragment names to the title, or as a pop-up. That is, in the heading that says, "Major Fragment:
02-xx-xx", add "(PARQUET_ROW_GROUP_SCAN, PROJECT, ...)

In the Operator Profiles overview, add a tool-tip with details about each operator such as:

* Number of vector allocations
* Number of vector extensions (increasing the size of vectors)
* Average vector utilization (ratio of selected to unselected rows)
* Average batch size: number of rows, bytes per row, bytes per batch

For scanners:

* Number of files scanned
* Number of bytes read (or file length if a table scan)
* Name of the file scanned (or first several if a group)

For filters:

* Rows in, rows out and selectivity (as a ratio)

In the operator detail table:

* Add a line for totals (records, batches)
* Add a line for averages (most fields)


  was:
The top of the page displays histogram of minor fragment execution. However, it is hard to
infer what it displays.

* Label the x-axis. The units seem to be seconds, but a legend of: "Runtime (sec.)" would
help.
* Label the y-axis. Seems to be colored by major fragment, lines by minor fragment. But, took
some sleuthing to figure this out.
* Tooltip on each color band to identify the major fragment. (Probably too fiddly to label
minor fragment lines.)

In the tables:

* For each operator, list the number of rows processed.
* In the table that sumarizes major fragments, have as a tool-tip the names of the minor fragments
to give the numbers some meaning. That is, hovering over 00-xx-xx should say "Project, Merging
Receiver".
* In the table that shows minor fragments for major fragments, either add a list of minor
fragment names to the title, or as a pop-up. That is, in the heading that says, "Major Fragment:
02-xx-xx", add "(PARQUET_ROW_GROUP_SCAN, PROJECT, ...)

In the Operator Profiles overview, add a tool-tip with details about each operator such as:

* Number of vector allocations
* Number of vector extensions (increasing the size of vectors)
* Average vector utilization (ratio of selected to unselected rows)
* Average batch size: number of rows, bytes per row, bytes per batch

For scanners:

* Number of files scanned
* Number of bytes read (or file length if a table scan)

For filters:

* Rows in, rows out and selectivity (as a ratio)



> Refinements to Drill web UI - Query profile page
> ------------------------------------------------
>
>                 Key: DRILL-4909
>                 URL: https://issues.apache.org/jira/browse/DRILL-4909
>             Project: Apache Drill
>          Issue Type: Improvement
>          Components: Web Server
>    Affects Versions: 1.8.0
>            Reporter: Paul Rogers
>            Priority: Minor
>
> The top of the page displays histogram of minor fragment execution. However, it is hard
to infer what it displays.
> * Label the x-axis. The units seem to be seconds, but a legend of: "Runtime (sec.)" would
help.
> * Label the y-axis. Seems to be colored by major fragment, lines by minor fragment. But,
took some sleuthing to figure this out.
> * Tooltip on each color band to identify the major fragment. (Probably too fiddly to
label minor fragment lines.)
> In the tables:
> * For each operator, list the number of rows processed. (Available in the details already.)
> * In the table that sumarizes major fragments, have as a tool-tip the names of the minor
fragments to give the numbers some meaning. That is, hovering over 00-xx-xx should say "Project,
Merging Receiver".
> * In the table that shows minor fragments for major fragments, either add a list of minor
fragment names to the title, or as a pop-up. That is, in the heading that says, "Major Fragment:
02-xx-xx", add "(PARQUET_ROW_GROUP_SCAN, PROJECT, ...)
> In the Operator Profiles overview, add a tool-tip with details about each operator such
as:
> * Number of vector allocations
> * Number of vector extensions (increasing the size of vectors)
> * Average vector utilization (ratio of selected to unselected rows)
> * Average batch size: number of rows, bytes per row, bytes per batch
> For scanners:
> * Number of files scanned
> * Number of bytes read (or file length if a table scan)
> * Name of the file scanned (or first several if a group)
> For filters:
> * Rows in, rows out and selectivity (as a ratio)
> In the operator detail table:
> * Add a line for totals (records, batches)
> * Add a line for averages (most fields)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message