Explain View for Teradata Aster - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide

Product
Teradata Viewpoint
Teradata Workload Management
Release Number
16.50
16.20
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
yqb1520516846011.ditamap
dita:ditavalPath
yqb1520516846011.ditaval
dita:id
B035-2206
lifecycle
previous
Product Category
Analytical Ecosystem

The Explain view displays the Explain text that shows the progress of a query. Each Explain step has a colored box that indicates the status of the step. This information is read-only.

By default, all steps and details are displayed. Tap Show summary only to view a shortened version of the Explain data.
Step Information Description
Step Status Icon

Indicates the status of each Explain step:

  • Completed steps are at the top of the list and indicated by a black box.
  • Active steps are indicated by a pulsating box (flashes gray and white).
  • Steps to run are at the bottom of the list and indicated by a white box.
Time Duration of the step
Type Category of step, such as Command, CommitPreparedTransaction, DataTransfer, Import, PrepareTransaction, and Query
Phase/Detail Summarized or full explanation of query that executes in this step. Can be used to diagnose the cause of the failure or slowness.