Explain Log Table: DBQLExplainTbl - Teradata Database

Teradata Database Administration

Teradata Database
Release Number
English (United States)
Last Update
Product Category

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



Unique processor ID of the Dispatcher and part of the multi-column NUPI (also see 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” on page 380.


Internally generated identifier of the query and the FK to other DBQL tables.

Note: 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.


Used if Explain text is greater than 31,000 characters and the system generates multiple rows.


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.

Note: 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” on page 304.