View of the Summary Log Table: QryLogSummary[V]

View of the Summary Log Table: QryLogSummary[V] - Teradata Database

Teradata Database Administration

Product

Teradata Database

Release Number

15.10

Language

English (United States)

Last Update

2018-10-06

Product Category

Software

The QryLogSummary[V] 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.

QryLogSummary[V] 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.
AverageAmpCPU	The average AMP CPU of the queries that ran in the last 10 minutes.
AverageAmpCPUNorm	The average normalized AMP CPU seconds for the queries run in the last 10 minutes on a co-existence system.
AverageIO	The average logical I/O count for the queries run in the last 10 minutes.
AverageParserCPU	The average CPU seconds to parse the queries that ran in the last 10 minutes.
AverageParserCPUNorm	The average normalized CPU seconds to parse the queries run in the last 10 minutes on a co-existence system.
AverageTime	The average run time for queries run in the last 10 minutes, calculated to the nearest hundredth of a second.
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” on page 380.
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. Note: 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.
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.
SessionID	Identifies the session for which queries are being summarized (counted).
TotalIOCount	The total logical I/O count. Note: Logical I/O and CPU may not be accurate for aborted queries.
UserID	The unique ID of the user whose query is logged.
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.