Job History & Job Details
New UI: If you’re running Dremio 18.0+, you may replace the existing Jobs screens with an updated and more interactive experience. For more information, see the new Jobs UI section below.
Navigating to the Job History page allows you to view all previously-run and ongoing queries as they are completed by Dremio. The table on the left lists jobs in chronological order, with columns providing minimal details about the job itself. Clicking on an individual row will expand that job on the right-hand side of the screen via the Job Details pane. This section of the screen provides a detailed breakdown of the query and its results.
New Jobs UI
Version Requirement: These new screens are only available via instances using Dremio v18.0+. The Job History and Job Details screens are replaced with a more interactive and visually-driven layout.
The Job History page acts as a dynamic and user-friendly interface through which you may view all previously-run queries and delve deep into a job’s details on a query-by-query basis.
Enabling the New UI
This functionality is enabled by default with Dremio v19.0+ and the steps below do not need to be performed.
By default, this new layout is disabled and must be activated manually. To enable the new UI and replace the existing Job History and Job Details pages, use the support key
This will be automatically enabled in a future version of Dremio.
Interacting with Jobs
The term “job” is used to describe an individual query run using Dremio. Thus this page displays a list of all previously-run jobs for the previous XX days. The ordering of these jobs may be manipulated by column data in ascending or descending order.
- To change columns to sort jobs in ascending or descending order, click on the desired column name at the top of the Query Visualizer table. This will change the table’s sorting from ascending to descending, or vice versa.
- To display or hide individual columns on the Query Visualizer, click on the Columns button at the top-right corner of the screen next to the search bar. Then select the checkbox to the left of each column name you wish to see or remove. Changes are immediately made to the Visualizer with each selection.
- To change the order of individual columns, click on the Columns button. Then select the desired arrow to the right of the column name to change its order. The arrow pointing up will move the column further to the left on the Visualizer screen. Selecting the arrow pointing down will move the column to the right.
- To view specific details regarding an individual column for a job, hover your mouse over the desired row and column. This will immediately trigger a hover screen with brief details regarding that job, such as the SQL query used, a list of the datasets queried, or a breakdown of the query’s execution process.
- To launch the Job Details screen for an individual query, click on the desired job row from the Query Visualizer table.
Query Plan Visualizer
The Query Plan Visualizer offers a graphical representation of the SQL execution tree, effectively enabling users to see all resources used for an individual query, including nodes, reflections, and individual datasets. Those nodes deemed most expensive, meaning time-intensive, will appear more colorful, whereas the less-used resources will appear dimmed.
To access this resource:
- From the Jobs screen, select the desired completed job. This launches the Job Details page.
- Click the SQL tab at the top of the screen.
- Scroll down to the Dataset Graph section. This is where the query plan’s visual representation is located.
- See Workload Management for more information about Query Queues.