16.20.16.20 - 16.20 - Details Views - Teradata Workload Management

Teradata® Viewpoint User Guide

prodname
Teradata Viewpoint
Teradata Workload Management
vrm_release
16.20
category
User Guide
featnum
B035-2206-107K

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, 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.