16.10 - Explain Log Table: DBQLExplainTbl - Teradata Database

Teradata Database Administration

Teradata Database
Release Number
April 2018
English (United States)
Last Update

This table is populated if the WITH EXPLAIN option is requested in addition to the default information row. If the additional Explain text is greater than 31,000 characters, multiple rows are generated.

DBC.DBQLExplainTbl 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).

For more information on CollectTimeStamp, see Comparing CollectTimeStamp Value Between Tables.

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.
ExpRowNo Used if Explain text is greater than 31,000 characters and the system generates multiple rows.
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.

If ExplainText has more than one row per QueryID, use the QryLogExplainDoc[V] view to see a single, readable document per QueryID. For more information, see Improving Explain Text Readability.