15.10 - QryLogSummaryV - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

Query

DBC

 

View Column

Data Type

Format

Source Table.Column

ProcID

DECIMAL(5,0)

NOT NULL

-(5)9 (explicit)

DBQLSummaryTbl.ProcID (Composite NUPI)

CollectTimeStamp

TIMESTAMP(6)

NOT NULL

YYYY-MM-DDBHH:MI:SS

DBQLSummaryTbl.CollectTimeStamp (Composite NUPI)

UserID

BYTE(4)

X(8)

DBQLSummaryTbl.UserID

AcctString

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

X(128)

DBQLSummaryTbl.AcctString

LogicalHostID

SMALLINT

ZZZ9 (explicit)

DBQLSummaryTbl.LogicalHostID

AppID

CHAR(30)

UNICODE

NOT CASESPECIFIC

X(30)

DBQLSummaryTbl.AppID

ClientID

CHAR(30)

UNICODE

NOT CASESPECIFIC

X(30)

DBQLSummaryTbl.ClientID

ClientAddr

CHAR(45) LATIN

NOT CASESPECIFIC

X(45)

DBQLSummaryTbl.ClientAddr

ProfileID

BYTE(4)

X(8)

DBQLSummaryTbl.ProfileID

SessionID

INTEGER

NOT NULL

--,---,---,--9 (explicit)

DBQLSummaryTbl.SessionID

QueryCount

INTEGER

NOT NULL

--,---,---,--9 (explicit)

DBQLSummaryTbl.QueryCount

ValueType

CHAR(1) LATIN

NOT CASESPECIFIC

X(1)

DBQLSummaryTbl.ValueType

QuerySeconds

FLOAT

NOT NULL

----,---,---,---,--9.999 (explicit)

DBQLSummaryTbl.QuerySeconds

AverageTime

FLOAT

ZZZ,ZZZ,999 (explicit)

DBQLSummaryTbl.QuerySeconds,

DBQLSummaryTbl.QueryCount

TotalIOCount

FLOAT

----,---,---,---,--9 (explicit)

DBQLSummaryTbl.TotalIOCount

AverageIO

FLOAT

Z(10)

DBQLSummaryTbl.TotalIOCount,

DBQLSummaryTbl.QueryCount

AMPCPUTime

FLOAT

ZZZ,ZZZ.999 (explicit)

DBQLSummaryTbl.AMPCPUTime

AverageAmpCPU

FLOAT

ZZZ,ZZZ.999 (explicit)

DBQLSummaryTbl.AMPCPUTime,

DBQLSummaryTbl.QueryCount

ParserCPUTime

FLOAT

ZZZ,ZZZ.999

(explicit)

DBQLSummaryTbl.ParserCPUTime

AverageParserCPU

FLOAT

ZZZ,ZZZ.999

(explicit)

DBQLSummaryTbl.ParserCPUTime,

DBQLSummaryTbl.QueryCount

AMPCPUTimeNorm

FLOAT

ZZZ,ZZZ.999 (explicit)

DBQLSummaryTbl.AMPCPUTimeNorm

AverageAmpCPUNorm

FLOAT

ZZZ,ZZZ.999 (explicit)

DBQLSummaryTbl.AMPCPUTimeNorm,

DBQLSummaryTbl.QueryCount

ParserCPUTimeNorm

FLOAT

ZZZ,ZZZ.999 (explicit)

DBQLSummaryTbl.ParserCPUTimeNorm

AverageParserCPU
Norm

FLOAT

ZZZ,ZZZ.999

(explicit)

DBQLSummaryTbl.ParserCPUTimeNorm,

DBQLSummaryTbl.QueryCount

LowHist

FLOAT

NOT NULL

----,---,---,---,--9.999 (explicit)

DBQLSummaryTbl.LowHist

HighHist

FLOAT

NOT NULL

----,---,---,---,--9.999 (explicit)

DBQLSummaryTbl.HighHist

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 threshold, one row (with LowHist=TypeofCriterion and HighHist=0) exists for the collection if there were queries shorter than LowHist seconds.

The following SELECT statement retrieves the summary information of a session (if logging was initiated with “Begin Query Logging limit Summary = 5,10,20 IOcount on all;”):

SELECT sessionid, valuetype, querycount, averageio, totaliocount,lowhist
   FROM DBC.QryLogSummaryV 
   WHERE sessionid = 1048 or sessionid = 1049 or sessionid = 1050 
   ORDER BY collecttimestamp, sessionid, lowhist;

Result:

SessionID  ValueType  QueryCount   AverageIO  TotalIOCount   LowHist
---------  ---------  ---------- -----------  ------------   -------
    1,048  I                  31                         4      0.00
    1,048  I                   6           9            56      5.00
    1,048  I                  15          15           224     10.00
    1,048  I                  54          65         3,519     20.00
    1,049  I                   2         981         1,962     20.00
    1,050  I                   1           8             8      5.00
    1,050  I                   1          24            24     20.00