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

Teradata® Viewpoint User Guide

Teradata Viewpoint
Teradata Workload Management
Release Number
Release Date
October 2021
Content Type
User Guide
Publication ID
English (United States)

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.