17.00 - QryLogAmpDataV - 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
LogTime TIMESTAMP(6) YYYY-MM-DDBHH:MI:SS.S(6) Time when this row data was captured by this row specific AMP.
QueryID DECIMAL(18,0) --Z(17)9 (Foreign Key) System wide unique value to join DBQL tables.
AmpNum INTEGER -(10)9 Number of the AMP vproc that collected this data row.
StepClass CHAR(10) LATIN NOT CASESPECIFIC X(10) Step Class in text form.
StepKind CHAR(15) LATIN NOT CASESPECIFIC X(15) Step Kind in text form.
StepLvl1 INTEGER -(10)9 Step number Level 1.
StepLvl2 INTEGER -(10)9 Step number Level 2, if this column has non-zero value, then this is a parallel step.
CumCPU FLOAT ----,---,---,---,--9.999 Cumulative CPU time for the specific session in seconds.
CumIO FLOAT ----,---,---,---,--9 Cumulative IO count for the specific session.
CPUTime FLOAT ----,---,---,---,--9.999 CPU time in seconds for this step execution in this AMP vproc.
IOCount FLOAT ----,---,---,---,--9 IO count for this step execution in this AMP vproc.
IOKB FLOAT ----,---,---,---,--9.999 IO in KB for this step execution in this AMP vproc.
PhysIOCount FLOAT ----,---,---,---,--9 Physical IO count for this step execution in this AMP vproc.
PhysIOKB FLOAT ----,---,---,---,--9.999 Physical IO in KB for this step execution in this AMP vproc.
VHIOCount FLOAT ----,---,---,---,--9 Very Hot IO count for this step execution in this AMP vproc.
VHIOKB FLOAT ----,---,---,---,--9.999 Very Hot IO in KB for this step execution in this AMP vproc.
VHPhysIOCount FLOAT ----,---,---,---,--9 Very Hot Physical IO count for this step execution in this AMP vproc.
VHPhysIOKB FLOAT ----,---,---,---,--9.999 Very Hot Physical IO in KB for this step execution in this AMP vproc.
PSFwdid INTEGER -(10)9 PSF wdid for this step in this AMP vproc.
TDWMwdid INTEGER -(10)9 TDWM wdid for this step in this AMP vproc.
CPUDecayLevel BYTEINT -(3)9 CPU Decay Level for this step execution in this AMP vproc.
IODecayLevel BYTEINT -(3)9 IO Decay Level for this step execution in this AMP vproc.
CPUException BYTEINT -(3)9 CPU Exception for this step execution in this AMP vproc.
IOException BYTEINT -(3)9 IO Exception for this step execution in this AMP vproc.
UsedIOTA FLOAT ----,---,---,---,--9.999 Used IO Token Allocation for this step execution in this AMP vproc.
CollectAlg SMALLINT ---,--9 DBQL data collection algorithm used for this collection.
UDFCpuTime FLOAT ----,---,---,---,--9.999 UDF CPU Usage for this step execution in this AMP vproc.
UDFMemUsage FLOAT ----,---,---,---,--9.999 UDF Memory Usage for this step execution in this AMP vproc.
UDFVMPeak FLOAT ----,---,---,---,--9.999 UDF Virtual Memory Peak usage for this step in this AMP vproc.
UDFVMData FLOAT ----,---,---,---,--9.999 UDF Virtual Memory Data usage for this step in this AMP vproc.
NosRecordsReturned BIGINT --,---,---,---,---,---,--9 NOS Records Returned for this step in this AMP vproc.
NosRecordsSkipped BIGINT --,---,---,---,---,---,--9 NOS Records skipped for this step in this AMP vproc.
NosPhysReadIO BIGINT --,---,---,---,---,---,--9 NOS Physical read IO count for this step in this AMP vproc.
NosPhysReadIOKB FLOAT ----,---,---,---,--9.999 NOS Physical read IO in KB for this step in this AMP vproc.
NosRecordsReturnedKB FLOAT ----,---,---,---,--9.999 NOS Records Returned in KB for this step in this AMP vproc.
NosTotalIOWaitTime FLOAT ----,---,---,---,--9.999 NOS Total IO Wait time for this step in this AMP vproc.
NosMaxIOWaitTime FLOAT ----,---,---,---,--9.999 NOS Maximum IO Wait time for this step in this AMP vproc.
NosCPUTime FLOAT ----,---,---,---,--9.999 NOS CPU time for this step in this AMP vproc.
NosFiles INTEGER --,---,---,--9 NOS Files count for this step in this AMP vproc.
NosFilesSkipped INTEGER --,---,---,--9 NOS files skipped count for this step in this AMP vproc.