15.00 - Database Query Log Tables and Views - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

Database Query Log Tables and Views

The tables and views that log SQL query data are in the data dictionary. The following table summarizes them.

 

Dictionary Object Name

Object Type

Description

DBC.DBQLExplainTbl

Table

 

Stores the unformatted EXPLAIN text for a query.

DBC.DBQLObjTbl

Stores query object information.

DBC.DBQLogTbl

Stores default rows for the Database Query Log, including Query Band information.

DBC.DBQLRuleCountTbl

Stores the cardinality of DBQLRuleTbl.

DBC.DBQLRuleTbl

Stores the rules for the Database Query Log.

DBC.DBQLSqlTbl

Stores SQL query text.

DBC.DBQLStepTbl

Stores query step information.

DBC.DBQLSummaryTbl

Stores summary and threshold information for the logged query.

DBC.DBQLXMLTbl

Stores the Optimizer query plan for the logged query as an XML document.

DBC.DBQLRulesV

View

A view onto DBC.DBQLRuleTbl.

DBC.QryLogExplainV

A view onto DBQLExplainTbl.

DBC.QryLogObjectsV

A view onto DBQLObjTbl.

DBC.QryLogSQLV

A view onto DBQLSQLTbl.

DBC.QryLogStepsV

A view onto DBQLStepTbl.

DBC.QryLogSummaryV

A view onto DBQLSummaryTbl.

DBC.QryLogTDWMV

A view onto DBQLogTbl.

DBC.QryLogV

A view onto DBC.DBQLogTbl.

DBC.QryLogXMLV

A view onto DBQLXMLTbl.

For details about the definitions of the query log tables, see Data Dictionary.