17.00 - QryLogSummaryV - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

Category: Query

Database: DBC

View Column Data Type Format Comment
ProcID DECIMAL(5,0) NOT NULL -(5)9 Returns the process ID of the dispatcher.
CollectTimeStamp TIMESTAMP(6) NOT NULL YYYY-MM-DDBHH:MI:SS.S(6) (Prime Key) Time and date when the DBQL summary cache was written.
UserID BYTE(4) X(8) Returns the ID of the user.
AcctString VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns the user unexpanded logon account string.
LogicalHostID SMALLINT -(5)9 Returns a unique identifier of the logon source for the logged query. A value of zero indicates an internal session.
AppID CHAR(30) UNICODE NOT CASESPECIFIC X(30) Returns the application ID.
ClientID CHAR(30) UNICODE NOT CASESPECIFIC X(30) Returns the client ID.
ClientAddr CHAR(45) LATIN NOT CASESPECIFIC X(45) Returns the IP address of the client who submitted the query.
ProfileID BYTE(4) X(8) Returns the unique number assigned to the cost profile instance in the system.
SessionID INTEGER NOT NULL --,---,---,--9 Returns the session identifier.
QueryCount INTEGER NOT NULL --,---,---,--9 Returns the number of queries run in a 10-minute interval. Used with the "SUMMARY" or "THRESHOLD" SQL option only.
ValueType CHAR(1) LATIN NOT CASESPECIFIC X(1) Returns the type that was used to determine the threshold from the values listed below. C = CPU seconds I = IO count S = Elapsed time in seconds.
QuerySeconds FLOAT NOT NULL ----,---,---,---,--9.999 Returns the total number of seconds used by QueryCount. QuerySeconds can be used to obtain an average.
AverageTime FLOAT ZZZ,ZZZ.999 Returns the average elapsed time (to the nearest hundredth of a second).
TotalIOCount FLOAT ----,---,---,---,--9 Returns the number of IOs from AMPs that were generated by the query.
AverageIO FLOAT Z(10) Returns the average Logical IO Count.
AMPCPUTime FLOAT ZZZ,ZZZ.999 Returns the total AMP CPU time in seconds used for query.
AverageAmpCPU FLOAT ZZZ,ZZZ.999 Returns the average number of AMP CPU seconds used by QueryCount.
ParserCPUTime FLOAT ZZZ,ZZZ.999 Returns the total parser and dispatcher CPU time in seconds used for the query.
AverageParserCPU FLOAT ZZZ,ZZZ.999 Returns the average number of CPU seconds used in the parser by QueryCount.
AMPCPUTimeNorm FLOAT ZZZ,ZZZ.999 Returns the normalized AMP CPU time in seconds for co-existence systems.
AverageAmpCPUNorm FLOAT ZZZ,ZZZ.999 Average number of normalized AMP CPU seconds used by QueryCount.
ParserCPUTimeNorm FLOAT ZZZ,ZZZ.999 Returns the normalized parser CPU time in seconds for co-existence systems.
AverageParserCPUNorm FLOAT ZZZ,ZZZ.999 Average number of normalized CPU seconds used in the parser by QueryCount.
LowHist FLOAT NOT NULL ----,---,---,---,--9.999 For SUMMARY option, lowest value specified as query execution differentiation. For THRESHOLD option, threshold specified by the user.
HighHist FLOAT NOT NULL ----,---,---,---,--9.999 Returns the highest value specified as a query execution time differentiation. Used with the "SUMMARY" SQL option only. If THRESHOLD is used, HighHist is 0.
UsedIota FLOAT ----,---,---,---,--9.999 Return IO Tokens used by the requests that are logged in summary mode.
ReqPhysIO FLOAT ----,---,---,---,--9.999 Returns the total number of Physical I/Os for the whole request in summary mode.
ReqPhysIOKB FLOAT ----,---,---,---,--9.999 Returns the total Physical I/Os in kilobytes for the whole request in summary mode.
StartTime TIMESTAMP(6) YYYY-MM-DDBHH:MI:SS.S(6) Records the timestamp of the first query included for this summary row.
StopTime TIMESTAMP(6) YYYY-MM-DDBHH:MI:SS.S(6) Record the timestamp of the last query included for this summary row.
UserName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns the name of the userid, if any, under which the user submitted the query.
ProfileName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns the name of the profile, if any, under which the user submitted the query.