Database Query Log Tables and Views | BEGIN QUERY LOGGING | Teradata Vantage - 17.10 - Database Query Log Tables and Views - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1184-171K
Language
English (United States)

The tables and views that log SQL query data are in the data dictionary. For definitions of the query log tables, see Teradata Vantage™ - Data Dictionary, B035-1092. The following table provides a summary of log tables for tables and views.

Object Type Dictionary Object Name Description
Table DBC.DBQLExplainTbl 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.DBQLXMLLockTbl Logs lock contentions that exceed threshold.
DBC.DBQLXMLTbl Stores the Optimizer query plan for the logged query as an XML document.
View DBC.DBQLRulesV A view of DBC.DBQLRuleTbl.
DBC.QryLockLogXMLV A view of DBC.DBQLXMLLockTbl.
DBC.QryLogExplainV A view of DBQLExplainTbl.
DBC.QryLogObjectsV A view of DBQLObjTbl.
DBC.QryLogSQLV A view of DBQLSQLTbl.
DBC.QryLogStepsV A view of DBQLStepTbl.
DBC.QryLogSummaryV A view of DBQLSummaryTbl.
DBC.QryLogTDWMV A view of DBQLogTbl.
DBC.QryLogV A view of DBC.DBQLogTbl.
DBC.QryLogXMLV A view of DBQLXMLTbl.