Performance Information | Database Administration | VantageCloud Lake - Performance Information in DBQL Tables - Teradata VantageCloud Lake

Lake - Database Reference
Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
ohi1683672393549.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
ohi1683672393549
DBQL Table Performance Management Information
DBQLogTbl Data on individual queries, including:
  • Query origination, start, stop, and other timings
  • CPU and logical I/O usage
  • Error codes
  • SQL (truncated)
  • Step counts
  • Number of rows inserted, updated, and deleted
DBQLSummaryTbl Summary of short-running queries.

For high-volume queries, provides query origination, response time summaries, query counts, and CPU and logical I/O usage.
DBQLStepTbl Query step timings, CPU and I/O usage, row counts, and step actions, among other things
DBQLObjTbl Usage information about database objects such as tables, columns, indexes, and databases.
DBQLSqlTbl Complete SQL text.
DBQLExplainTbl EXPLAIN output.
DBQLXMLTbl Query plans stored in Extensible Markup Language (XML).