15.10 - QryLogExplainDocV - 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

ExplainTextDoc

CLOB

X(64000)

DBQLExplainTbl.ExplainText

Note: ExplainTextDoc is a result of combining multiple DBQLExplainTbl.ExplainText rows with the same QueryID.

QryLogExplainDocV provides a view into DBQLExplainTbl that combines multiple rows of ExplainText with the same QueryID into a single ExplainTextDoc document.

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

.export file=explaindoc.txt;
SELECT explaintextdoc FROM QryLogExplainDocV where QueryID=307199040105795996;
.export reset;

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