Database Query Log Tables and Views | BEGIN QUERY LOGGING | Teradata Vantage - Database Query Log Tables and Views - Analytics Database - Teradata Vantage

SQL Data Definition Language Detailed Topics

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1184
lifecycle
latest
Product Category
Teradata Vantage™

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.