Details Views - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide

Product
Teradata Viewpoint
Teradata Workload Management
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2022-06-28
dita:mapPath
lks1628075605455.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
B035-2206
lifecycle
previous
Product Category
Analytical Ecosystem

There are two Query details views:

Query Details by State
Displays summary information about sessions in columns.
Filters
Shows only rows that match your filter criteria.
Table Actions
For Teradata Database systems, table actions include:
  • Clear Filters removes any content in the filter boxes.
  • Configure Columns allows you to choose the columns to display.
    Changing the Configure Columns settings on one system changes the settings on all systems.
  • Abort, Change Priority, Change Workload, and Release Query allow you to manage the selected queries and sessions.
  • Export creates a .csv file containing all available data. If filters are used, only filtered data is exported.
For Teradata Aster systems, table actions include:
  • Clear Filters removes any content in the filter boxes.
  • Configure Columns allows you to choose the columns to display.
    Changing the Configure Columns settings on one system changes the settings on all systems.
  • Abort Process allows you to abort the selected non-idle process.
  • Export creates a .csv file containing all available data. If filters are used, only filtered data is exported.

For more information on Clear Filters, Configure Columns, and Export table actions, see Summary Table Controls.

Query Details by Session
Displays details of the selected query in sections that are specific to each tab.
Tabs
Teradata Database systems have Overview, SQL, Explain, Skew, Query Band, Blocking, Blocked By, Defer, and Delay tabs.
Teradata Aster systems have Overview, SQL, and Explain tabs.
Teradata Machine Learning Engine systems have Overview, SQL, and Explain tabs.
Show Details
Shows the Query Details by Session view.
Hide Details
Hides the Query Details by Session view.
Pause Refresh
Pauses the refreshing of data, allowing you to view the data in all tabs in the Query Details by Session view. The Query Details by State view is not affected by using this control.
Resume Refresh
Resumes bringing the most recent data from the Viewpoint server to all tabs in the Query Details by Session view.