15.10 - QryLogExplainV - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

Query

DBC

 

View Column

Data Type

Format

Source Table.Column

ProcID

DECIMAL(5,0)

NOT NULL

-(5)9 (explicit)

DBQLExplainTbl.ProcID (Composite NUPI)

CollectTimestamp

TIMESTAMP(6)

NOT NULL

YYYY-MM-DDBHH:MI:SS

DBQLExplainTbl.CollectTimeStamp (Composite NUPI)

QueryID

DECIMAL(18,0)

NOT NULL

--Z(17)9

DBQLExplainTbl.QueryID

ExpRowNo

INTEGER

NOT NULL

--,---,---,--9 (explicit)

DBQLExplainTbl.ExpRowNo

ExplainText

VARCHAR (31000)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(31000)

DBQLExplainTbl.ExplainText

Because the explain can be larger than 31,000 characters, it may use multiple rows to hold the data.

The following SELECT statement retrieves the QueryID and ExplainText for a particular QueryID.

SELECT Queryid, Explaintext 
FROM QryLogExplainV WHERE Queryid = 201205134619838011;

Note: The output from the SELECT statement (the ExplainText) does not contain any format; it is just one long string.