16.00 - Explain Tab for Teradata Aster - Teradata Viewpoint

Teradata Viewpoint User Guide

Teradata Viewpoint
October 2016
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.