16.50 - Explain Tab for Teradata Aster - Teradata Workload Management

Teradata® Viewpoint User Guide

Teradata Viewpoint
Teradata Workload Management
January 2021
User Guide

The Explain tab 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. You can also export Explain data.

To view all steps and phase details, click Show all. Alternatively, click Show summary 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.