16.10 - View of the XML Plan Log Table: QryLogXMLDocV - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Release Date
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)
In a future release, the XMLTextInfo column in DBQLXMLTbl will change its data type from VARCHAR to CLOB type casted to Teradata XML type. To ensure your applications remain compatible with this future enhancement, Teradata recommends using the QryLogXMLDocV view instead of QryLogXMLV.

This view of DBQLXMLTbl shows query plans and statistics usage information in an XML document. This view combines multiple rows of XMLTextInfo with the same QueryID into a single XMLTextDoc document.These BEGIN QUERY LOGGING or REPLACE QUERY LOGGING options populate the QryLogXMLDocV view:

  • WITH XMLPLAN
  • WITH STATSUSAGE
QryLogXMLDocV Field Description
CollectTimeStamp Date and time that the rows were written to the database. This field is also part of the multicolumn NUPI (see also ProcID).

For more information on CollectTimeStamp, see Comparing CollectTimeStamp Value Between Tables.

DetailedStatsEnabled Possible values include:
  • Y: Detailed statistics usage logging is enabled.
  • N: Detailed statistics usage logging is not enabled.
HasDetailedStatsData Possible values include:
  • Y: Detailed statistics usage data is in the XMLTextInfo column.
  • N: Detailed statistics usage data is not in the XMLTextInfo column.
HasStatsUsageData Possible values include:
  • Y: Statistics usage data is in the XMLTextInfo column.
  • N: Statistics usage data is not in the XMLTextInfo column.
HasVerboseData Possible values include:
  • Y: VERBOSE EXPLAIN data is in the XMLTextInfo column.
  • N: VERBOSE EXPLAIN data is not in the XMLTextInfo column.
HasXMLPlanData Possible values include:
  • Y: XMLPLAN data is in the XMLTextInfo column.
  • N: XMLPLAN data is not in the XMLTextInfo column.
ProcID Unique processor ID of the Dispatcher and part of the multi-column NUPI (also see CollectTimeStamp).
QueryID Internally generated unique identifier of the query.
StatsUsageEnabled Possible values include:
  • Y: Statistics usage logging is enabled.
  • N: Statistics usage logging is not enabled.
VerboseEnabled Possible values include:
  • Y: VERBOSE EXPLAIN logging is enabled.
  • N: VERBOSE EXPLAIN logging is not enabled.
XMLDocType Describes the type of content stored in column XMLTextInfo. This column contains an encoded 32-bit integer value whose bit positions describe the type of data in the associated XML document stored in the XMLTextInfo column. The XML DocType bit mask values are:
  • 0x0000000001: XMLPLAN logging option was enabled
  • 0x0000000002: STATSUSAGE logging option was enabled
  • 0x0000010000: Data for XMLPLAN was logged
  • 0x0000020000: Data for STATSUSAGE was logged
  • 0x000000004: VERBOSE logging suboption was enabled
  • 0x000000008: DETAILED logging suboption was enabled
  • 0x0000040000: Data for VERBOSE was  logged
  • 0x0000080000: Data for DETAILED was logged
It is easier to use the [Option] Enabled and Has [Option] columns to see this information. Queries against these columns allow you to specify a Y or N value instead of bit-mapped values.
XMLPlanEnabled Possible values include:
  • Y: The XML query plan logging is enabled.
  • N: The XML query plan logging is not enabled.
XMLTextDoc Combines multiple XMLTextInfo rows with the same QueryID into a single XML document as Teradata XML type.