17.10 - Usage Notes - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

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

The QryLogSummaryV view of DBQLSummaryTbl holds the counts logged for queries of users with THRESHOLD or SUMMARY rules. It is only populated if summary information is requested or a threshold value is used.

Possible Values for ValueType

The THRESHOLD criterion is as follows:

Value Description
C AMP CPU seconds.
H Elapsed hundredths of a second.
I I/O count.
N Normalized AMP CPU seconds.
S Elapsed time in seconds.

LowHist and HighHist

Value Description
HighHist
  • Highest value for the SUMMARY option.
  • Zero for the THRESHOLD option.
  • If the modifiers CPUTIME or IOCOUNT are used, then this value is the highest CPU seconds or I/O counts set by the user.

    Use CPUTIMENORM for hundredths of a second of normalized CPU time. To measure subsecond queries, use ELAPSEDTIME. The default, elapsed time in seconds, can be explicitly specified with ELAPSEDSEC.

LowHist
  • Lowest value for the SUMMARY option.
  • For the THRESHOLD option, this is the threshold time set by the user. The default time is 5.
  • If the modifiers CPUTIME or IOCOUNT are used, then this value is the lowest CPU seconds or I/O counts set by the user. Use CPUTIMENORM for hundredths of a second of normalized CPU time. To measure subsecond queries, use ELAPSEDTIME. The default, elapsed time in seconds, can be explicitly specified with ELAPSEDSEC.

For the SUMMARY case, a row exists for each collection if the count of the queries run in that time frame (LowHist to HighHist) is greater than 0.

For the THRESHOLD case, one row (with LowHist=TypeofCriterion and HighHist=0) exists for the collection if there were queries shorter than LowHist seconds.