16.10 - View of the EXPLAIN Log Table: QryLogExplainDoc[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 QryLogExplainDoc[V] view is populated if the WITH EXPLAIN option is requested in addition to the information row. QryLogExplainDoc[V] provides a view into DBQLExplainTbl that combines multiple rows of ExplainText with the same QueryID into a single ExplainTextDoc document.

The following table describes the fields in QryLogExplainDoc[V].

QryLogExplainDoc[V] Field Description
ProcID Unique processor ID of the Dispatcher and part of the multi-column NUPI (also see CollectTimeStamp).
CollectTimestamp Time that the rows were written to the database. This field is also part of the multicolumn NUPI (also see ProcID).
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.
ExplainTextDoc ExplainTextDoc combines multiple ExplainText rows with the same QueryID into a single document as CLOB type.