Performance Information in DBQL Tables - Teradata Database

Teradata Database Administration
Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
Product Category
Software

Performance Information in DBQL Tables

 

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
    		•

    DBQLSummaryTbl

    A summary of short-running queries.

    For high-volume queries, it 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

    The complete SQL text.

    DBQLExplainTbl

    EXPLAIN output.

    DBQLXMLTbl

    Query plans stored in Extensible Markup Language (XML).