Details Views - Teradata Viewpoint

There are two Query details views:

Query Details by State

Displays summary information about sessions in columns.

Filters

Displays data by showing only rows that match your filter criteria. Click the column headers to sort data in ascending or descending order.

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.

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.