Database: td_metric_svc
Stores information about each processing step used to satisfy the query. One row is logged for each step, including parallel steps.
| View Column | Data Type | Format | Description |
|---|---|---|---|
| Location | VARCHAR(2048) UNICODE CASESPECIFIC | X(2048) | Path to metric data objects. |
| path_component_id | VARCHAR(8000) UNICODE CASESPECIFIC | X(8000) | Operational group (primary cluster or compute cluster) ID. |
| path_collecttimestamp | VARCHAR(8000) UNICODE CASESPECIFIC | X(8000) | Timestamp of when collected the given metrics. |
| path_year | VARCHAR(8000) UNICODE CASESPECIFIC | X(8000) | The year in which the data was recorded in the table. |
| path_month | VARCHAR(8000) UNICODE CASESPECIFIC | X(8000) | The month in which the data was recorded in the table. |
| path_day | VARCHAR(8000) UNICODE CASESPECIFIC | X(8000) | The date on which the data was recorded in the table. |
| path_hour | VARCHAR(8000) UNICODE CASESPECIFIC | X(8000) | The hour at which the data was recorded in the table. |
| path_minute | VARCHAR(8000) UNICODE CASESPECIFIC | X(8000) | The minute at which the data was recorded in the table. |
| path_ver | VARCHAR(8000) UNICODE CASESPECIFIC | X(8000) | The version of Vantage software that was running on the operational group. |
| ProcID | DECIMAL(5,0) NOT NULL | -(5)9 | Return the process ID of the dispatcher. |
| CollectTimeStamp | TIMESTAMP(6) NOT NULL | YYYY-MM-DDBHH:MI:SS.S(6) | Returns the time the query log was generated. |
| ParentReqStartTime | TIMESTAMP | YYYY-MM-DDBHH:MI:SS.S(6) | Returns the time when the parent request was submitted. |
| QueryID | DECIMAL(18,0) NOT NULL | -(18)9 | Returns the QueryId column contains the generated query id for the given query. |
| ParentQueryID | DECIMAL | -(18)9 | Returns the parent system generated query id for this query. |
| StepLev1Num | SMALLINT NOT NULL | ---,--9 | Returns the level 1 step number. |
| StepLev2Num | SMALLINT NOT NULL | ---,--9 | Returns the level 2 step number. |
| StepName | CHAR(6) LATIN NOT CASESPECIFIC NOT NULL | X(6) | Returns an abbreviation of the step name. |
| 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. |
| EstProcTime | FLOAT | ----,---,---,---,--9.999 | Returns the estimated processing time in seconds (with .001 resolution) from the Optimizer. |
| EstCPUCost | FLOAT | ----,---,---,---,--9.999 | Returns an estimate (from the Optimizer) of the CPU time in milliseconds for the step. |
| CPUTime | FLOAT | ----,---,---,---,--9.999 | Returns the total CPU time in seconds (with .001 resolution) used on AMPs for the step or set of parallel steps. For parallel steps, the first step contains the total CPU time. |
| IOcount | FLOAT | ----,---,---,---,--9 | Returns the number of IOs from AMPs that were generated by the step or set of parallel steps which follow if the second step level is 1. |
| EstRowCount | FLOAT | ----,---,---,---,--9 | Returns the estimated row count from the Optimizer. |
| RowCount | FLOAT | ----,---,---,---,--9 | Returns the number of inserted rows if StepName is MRM (Merge Row Multiple) or EXE (MultiLoad), or number of rows step returns with all other steps. |
| RowCount2 | FLOAT | ----,---,---,---,--9 | Returns the number of updated rows if StepName is MRM (Merge Row Multiple) or EXE (MultiLoad), or number of loaded rows with all other steps. |
| RowCount3 | FLOAT | ----,---,---,---,--9 | Returns the number of deleted rows if StepName is EXE (MultiLoad). |
| NumOfActiveAMPs | INTEGER | --,---,---,--9 | Returns the number of AMPS that were active for this query. |
| MaxAmpCPUTime | FLOAT | ----,---,---,---,--9.999 | Returns the CPU time in seconds (with .001 resolution) of the AMP with the highest CPU utilization in the step. |
| MaxCPUAmpNumber | INTEGER | --,---,---,--9 | Returns the number of the AMP with the highest CPU activity. |
| MinAmpCPUTime | FLOAT | ----,---,---,---,--9.999 | Returns the CPU time in seconds (with .001 resolution) of the AMP with the lowest CPU utilization in the step. |
| MaxAmpIO | FLOAT | ----,---,---,---,--9 | 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 | Returns the I/O count of the the I/O count of the highest I/O utilized AMP in the step. |
| SpoolUsage | BIGINT | --,---,---,---,---,---,--9 | Returns 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. |
| MaxSpoolAmpNumber | INTEGER | --,---,---,--9 | Returns the number of the AMP with high spool usage. |
| MinAMPSpool | BIGINT | --,---,---,---,---,---,--9 | Returns the lowest Spool usage on an AMP. |
| 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 | Returns the number of rows with compressed columns. |
| EstIOCost | FLOAT | ----,---,---,---,--9.999 | Returns an estimate (from the Optimizer) of service time in milliseconds for IO for the step. |
| EstNetCost | FLOAT | ----,---,---,---,--9.999 | Returns an estimate (from the Optimizer) of the BYNET service time in milliseconds for the step. |
| EstHRCost | FLOAT | ----,---,---,---,--9.999 | Returns an estimate (from the Optimizer) of other costs for the step. |
| CPUtimeNorm | FLOAT | ----,---,---,---,--9.999 | Returns the normalized CPU time in seconds (with .001 resolution) used on co-existence systems. |
| MaxAmpCPUTimeNorm | FLOAT | ----,---,---,---,--9.999 | Returns the normalized CPU time in seconds (with .001 resolution) of the AMP with maximum CPU utilization in the step. |
| MaxCPUAmpNumberNorm | INTEGER | --,---,---,--9 | Returns the number of the AMP with highest CPU activity. |
| MinAmpCPUTimeNorm | FLOAT | ----,---,---,---,--9.999 | Returns the normalized CPU Time in seconds (with .001 resolution) of the AMP with minimum CPU utilization in the step. |
| 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. |
| EstRowCountSkew | FLOAT | ----,---,---,---,--9 | Returns the number of estimated skew rows. |
| EstRowCountSkewMatch | FLOAT | ----,---,---,---,--9 | Returns the number of estimated skew match spools row. |
| FragmentNum | INTEGER | --,---,---,--9 | Returns the number of fragments in a IPE plan execution of request. |
| StepInstance | INTEGER | --,---,---,--9 | Returns the Step instance number for iterative steps in order of dispatch. If a step is dispatched 3 times, 3 steps are logged with the same step number and step instance 1, 2, 3 to distinguish them. |
| StepStatus | CHAR(10) LATIN NOT CASESPECIFIC | X(10) | Returns the Step status. |
| DispatchSeq | INTEGER | --,---,---,--9 | Returns the Dispatch sequence. |
| LockDelay | FLOAT | ----,---,---,---,--9.999 | Returns the maximum wait time to get a lock on object in centi-seconds. |
| IOKB | FLOAT | ----,---,---,---,--9.999 | Returns the Logical AMP I/Os in KB generated by the step, or set of parallel steps if the second step level is 1. |
| StatementNum | INTEGER | --,---,---,--9 | Returns the statement number with which the step is associated. |
| TriggerNestLevel | SMALLINT | -(5)9 | Returns the composite of TriggerNestLevel details. |
| TriggerKind | VARCHAR(128) LATIN NOT CASESPECIFIC | X(128) | Returns the composite of TriggerKind details. |
| SSReceiverCount | INTEGER | --,---,---,--9 | Returns the total number of AMP receiver that gets redistributed rows through Single Sender Receiver (SSR) feature. If a step does not use SSR, the SSRReceiverCount is 0. |
| VHLogicalIO | FLOAT | ----,---,---,---,--9.999 | Returns the 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 | Returns the 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 | Returns the 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 | Returns the 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 | Returns the 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 | Returns the Physical AMP I/Os in KB generated by the step, or set of parallel steps if the second step level is 1. |
| ServerByteCount | BIGINT | --,---,---,---,---,---,--9 | Total bytes sent and got from the foreign server by the step. |
| Stream_Metrics | VARBYTE(256) | X(512) | Reserved for future use. |
| OneMBRowCount | FLOAT | ----,---,---,---,--9 | The number of 1MB rows (1MB > size > 64KB) in the set of rows returned by the step. |
| PersistentSpool | BIGINT | --,---,---,---,---,---,--9 | Persistent part of SpoolUsage. |
| MaxOneMBRowSize | INTEGER | --,---,---,--9 | The actual size in bytes of the largest 1MB row in the set of rows returned for the query. |
| MaxNumMapAMPs | INTEGER | --,---,---,--9 | The number of AMPs in the largest map used by the request. |
| MinNumMapAMPs | INTEGER | --,---,---,--9 | Number of AMPs in the smallest contiguous map used by this request. |
| 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. |
| 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 | FLOAT | ----,---,---,---,--9.999 | 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 get space. |
| UAFName | CHAR(10) LATIN NOT CASESPECIFIC | X(10) | Name of an Analytic Function being run by EXECUTE FUNCTION in this step. The default is NULL. |
| InMemBulkQualStatus | BYTEINT| | -(3)9 | Represents whether bulk qualification is done in this step or not. |
| 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. This time is already included in other non-NOS CPU fields. |
| NosMaxIOWaitTime | FLOAT | ----,---,---,---,--9.999 | Maximum 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 | AWT elapsed time in seconds for the step. |
| MaxAWTTime | FLOAT | ----,---,---,---,--9.999 | Max AWT elapsed time in seconds for the step. |
| MaxAWTTimeAmpNum | INTEGER | --,---,---,--9 | AMP number that had max AWTTime for the step. |
| MinAWTTime | FLOAT | ----,---,---,---,--9.999 | Minimum AWT elapsed time in seconds for the step. |
| UDFMemUsage | FLOAT | ----,---,---,---,--9.999 | Memory used by UDF for this step. |
| MaxUDFMemUsage | FLOAT | ----,---,---,---,--9.999 | Maximum memory 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 for the step. |
| UDFVMData | FLOAT | ----,---,---,---,--9.999 | UDF Virtual memory data size for the step. |
| LocSpoolUsage | BIGINT | --,---,---,---,---,---,--9 | Total local spool usage for this step in bytes. |
| PhysLocIO | FLOAT | ----,---,---,---,--9.999 | Total local physical IO count for this step. |
| PhysLocIOKB | FLOAT | ----,---,---,---,--9.999 | Total local physical IO for this step in kilobytes. |
| NosPhysWriteIO | BIGINT | --,---,---,---,---,---,--9 | Total physical IOs for Native Object Store files for this step. |
| NosPhysWriteIOKB | BIGINT | --,---,---,---,---,---,--9 | Total KB of physical IOs for Native Object Store files for this step. |
| NosCacheReadIO | BIGINT | --,---,---,---,---,---,--9 | Total Cache Read IOs for Native Object Store files for this step. |
| NosCacheReadIOKB | BIGINT | --,---,---,---,---,---,--9 | Total KB of Cache read IOs for Native Object Store files for this step. |
| NosPhysDataReadIO | BIGINT | --,---,---,---,---,---,--9 | Total physical data read IOs for Native Object Store files for this step. |
| NosPhysDataReadIOKB | BIGINT | --,---,---,---,---,---,--9 | Total KB of physical Data read IOs for Native Object Store files for this step. |
| NosPrefetchReadIO | BIGINT | --,---,---,---,---,---,--9 | Total Read Ahead IOs for Native Object Store files for this step. |
| NosPrefetchReadIOKB | BIGINT | --,---,---,---,---,---,--9 | Total KB of Read Ahead IOs for Native Object Store files for this step. |
| NosFilesWritten | BIGINT | --,---,---,---,---,---,--9 | Number of file writes attempted by Native Object Store in this step. |
| NosFilesDeleted | BIGINT | --,---,---,---,---,---,--9 | Total number of files deleted for Native Object Store files for this step. |
| NosNumDeleteSuccess | INTEGER | --,---,---,--9 | Number of files successfully deleted by Native Object Store for this step. |
| NosNumDeleteFailure | INTEGER | --,---,---,--9 | Number of files failed to be deleted by Native Object Store for this step. |
| NosDeleteIO | BIGINT | --,---,---,---,---,---,--9 | Total IOs to delete for Native Object Store files for this step. |
| NosDeleteIOKB | BIGINT | --,---,---,---,---,---,--9 | Total KB to delete IOs for Native Object Store files for this step. |
| MaxPSFWDID | INTEGER | --,---,---,--9 | Maximum PSF WDID seen by this step. |
| MaxPSFWDIDAmpNum | INTEGER | --,---,---,--9 | AMP Number of Max PSF WDID for this step. |
| PeakAmpStpPrvMem | FLOAT | ----,---,---,---,--9.999 | Peak private memory in MB based on requested size used by this step. |
| PeakAmpStpPrvMemAmpNum | INTEGER | --,---,---,--9 | AMP Number of peak private memory based on requested size used by this step. |
| PeakAmpStpShrMem | FLOAT | ----,---,---,---,--9.999 | Peak shared memory in MB based on requested size used by this step. |
| PeakAmpStpShrMemAmpNum | INTEGER | --,---,---,--9 | AMP number of peak shared memory based on requested size used by this step. |
| HPPCSRatio | FLOAT | ----,---,---,---,--9.999 | The producer-consumer speed ratio for this step. |
| HPNumBuffers | INTEGER | --,---,---,--9 | The number of buffers used by the step as a producer to write the rows. |
| NosSpCIsReturned | BIGINT | --,---,---,---,---,---,--9 | Number of NOS Spool CIs returned by a Native Object Store spool for this step. |
| NosSpCIsReturnedKB | BIGINT | --,---,---,---,---,---,--9 | Total KB of NOS Spool CIs returned by a Native Object Store spool for this step. |
| NosSpDBChunksReturned | BIGINT | --,---,---,---,---,---,--9 | Number of NOS Spool Datablock chunks returned by a Native Object Store spool for this step. |
| NosSpDBChunksReturnedKB | BIGINT | --,---,---,---,---,---,--9 | Total KB of NOS spool datablock chunks returned by a Native Object Store spool for this step. |
| NosSpDBsReturned | BIGINT | --,---,---,---,---,---,--9 | Number of NOS Spool Datablocks returned by a Native Object Store spool for this step. |
| NosSpDBsReturnedKB | BIGINT | --,---,---,---,---,---,--9 | Total KB of NOS spool datablocks returned by a Native Object Store spool for this step. |
| NosSpBlksFSGAcqs | BIGINT | --,---,---,---,---,---,--9 | Number of NOS spool data blocks read from FSG for this step. |
| NosSpBlksFSGAcqsKB | BIGINT | --,---,---,---,---,---,--9 | Total KB of the Number of NOS spool datablocks read from FSG for this step. |
| NosSpCPUTime | FLOAT | ----,---,---,---,--9.999 | CPU time for reading Native Object Store spool blocks (MI, CI, DBChunks). Units of seconds for this step. |
| NosSpMaxIOWaitTime | FLOAT | ----,---,---,---,--9.999 | Max Native Object Store spool IO wait time for any individual IO for this step. Units of seconds. Both read and write. |
| NosSpTotalIOWaitTime | FLOAT | ----,---,---,---,--9.999 | Total of the Native Object Store spool IO wait time for this step. Units of seconds. Both read and write. |
| NosSpTablesWritten | INTEGER | --,---,---,--9 | Number of NOS spool tables written. This corresponds to the number of TMIs written for this step. |
| NosSpCIsWritten | BIGINT | --,---,---,---,---,---,--9 | Number of NOS Spool CIs written for this step. |
| NosSpCIsWrittenKB | BIGINT | --,---,---,---,---,---,--9 | Total KB of NOS Spool CIs written for this step. |
| NosSpDBChunksWritten | BIGINT | --,---,---,---,---,---,--9 | Number of NOS spool DB chunks written for this step. |
| NosSpDBChunksWrittenKB | BIGINT | --,---,---,---,---,---,--9 | Total KB of NOS spool DB chunks written for this step. |
| NosSpDBsWritten | BIGINT | --,---,---,---,---,---,--9 | Number of NOS DBs written for this step. |
| NosSpDBsWrittenKB | BIGINT | --,---,---,---,---,---,--9 | Total KB of NOS spool DBs written for this step. |
| SpoolProd | BIGINT | --,---,---,---,---,---,--9 | Spool produced by this step in bytes. |
| SpoolCons | BIGINT | --,---,---,---,---,---,--9 | Spool consumed by this step in bytes. |
The view also contains ExtraFieldX columns that are reserved for future use.