16.10 - Row Values - 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)

The following table lists the fields available for population in DBQLSummaryTbl rows.

DBC.DBQLSummaryTbl Field Description
AcctString The unexpanded account name under which the query is submitted.
AMPCPUTime Total AMP CPU seconds.
AMPCPUTimeNorm Normalized AMP CPU seconds for co-existence systems only.
AppID The application ID under which the query is submitted.
ClientAddr The client IP address of the submitted query.
ClientID The client ID under which the query is submitted.
CollectTimeStamp Time that the row was inserted into the database. This field is also part of the multi-column NUPI (also see ProcID).

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

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.

LogicalHostID Unique identifier of the logon source for the logged query. A value of 0 indicates an internal session.
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.
ParserCPUTime CPU seconds to parse queries.
ParserCPUTimeNorm Normalized CPU seconds to parse queries.
Normalized columns, such as ParserCPUTimeNorm, are for co-existence systems only.
ProcID Unique processor ID of the Dispatcher and part of the multi-column NUPI (also see CollectTimeStamp).
ProfileID The profile ID under which the user is submitting queries.
ProfileName The name of the profile, if any, under which the user submitted the query.
QueryCount Number of queries run in the last 10 minutes.
QuerySeconds Total run time of queries in this period for this histogram. Calculated to the nearest hundredth of a second.
ReqPhysIO The total number of physical I/Os for the whole request in summary mode.
ReqPhysIOKB The total physical I/Os in kilobytes for the whole request in summary mode.
SessionID Identifies the session for which queries are being summarized (counted).
StartTime Records the timestamp of the first query included for this summary row.
StopTime Records the timestamp of the last query included for this summary row.
TotalIOCount The total logical I/O count.
Logical I/O and CPU may not be accurate for aborted queries.
Usediota I/O tokens used by the requests that are logged in summary mode.
UserID The unique ID of the user whose query is logged.
UserName The name of the user who submitted the queries that are summarized in each row.
ValueType The THRESHOLD criterion is as follows:
  • C = AMP CPU seconds
  • H = Elapsed hundredths of a second
  • I = I/O count
  • N = Normalized AMP CPU seconds
  • S = Elapsed time in seconds.