17.00 - QryLogStepsV - 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 (Prime Key) ID of the Processing Engine from which the query was executed.
CollectTimeStamp TIMESTAMP(6) NOT NULL YYYY-MM-DDBHH:MI:SS.S(6) Returns (Prime Key) Time and date when the DBQL steps cache was written.
QueryID DECIMAL(18,0) NOT NULL --Z(17)9 Returns (Foreign Key) Systemwide unique value to join DBQL tables.
StepLev1Num SMALLINT NOT NULL ---,--9 Returns Level 1 step number.
StepLev2Num SMALLINT ---,--9 Returns Level 2 step number for parallel steps.
StepName CHAR(6) LATIN NOT CASESPECIFIC NOT NULL X(6) Returns an abbreviation of the step name. For example: DEL for delete step.
StepStartTime TIMESTAMP(6) YYYY-MM-DDBHH:MI:SS.S(6) Returns the date and time to the nearest microsecond when the step is sent to the AMP.
StepStopTime TIMESTAMP(6) YYYY-MM-DDBHH:MI:SS.S(6) Returns the date and time to the nearest microsecond when the step returns from the AMP.
ElapsedTime HS -h(4):mm:ss.s(6) Returns the difference between last response time and start time (to the nearest microsecond)
EstProcTime FLOAT ----,---,---,---,--9.999 Returns the estimated processing time in seconds from the Optimizer.
EstCPUCost FLOAT ZZ,ZZZ,ZZ9.999 Returns an estimate (from the optimizer) of the milliseconds of CPU time for the step.
CPUTime FLOAT ZZ,ZZZ,ZZ9.999 Amount of CPU time in seconds used by the step.
IOcount FLOAT ----,---,---,---,--9 Number of logical IOs issued by the step.
EstRowCount FLOAT ----,---,---,---,--9 Returns the estimated row count from the Optimizer; For PRPD step, the total estimated row count.
EstRowCountSkew FLOAT ----,---,---,---,--9 For PRPD step, returns the estimated row count of skew spool.
EstRowCountSkewMatch FLOAT ----,---,---,---,--9 For PRPD step, returns the estimated row count of skewmatch spool.
RowCount FLOAT ----,---,---,---,--9 Returns the number of rows inserted for the MultiLoad EXE step and the Merge Row Multiple (MRM) step; For PRPD step, the total row count of all split spools; For other steps, RowCount is the number of rows returned by the step.
RowCount2 FLOAT ----,---,---,---,--9 Returns the number of rows updated by the MultiLoad EXE step or the MRM step. For FastLoad LFI step, RowCount2 is the number of rows loaded by the step; For PRPD step, the row count of skew spool.
RowCount3 FLOAT ----,---,---,---,--9 For MultiLoad EXE step, number of rows deleted. For PRPD step, the row count of skewmatch spool.
NumOfActiveAMPs INTEGER --,---,---,--9 Returns the number of AMPS that were active for this query.
MaxAmpCPUTime FLOAT ZZ,ZZZ,ZZ9.999 Returns the CPU time of the highest CPU utilized AMP in the query in seconds.
MaxCPUAmpNumber INTEGER --,---,---,--9 Returns the number of the AMP with the highest CPU activity.
MinAmpCPUTime FLOAT ZZ,ZZZ,ZZ9.999 Returns the CPU time of the lowest CPU utilized AMP in the step in seconds.
MaxAmpIO FLOAT ----,---,---,---,--9 (renamed from HotAmpIO) Returns the I/O count of the highest I/O utilized AMP in the step.
MaxIOAmpNumber INTEGER --,---,---,--9 Returns the number of the AMP with the highest IO usage for this step.
MinAmpIO FLOAT ----,---,---,---,--9 (renamed from LowAmpIO) Returns the I/O count of the lowest I/O utilized AMP in the query.
SpoolUsage BIGINT --,---,---,---,---,---,--9 Peak Spool usage (bytes) of this step (DataCollectAlg=3). Otherwise, number of bytes of spool used by the step.
MaxAMPSpool BIGINT --,---,---,---,---,---,--9 Returns the highest spool usage on an AMP. This is the number of bytes of spool at the step level.
MaxSpoolAmpNumber INTEGER --,---,---,--9 Returns the number of the AMP with high spool usage.
MinAMPSpool BIGINT --,---,---,---,---,---,--9 Returns the lowest Spool usage on an AMP. This is the number of bytes of spool at the step level.
StepWD INTEGER --,---,---,--9 Returns the identifier of the workload for the step.
LSN INTEGER --,---,---,--9 Logon Sequence Number used by the load utility.
UtilityTableID BYTE(4) X(8) Returns the table ID for the load utilities.
RowsWComprColumns FLOAT ----,---,---,---,--9 For each step, the system returns the number of rows which contains at least one compressed column.
EstIOCost FLOAT ZZ,ZZZ,ZZ9.999 Returns an estimate (from the optimizer) of service time in milliseconds for IO for the step.
EstNetCost FLOAT ZZ,ZZZ,ZZ9.999 Returns an estimate (from the optimizer) of the BYNET service time in milliseconds for the step.
EstHRCost FLOAT ZZ,ZZZ,ZZ9.999 Returns an estimate (from the optimizer) of other costs for the step.
CPUtimeNorm FLOAT ZZ,ZZZ,ZZ9.999 Normalized amount of CPU time in seconds used by the step.
MaxAmpCPUTimeNorm FLOAT ZZ,ZZZ,ZZ9.999 Returns the normalized maximum CPU Time in seconds for AMP.
MaxCPUAmpNumberNorm INTEGER --,---,---,--9 Returns the number of the AMP with highest normalized CPU time for the step.
MinAmpCPUTimeNorm FLOAT ZZ,ZZZ,ZZ9.999 Returns the normalized minimum CPU Time in seconds for AMP.
NumCombinedPartitions BIGINT --,---,---,---,---,---,--9 Returns the number of combined partitions accessed (not eliminated).
NumContexts INTEGER --,---,---,--9 Returns the number of contexts allocated to simultaneously access partitions of a source or target table with column partitioning.
NumCPReferences INTEGER --,---,---,--9 Returns the number of column partitions referenced in a source or target table that has column partitioning.
StepInstance INTEGER --,---,---,--9 Step instance number for iterative steps in order of dispatch. If a step is dispatched 3 times, there will be 3 steps logged with the same step number and step instance 1, 2, 3 to distinguish them.
StepStatus CHAR(10) LATIN NOT CASESPECIFIC X(10) Step status, indicating dispatcher and AMP step disposition.
DispatchSeq INTEGER --,---,---,--9 Dispatch sequence, the order in which the step was "handled by the dispatcher itself" or dispatched to the AMPS beginning with 1.
StatementNum INTEGER --,---,---,--9 Statement number with which the step is associated, starting with 1. The highest related statement number if step is related to multiple statements.
TriggerNestLevel SMALLINT -(5)9 Trigger nesting level.
TriggerKind VARCHAR(128) LATIN NOT CASESPECIFIC X(128) Trigger kind, space separated string of abbreviated values for the bit flags.
FragmentNum INTEGER --,---,---,--9 Fragement number to which the step belongs in a IPE plan execution of request.
IOKB FLOAT ----,---,---,---,--9.999 Logical AMP I/Os in KB generated by the step, or set of parallel steps if the second step level is 1.
VHLogicalIO FLOAT ----,---,---,---,--9.999 Number of Very Hot Logical AMP I/Os generated by the step, or set of parallel steps if the second step level is 1.
VHPhysIO FLOAT ----,---,---,---,--9.999 Number of Very Hot Physical AMP I/Os generated by the step, or set of parallel steps if the second step level is 1.
VHLogicalIOKB FLOAT ----,---,---,---,--9.999 Very Hot Logical AMP I/Os in KB generated by the step, or set of parallel steps if the second step level is 1.
VHPhysIOKB FLOAT ----,---,---,---,--9.999 Very Hot Physical AMP I/Os in KB generated by the step, or set of parallel steps if the second step level is 1.
PhysIO FLOAT ----,---,---,---,--9.999 Number of Physical AMP I/Os generated by the step, or set of parallel steps if the second step level is 1.
PhysIOKB FLOAT ----,---,---,---,--9.999 Physical AMP I/Os in KB generated by the step, or set of parallel steps if the second step level is 1.
LockDelay FLOAT ----,---,---,---,--9.999 Maximum wait time to get a lock on object in centi-seconds.
SSRReceiverCount INTEGER --,---,---,--9 The total number of SSR receiver AMP that the step uses.
DMLLoadID INTEGER --,---,---,--9 Returns the load value used by the CLDI modification step performed on LDI table/join index.
ServerByteCount BIGINT --,---,---,---,---,---,--9 Total bytes sent and received from the foreign server by the step.
PersistentSpool BIGINT --,---,---,---,---,---,--9 Persistent part of SpoolUsage.
OneMBRowCount FLOAT ----,---,---,---,--9 The number of 1MB rows (1MB > size > 64KB) in the set of rows returned by the step.
MaxOneMBRowSize INTEGER --,---,---,--9 The largest row size among 1MB rows returned by step RET, JIN, SAMP, STATFN.
MaxNumMapAMPs INTEGER --,---,---,--9 The number of AMPs in the largest map used by the step.
MinNumMapAMPs INTEGER --,---,---,--9 Number of AMPs in the smallest contiguous map used by this step.
SysDefNumMapAMPs INTEGER --,---,---,--9 Number of AMPs in the system-default map.
SourceMapNo INTEGER --,---,---,--9 The map number for the source table in the step.
DestMapNo INTEGER --,---,---,--9 The map number for the output table in the step.
StepObjectInfo VARBYTE(1024) X(2048) Contains binary encoded information about tables, spools, and join indexes accessed by the step and is intended for use by Advisor procedures.
UsedIota FLOAT ----,---,---,---,--9.999 Return IO Tokens used by the step.
PermUsage BIGINT --,---,---,---,---,---,--9 Returns the permanent space in bytes added or deleted by the step.
MaxAMPPerm BIGINT --,---,---,---,---,---,--9 Returns the maximum permanent space in bytes added or deleted by an AMP in the step.
MaxPermAmpNumber INTEGER --,---,---,--9 Returns the AMP number that added or deleted the maximum permanent space in the step.
SpaceDelay FLOAT ----,---,---,---,--9.999 Returns the maximum wait time in centi-seconds to get space from the global space accounting system.
MaxSpaceDelayAmpNumber INTEGER --,---,---,--9 Returns the AMP number that waited the maximum to obtain space.
UAFName CHAR(10) LATIN NOT CASESPECIFIC X(10) Name of an Analytic Function being executed by EXECUTE FUNCTION in this step. The default is NULL.
InMemBulkQualStatus BYTEINT -(3)9 Returns the bulk qualification status of a step.
NosRecordsReturned BIGINT --,---,---,---,---,---,--9 Number of records returned by a Native Object Store step.
NosRecordsSkipped BIGINT --,---,---,---,---,---,--9 Number of records skipped by a Native Object Store step.
NosPhysReadIO BIGINT --,---,---,---,---,---,--9 Total physical IOs for Native Object Store files for this step.
NosPhysReadIOKB FLOAT ----,---,---,---,--9.999 Total KB of physical IOs for Native Object Store files in this step.
NosRecordsReturnedKB FLOAT ----,---,---,---,--9.999 Total KB of records returned for Native Object Store files in this step.
NosTotalIOWaitTime FLOAT ----,---,---,---,--9.999 Total of the Native Object Store IO wait time in seconds in this step.
NosCPUTime FLOAT ----,---,---,---,--9.999 CPU time in seconds for reading Native Object Store files in this step.
NosMaxIOWaitTime FLOAT ----,---,---,---,--9.999 Max Native Object Store IO wait time for any individual IO in seconds.
NosFiles INTEGER --,---,---,--9 Number of file reads attempted by Native Object Store in this step.
NosFilesSkipped INTEGER --,---,---,--9 Number of Native Object Store files that were skipped in this step.
AWTTime FLOAT ----,---,---,---,--9.999 Returns AWT elapsed time in seconds for the step.
MaxAWTTime FLOAT ----,---,---,---,--9.999 Returns Max AWT elapsed time in seconds for the step.
MaxAWTTimeAmpNum INTEGER --,---,---,--9 Returns AMP number that had max AWTTime for the step.
MinAWTTime FLOAT ----,---,---,---,--9.999 Returns Min AWT elapsed time in seconds for the step.
UDFMemUsage FLOAT ----,---,---,---,--9.999 Memory used by UDF for this step.
MaxUDFMemUsage FLOAT ----,---,---,---,--9.999 Max memory in bytes used by UDF for this step.
MaxUDFMemUsageAmpNum INTEGER --,---,---,--9 AMP number that had max memory used by UDF for this step.
UDFVMPeak FLOAT ----,---,---,---,--9.999 UDF Virtual memory peak in bytes for the step.
UDFVMData FLOAT ----,---,---,---,--9.999 UDF Virtual memory data size in bytes for the step.