16.10 - View of the EXPLAIN Log Table: QryLogExplain[V] - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Release Date
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)

The QryLogExplain[V] view is populated if the WITH EXPLAIN option is requested in addition to the information row. The following table describes the fields in QryLogExplain[V].

QryLogExplain[V] Field Description
CollectTimestamp Time that the rows were written to the database. This field is also part of the multicolumn NUPI (also see ProcID).
ExplainText Full Explain text segment.

The text is not formatted and appears as a single long string. You may need to program a parsing application to look at the text.

ExpRowNo Used if Explain text is greater than 31,000 characters and the system generates multiple rows.
ProcID Unique processor ID of the Dispatcher and part of the multi-column NUPI (also see CollectTimeStamp).
QueryID Internally generated identifier of the query and the FK to other DBQL tables.
QueryID is a system-wide unique field; You can use QueryID to join DBQL tables or the DBC.TdwmExceptionLog table with DBQL tables without needing ProcID as an additional join field.