15.00 - Database Query Log Tables and Views - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
English (United States)

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.