[
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)
Under the "Full JSON Profile", display this in a formatted version (with proper
indentation). It is not very useful in the current, streamed, non-indented form.
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. (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)
> 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)
> Under the "Full JSON Profile", display this in a formatted version (with
> proper indentation). It is not very useful in the current, streamed,
> non-indented form.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
