resusagespmaV | VantageCloud Lake - resusagespmaV - Teradata VantageCloud Lake

Lake - Monitor Resources and Performance
Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
wyu1683671641248.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
wyu1683671641248

Database: td_metric_svc

If you need detailed statistics for each node in the system, use this view to:

  • Aggregate information to evaluate overall system CPU, IO, Memory, and Bynet utilization.
  • Evaluate overall node level parallelism over time.
  • Compare IO activity amongst the nodes.
View Column Data Type Format Comment
Location VARCHAR(2048) UNICODE CASESPECIFIC X(2048) File path in object storage for 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, in EPOCH timestamp format, this metric data was collected from your database and written to object storage.
path_year VARCHAR(8000) UNICODE CASESPECIFIC X(8000) The year in which the data was logged.
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 day 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.
TheDate DATE NOT NULL YYYY/MM/DD Local Date of the log entry.
NodeID INTEGER NOT NULL ZZZ9-9999 Numeric value that uniquely identifies a node (cloud compute instance) within a compute cluster. For example, '10001','10002'.
TheTime FLOAT NOT NULL 99:99:99.99 Nominal local time of the log entry.
GmtTime FLOAT NOT NULL 99:99:99.99 Nominal GMT time of the log entry. Greenwich Mean Time is not affected by the Daylight Saving Time adjustments that occur twice a year.
CabinetID
Not applicable. Do not use.
     Not applicable.
ModuleID
Not applicable. Do not use.
     Not applicable.
NodeType CHAR(8) LATIN NOT CASESPECIFIC NOT NULL X(8) Indicates the node (cloud compute instance) family. For example, '67_R5'.
TheTimestamp BIGINT NOT NULL -(20)9 Number of seconds since midnight, January 1, 1970.
CentiSecs INTEGER NOT NULL -(11)9 Actual number of centiseconds in the logging period.
Secs SMALLINT NOT NULL -(6)9 Actual number of seconds in the logging period.
NominalSecs SMALLINT NOT NULL -(6)9 Nominal number of seconds in the logging period.
PM_COD_CPU SMALLINT NOT NULL -(6)9 Platform Metering CPU COD value in one tenths of a percent. For example, a value of 500 represents a COD value of 50.0%.
PM_COD_IO SMALLINT NOT NULL -(6)9 Platform Metering IO COD value in whole percent. For example, a value of 50 represents a COD value of 50.0%.
WM_COD_CPU SMALLINT NOT NULL -(6)9 Workload Management CPU COD value in one tenths of a percent. For example, a value of 500 represents a COD value of 50.0%.
WM_COD_IO SMALLINT NOT NULL -(6)9 Workload Management IO COD value in whole percent. For example, a value of 50 represents a COD value of 50.0%.
TIER_FACTOR SMALLINT NOT NULL -(6)9 I/O performance limit placed on a core-reduced node. For example, a value of 75 represents an I/O limit of 75.0% placed before other COD values.
Reserved00 SMALLINT NOT NULL -(6)9 Reserved for future use.
ReservedS0 CHAR(4) LATIN NOT CASESPECIFIC NOT NULL X(4) Reserved for future use.
NCPUs SMALLINT NOT NULL -(6)9 Number of online CPUs on this node.
VProc1 SMALLINT NOT NULL -(6)9 Current count of type 1 (AMP) virtual processors running on the node.
VProc2 SMALLINT NOT NULL -(6)9 Current count of type 2 (PE) virtual processors running under the node.
VProc3 SMALLINT NOT NULL -(6)9 Current count of type 3 (GTW) virtual processors running under the node.
VProc4 SMALLINT NOT NULL -(6)9 Current count of type 4 (RSG) virtual processors running under the node.
VProc5 SMALLINT NOT NULL -(6)9 Current count of type 5 (TVS) virtual processors running under the node.
VProc6 SMALLINT NOT NULL -(6)9 Current count of type 6 virtual processors running under the node.
VProc7 SMALLINT NOT NULL -(6)9 Current count of type 7 virtual processors running under the node.
VProcType1 CHAR(4) LATIN NOT CASESPECIFIC NOT NULL X(4) Type of virtual processor for Vproc1. When the vproc is present on the node, the value is AMP.
VProcType2 CHAR(4) LATIN NOT CASESPECIFIC NOT NULL X(4) Type of virtual processor for Vproc2. When the vproc is present on the node, the value is PE.
VProcType3 CHAR(4) LATIN NOT CASESPECIFIC NOT NULL X(4) Type of virtual processor for Vproc3. When the vproc is present on the node, the value is GTW.
VProcType4 CHAR(4) LATIN NOT CASESPECIFIC NOT NULL X(4) Type of virtual processor for Vproc4. When the vproc is present on the node, the value is RSG.
VProcType5 CHAR(4) LATIN NOT CASESPECIFIC NOT NULL X(4) Type of virtual processor for Vproc5. When the vproc is present on the node, the value is TVS.
VProcType6 CHAR(4) LATIN NOT CASESPECIFIC NOT NULL X(4) Type of virtual processor for Vproc6.
VProcType7 CHAR(4) LATIN NOT CASESPECIFIC NOT NULL X(4) Type of virtual processor for Vproc7.
NodeNormFactor INTEGER NOT NULL Z(11)9 A per-CPU normalization factor that is used to normalize the reported CPU values of the ResUsageSpma table to a single 5100 CPU. This value is scaled by a factor of 100. If the actual factor is 5.25, then the value of the NodeNormFactor is 525.
MemSize BIGINT NOT NULL -(20)9 Amount of memory on this node in megabytes.
ReservedS1 CHAR(8) LATIN NOT CASESPECIFIC NOT NULL X(8) Reserved for future use.
ProcPendMisc FLOAT NOT NULL -(20)9 Number of processes blocked pending miscellaneous events.
ProcBlksTime FLOAT NOT NULL -(20)9 Number of process blocks waiting only for timer expiration.
ProcWaitMsgRead FLOAT NOT NULL -(20)9 Time in centiseconds processes were blocked pending nonstep work.
ProcWaitTime FLOAT NOT NULL -(20)9 Time in centiseconds processes were blocked pending some amount of elapsed time only.
ProcWaitMisc FLOAT NOT NULL -(20)9 Time in centiseconds processes were blocked pending miscellaneous events.
MemFreeKB FLOAT NOT NULL -(20)9 Approximate amount of memory that is available for use. The Linux operating system uses most free memory for buffers and caching to improve performance, but the operating system can reclaim that memory if it is needed by programs.
MsgPtPReadKB FLOAT NOT NULL -(20)9 KB of net point-to-point messages input to processes on the node through the message subsystem
MsgPtPWriteKB FLOAT NOT NULL -(20)9 KB of net point-to-point messages output from processes on the node through the message subsystem.
MsgBrdReadKB FLOAT NOT NULL -(20)9 KB of net broadcast messages input to processes on the node through the message subsystem
MsgBrdWriteKB FLOAT NOT NULL -(20)9 KB of net broadcast messages output from processes on the node through the message subsystem.
MsgBrdWriteKB FLOAT NOT NULL -(20)9 KB of net broadcast messages output from processes on the node through the message subsystem.
NetMsgPtPWriteKB FLOAT NOT NULL -(20)9 Amount of point-to-point message data in KB transmitted by both BYNETs.
NetMsgBrdWriteKB FLOAT NOT NULL -(20)9 Amount of broadcast message data in KB transmitted by both BYNETs.
NetMsgPtPReadKB FLOAT NOT NULL -(20)9 Amount of point-to-point message data in KB received by both BYNETs.
NetMsgBrdReadKB FLOAT NOT NULL -(20)9 Amount of broadcast message data in KB received by both BYNETs.
NetRxKBPtP FLOAT NOT NULL -(20)9 Point-to-point KB received over all BYNETs.
NetTxKBPtP FLOAT NOT NULL -(20)9 Point-to-point KB transmitted over all BYNETs.
NetRxKBBrd FLOAT NOT NULL -(20)9 Broadcast KB received over all BYNETs.
NetTxKBBrd FLOAT NOT NULL -(20)9 Broadcast KB transmitted over all BYNETs.
NetMrgTxKB FLOAT NOT NULL -(20)9 Number of KB transmitted, without regard to which net, by merge transmission services for currently active merge operations.
NetMrgRxKB FLOAT NOT NULL -(20)9 Number of KB received, without regard to which net, by merge receive services for currently active merge operations.
NetMrgTxRows FLOAT NOT NULL -(20)9 Number of data rows transmitted, without regard to which net, by merge transmission services for currently active merge operations.
NetMrgRxRows FLOAT NOT NULL -(20)9 Number of data rows received, without regard to which net, by merge receive services for currently active merge operations.
HostReadKB FLOAT NOT NULL -(20)9 KB transferred in from the host.
HostWriteKB FLOAT NOT NULL -(20)9 KB transferred out to the host.
FileAcqKB FLOAT NOT NULL -(20)9 KB logically acquired by FileAcqs.
FileAcqOtherKB FLOAT NOT NULL -(20)9 Number of scratch disk segments acquired in KB.
FileAcqReadKB FLOAT NOT NULL -(20)9 KB physically read by FileAcqReads
FileRelKB FLOAT NOT NULL -(20)9 KB logically released by FileRels.
FileRelOtherKB FLOAT NOT NULL -(20)9 Number of scratch disk segments released in KB.
FileWriteKB FLOAT NOT NULL -(20)9 KB physically written by FileWrites
FilePreKB FLOAT NOT NULL -(20)9 Sum of the sizes of data blocks logically loaded with data prefetches (for example, either cylinder reads or individual block reads). For cylinder reads, this column does not include the disk sectors in between the loaded data blocks.
FilePreReadKB FLOAT NOT NULL -(20)9 Size of the data prefetch (cylinder section or individual blocks being read) that is physically loaded from disk. For cylinder reads, this column includes the disk sectors in between the loaded data block.
FileContigWIos FLOAT NOT NULL -(20)9 Number of I/Os done on the blocks that were marked for contiguous write. By calculating FileContigWBlocks / FileContigWIOs you can get the average number of blocks combined into a single I/O.
FileContigWBlocks FLOAT NOT NULL -(20)9 Number of data blocks marked as contiguous writable. When creating sequential blocks in-order, blocks are marked as contiguous writable and aged to allow PDE to combine the write I/Os of such blocks.
FileContigWKB FLOAT NOT NULL -(20)9 Size, in KB, of the blocks that were marked for contiguous write. By calculating FileContigWKB / FileContigWBlocks you can get the average size of the writes that were candidates for combining.
PSQWaitTime FLOAT NOT NULL -(20)9 Time in centiseconds that work requests waited on an input queue before being serviced. To get an approximate average QWaitTime per request during this period, divide QWaitTime by NumRequests.
PSServiceTime FLOAT NOT NULL -(20)9 Time in centiseconds that work requests required for service. To get an approximate average ServiceTime per request during this period, divide ServiceTime by NumRequests.
TvsReadCnt FLOAT NOT NULL -(20)9 Number of logical device reads. The TvsReadCnt column is a summary of the ReadCnt column in the SPDSK table.
TvsWriteCnt FLOAT NOT NULL -(20)9 Number of logical device writes.
TvsReadRespTot FLOAT NOT NULL -(20)9 Total of individual read response time in centiseconds.
TvsWriteRespTot FLOAT NOT NULL -(20)9 Total of individual write response time in centiseconds.
FullPotentialIota FLOAT NOT NULL -(20)9 Sum of full (total uninhibited) potential IOTAs from all devices attached to this node. These are NOT limited by the IO COD setting.
CodPotentialIota FLOAT NOT NULL -(20)9 Sum of potential IOTAs from all devices attached to this node. These are accumulated only when an I/O is pending on a device, and they are limited by the IO_COD setting.
UsedIota FLOAT NOT NULL -(20)9 Sum of used IOTAs from all devices attached to this node.
CpuThrottleCount FLOAT NOT NULL -(20)9 Number of times that WM CPU COD throttling was triggered
CpuThrottleTime FLOAT NOT NULL -(20)9 Time in centiseconds that WM CPU COD throttling was active.
VHCacheKB FLOAT NOT NULL -(20)9 Current size of the VH Cache in KB.
NLBMsgFlowControlledKB FLOAT NOT NULL -(20)9 KB of segment memory in use by flow controlled Node Level Buffered messages.
NetActiveMrgKB FLOAT NOT NULL -(20)9 Current memory usages by BYNET merge jobs.
KernMemInuseKB FLOAT NOT NULL -(20)9 KB of kernel memory in use by PDE.
SegMDLInuseKB FLOAT NOT NULL -(20)9 Total memory in use by segment MDLs.
FsgCacheKB FLOAT NOT NULL -(20)9 Allocated memory for FSG cache.
PageScanDirects FLOAT NOT NULL -(20)9 Number of pages scanned directly in kernel on user context to locate free memory.
PageScanKswapds FLOAT NOT NULL -(20)9 Number of pages scanned by kswapd daemon to locate free memory.
PageMajorFaults FLOAT NOT NULL -(20)9 Number of major page faults (page was not in memory).
PageMinorFaults FLOAT NOT NULL -(20)9 Number of minor page faults (page was still in memory).
SlabCacheKB FLOAT NOT NULL -(20)9 Current KB of memory cache managed by the Linux slab allocator.
DiskCacheInUseKB FLOAT NOT NULL -(20)9 Current KBs of disk cache in use.
DiskCacheTotalKB FLOAT NOT NULL -(20)9 Total KBs of disk cache available for the pdisk.
PageCacheKB FLOAT NOT NULL -(20)9 Current KB of Linux page cache.
IoThrottleCount FLOAT NOT NULL -(20)9 Number of times an I/O was throttled.
IoThrottleTime FLOAT NOT NULL -(20)9 Total I/O Throttle Time in milliseconds.
IoThrottleTimeMax FLOAT NOT NULL -(20)9 Maximum I/O Throttle Time in milliseconds.
IoThrottleCntZeroIotas FLOAT NOT NULL -(20)9 Number of times an I/O was throttled due to no IOTA tokens available in the bucket.
IoThrottleCntInsuffIotas FLOAT NOT NULL -(20)9 Number of times an I/O was throttled due to insufficient IOTA tokens available in the bucket.
IoThrottleCntInsuffIotasHL FLOAT NOT NULL -(20)9 Number of times an I/O was throttled due to insufficient IOTA tokens available in the bucket for Hard Limits.
IoThrottleCntMaxQD FLOAT NOT NULL -(20)9 Number of times an I/O was throttled due to the queue depth to the storage being at maximum.
NosTables FLOAT NOT NULL -(20)9 Number of Native Object Store tables accessed. Access through READ_NOS does not increment this column, although it does increment the other NOS columns.
NosPhysReadIOs FLOAT NOT NULL -(20)9 Number of physical read IOs issued against Native Object Store tables.
NosPhysReadIOKB FLOAT NOT NULL -(20)9 Total KB physically read from Native Object Store tables.
NosFiles FLOAT NOT NULL -(20)9 Number of Native Object Store files read in satisfying queries against Native Object Store tables.
NosFilesSkipped FLOAT NOT NULL -(20)9 Number of Native Object Store files (or partial files) skipped due to errors.
NosRecordsReturned FLOAT NOT NULL -(20)9 Number of records returned in satisfying queries against Native Object Store tables.
NosRecordsReturnedKB FLOAT NOT NULL -(20)9 Total KB of records returned from Native Object Store files.
NosRecordsSkipped FLOAT NOT NULL -(20)9 Number of Native Object Store records skipped due to errors
NosTotalIOWaitTime FLOAT NOT NULL -(20)9 Total time in seconds waiting for IOs when reading Native Object Store files.
NosMaxIOWaitTime FLOAT NOT NULL -(20)9 Maximum single IO wait time in seconds when reading Native Object Store files.
NosCPUTime FLOAT NOT NULL -(20)9 Total CPU time in seconds spent decompressing, translating, or otherwise processing Native Object Store data as part of reading it. This time is already included in other non-NOS CPU fields.
ProcBlksMsgReadAwt FLOAT NOT NULL -(20)9 Number of process blocks for non-step work (AWT only).
ProcPendNetReadAwt FLOAT NOT NULL -(20)9 Number of processes blocked pending non-step work, that is, the number of processes blocked on any mailbox other than the work mailbox (AWT only).
NodeMbs FLOAT NOT NULL -(20)9 I/O capacity configured for a node in MB/s based on a 96k 90/10 R/W workload not adjusted for COD.
IoPrioStarvedCount FLOAT NOT NULL -(20)9 Number of prioritized I/Os that were starved and had their priority updated to alleviate starvation.
ProcWaitMsgReadAwt FLOAT NOT NULL -(20)9 Time in centiseconds processes were blocked pending nonstep work (AWT only).
NosFilesWritten FLOAT NOT NULL -(20)9 Number of file writes attempted by Native Object Store.
NosPhysWriteIOs FLOAT NOT NULL -(20)9 Total physical write IOs for Native Object Store files.
NosPhysWriteIOKB FLOAT NOT NULL -(20)9 Total KB of physical write IOs for Native Object Store files.
FullPotentialIotaUnAdj FLOAT NOT NULL -(20)9 Sum of the unadjusted full potential input or output token allocations from all devices attached to the node.
NosPhysDataReadIO FLOAT NOT NULL -(20)9 Number of Physical Data IO Reads for Native Object Store.
NosPhysDataReadIOKB FLOAT NOT NULL -(20)9 Total KBs of physical data read for Native Object Store.
NosCacheReadIO FLOAT NOT NULL -(20)9 Number of Cache Data IO Reads for Native Object Store.
NosCacheReadIOKB FLOAT NOT NULL -(20)9 Total KBs of cache data read for Native Object Store.
NosSpCIsReturned FLOAT NOT NULL -(20)9 Number of NOS Spool CIs returned by a Native Object Store spool request.
NosSpCIsReturnedKB FLOAT NOT NULL -(20)9 Total KB of CIs returned for Native Object Store spool requests.
NosSpDBChunksReturned FLOAT NOT NULL -(20)9 Number of NOS Spool Datablock chunks returned by a Native Object Store spool request.
NosSpDBChunksReturnedKB FLOAT NOT NULL -(20)9 Total KB of NOS Spool Datablock chunks returned by a Native Object Store spool request.
NosSpDBsReturned FLOAT NOT NULL -(20)9 Number of NOS Spool Datablocks returned by a Native Object Store spool request.
NosSpDBsReturnedKB FLOAT NOT NULL -(20)9 Total KB of NOS Spool Datablocks returned by a Native Object Store spool request.
NosSpBlksFSGAcqs FLOAT NOT NULL -(20)9 Number of NOS Spool Datablocks read from FSG.
NosSpBlksFSGAcqsKB FLOAT NOT NULL -(20)9 Total KB of the Number of NOS Spool Datablocks read from FSG.
NosSpTablesRead FLOAT NOT NULL -(20)9 Number of NOS Spool tables accessed. This value is the same as the number of NOS Spool MIs read.
NosSpTablesWritten FLOAT NOT NULL -(20)9 Number of NOS spool tables written. This corresponds to the number of TMIs written.
NosSpCIsWritten FLOAT NOT NULL -(20)9 Number of NOS Spool CIs written.
NosSpCIsWrittenKB FLOAT NOT NULL -(20)9 Total KB of NOS Spool CIs written.
NosSpDBChunksWritten FLOAT NOT NULL -(20)9 Number of NOS spool DB chunks written.
NosSpDBChunksWrittenKB FLOAT NOT NULL -(20)9 Total KB of NOS spool DB chunks written.
NosSpDBsWritten FLOAT NOT NULL -(20)9 Number of NOS DBs written.
NosSpDBsWrittenKB FLOAT NOT NULL -(20)9 Total KB of NOS spool DBs written.
RDFCShrink FLOAT NOT NULL -(20)9 Count of times the RDFC Shrink action was invoked.
RDFCShrinkKB FLOAT NOT NULL -(20)9 Volume of unused FSG cache unpinned/freed up (in KB) for a shrink action.
RDFCGrow FLOAT NOT NULL -(20)9 Count of times the RDFC grow action was invoked.
RDFCGrowKB FLOAT NOT NULL -(20)9 Volume of FSG Cache re-pinned/acquired (in KB) for the RDFC grow action.
Active FLOAT NOT NULL -(20)9 Controls whether the rows are logged to the resource usage tables if Active Row Filter Mode is enabled.
ProcReadyMax FLOAT NOT NULL -(20)9 Maximum number of ready tasks, also called threads, able to run on CPUs when a CPU becomes available.
ProcReady FLOAT NOT NULL -(20)9 Number of runnable or ready tasks, also called threads, able to run on CPUs when a CPU becomes available.
ProcBlocked FLOAT NOT NULL -(20)9 Number of threads blocked waiting for I/O at the current time.
ProcPendMemAlloc FLOAT NOT NULL -(20)9 Number of processes blocked pending memory allocations
ProcPendFsgRead FLOAT NOT NULL -(20)9 Number of processes blocked pending a File Segment (FSG) read from disk.
ProcPendFsgWrite FLOAT NOT NULL -(20)9 Number of processes blocked pending an FSG write to disk.
ProcPendNetThrottle FLOAT NOT NULL -(20)9 Number of processes blocked pending delivery of outstanding outgoing messages.
ProcPendNetRead FLOAT NOT NULL -(20)9 Number of processes blocked pending non-step work, that is, the number of processes blocked on any mailbox other than the work mailbox.
ProcPendMonitor FLOAT NOT NULL -(20)9 Number of processes blocked pending a user monitor.
ProcPendMonResume FLOAT NOT NULL -(20)9 Number of processes blocked pending a user monitor resume from a yield.
ProcPendDBLock FLOAT NOT NULL -(20)9 Number of processes blocked pending database locks.
ProcPendSegLock FLOAT NOT NULL -(20)9 Number of processes blocked pending a segment lock.
ProcPendFsgLock FLOAT NOT NULL -(20)9 Number of processes blocked pending an FSG lock
ProcPendQnl FLOAT NOT NULL -(20)9 Number of processes blocked pending a TSKQNL lock.
ProcBlksMemAlloc FLOAT NOT NULL -(20)9 Number of process blocks for memory allocations.
ProcBlksFsgRead FLOAT NOT NULL -(20)9 Number of process blocks for an FSG read from disk.
ProcBlksFsgWrite FLOAT NOT NULL -(20)9 Number of process blocks for an FSG write to disk.
NetSemInUse FLOAT NOT NULL -(20)9 Number of semaphores in use at the current time.
NetChanInUse FLOAT NOT NULL -(20)9 Number of channels in use at the current time.
NetGroupInUse FLOAT NOT NULL -(20)9 Number of groups in use at the current time. This number is same across all nodes.
ProcBlksNetThrottle FLOAT NOT NULL -(20)9 Number of process blocks for delivery of outstanding outgoing messages.
ProcBlksMsgRead FLOAT NOT NULL -(20)9 Number of process blocks for non-step work.
ProcBlksMonitor FLOAT NOT NULL -(20)9 Number of process blocks for a user monitor.
ProcBlksMonResume FLOAT NOT NULL -(20)9 Number of process blocks for a user monitor resume from a yield
ProcBlksDBLock FLOAT NOT NULL -(20)9 Number of process blocks for database locks. The AMP Worker Task can do other work while the lock is blocked.
ProcBlksSegLock FLOAT NOT NULL -(20)9 Number of process blocks for a disk or task context (for example, scratch, stack, and so on) segment lock.
ProcBlksMisc FLOAT NOT NULL -(20)9 Number of process blocks for miscellaneous events.
ProcBlksFsgLock FLOAT NOT NULL -(20)9 Number of process blocks for an FSG lock.
ProcBlksQnl FLOAT NOT NULL -(20)9 Number of process blocks for a TSKQNL lock.
ProcWaitMemAlloc FLOAT NOT NULL -(20)9 Time in centiseconds processes were blocked pending memory allocations.
ProcWaitPageRead FLOAT NOT NULL -(20)9 Time in centiseconds processes were blocked pending a page read from disk.
ProcWaitFsgRead FLOAT NOT NULL -(20)9 Time in centiseconds processes were blocked pending an FSG read from disk.
ProcWaitFsgWrite FLOAT NOT NULL -(20)9 Time in centiseconds processes were blocked pending an FSG lock.
ProcWaitNetThrottle FLOAT NOT NULL -(20)9 Time in centiseconds processes were blocked pending delivery of outstanding outgoing messages.
ProcWaitMonitor FLOAT NOT NULL -(20)9 Time in centiseconds processes were blocked pending a user monitor.
ProcWaitMonResume FLOAT NOT NULL -(20)9 Time in centiseconds processes were blocked pending a user monitor resume from a yield.
ProcWaitDBLock FLOAT NOT NULL -(20)9 Time in centiseconds processes were blocked pending database locks
ProcWaitSegLock FLOAT NOT NULL -(20)9 Time in centiseconds processes were blocked pending a disk or task context (for example, scratch, stack, and so on) segment lock.
ProcWaitFsgLock FLOAT NOT NULL -(20)9 Time in centiseconds processes were blocked pending an FSG lock.
ProcWaitQnl FLOAT NOT NULL -(20)9 Time in centiseconds processes were blocked pending a TSKQNL lock.
CPUIdle FLOAT NOT NULL -(20)9 Time in centiseconds CPUs are idle and not waiting for I/O.
CPUIoWait FLOAT NOT NULL -(20)9 Time in centiseconds CPUs are idle and waiting for I/O completion.
CPUUServ FLOAT NOT NULL -(20)9 Time in centiseconds CPUs are busy executing user service code, that is, privileged work performing system services on behalf of user execution processes which do not have root access. CPUUServ reports if a task used CPU while in the kernel.
CPUUExec FLOAT NOT NULL -(20)9 Time in centiseconds CPUs are busy executing user execution code, that is, time spent in a user state on behalf of a process.
CPUProcSwitches FLOAT NOT NULL -(20)9 Number of times the scheduler switched a currently active process of a CPU to a new process.
MemVprAllocKB FLOAT NOT NULL -(20)9 Change in memory. MemVprAllocKB represents a delta from the previous reporting period and reports negative values as less memory is used.
MemTextPageReads FLOAT NOT NULL -(20)9 Number of pages paged minus the pages swapped in.
MemCtxtPageWrites FLOAT NOT NULL -(20)9 Number of pages swapped out.
MemCtxtPageReads FLOAT NOT NULL -(20)9 Number of pages swapped in.
MsgPtPReads FLOAT NOT NULL -(20)9 Number of net point-to-point messages input to processes on the node through the message subsystem.
MsgPtPWrites FLOAT NOT NULL -(20)9 Number of net point-to-point messages output from processes on the node through the message subsystem.
MsgBrdReads FLOAT NOT NULL -(20)9 Number of net broadcast messages input to processes on the node through the message subsystem.
MsgBrdWrites FLOAT NOT NULL -(20)9 Number of net broadcast messages output from processes on the node through the message subsystem
NetTxRouting FLOAT NOT NULL -(20)9 Number of samples showing the transmitter routing on a BYNET.
NetTxConnected FLOAT NOT NULL -(20)9 Number of samples showing the transmitter connected on a BYNET.
NetRxConnected FLOAT NOT NULL -(20)9 Number of samples showing the receiver connected on a BYNET.
NetTxIdle FLOAT NOT NULL -(20)9 Number of samples showing the transmitter idle on a BYNET.
NetRxIdle FLOAT NOT NULL -(20)9 Number of samples showing the receiver idle on a BYNET.
NetSamples FLOAT NOT NULL -(20)9 Sample count for sampled statistics for a Bynet. NetSamples is used to normalize all net time monitored statistics to a percent-of-time basis. For example, dividing (NetTxIdle/NetSamples) yields the transmitter-idle time ratio for the net statistics.
NetMsgPtPWrites FLOAT NOT NULL -(20)9 Number of point-to-point messages transmitted by both BYNETs.
NetMsgBrdWrites FLOAT NOT NULL -(20)9 Number of broadcast messages transmitted by both BYNETs.
NetMsgPtPReads FLOAT NOT NULL -(20)9 Number of point-to-point messages received by both BYNETs.
NetMsgBrdReads FLOAT NOT NULL -(20)9 Number of broadcast messages received by both BYNETs.
NetMrgBlock FLOAT NOT NULL -(20)9 Number of times a merge message was blocked until delivery of outstanding outgoing messages.
NetMsgChannelBlock FLOAT NOT NULL -(20)9 Number of times the net software was blocked because the channel was not in RxReady state on the receiver.
NetMsgGroupBlock FLOAT NOT NULL -(20)9 Number of times the net software was blocked because the receiver could not implicitly enter the group.
NetMsgResourceBlock FLOAT NOT NULL -(20)9 Number of times the net software was blocked because the receiver could not get the necessary resources.
NetMsgFCBlock FLOAT NOT NULL -(20)9 Number of times the net software was blocked because the receiver was flow-controlled.
NetMsgRxBlock FLOAT NOT NULL -(20)9 Number of times the net software could not accept a message and caused a transmitter to block.
NetBlockQueueTotal FLOAT NOT NULL -(20)9 Total number of services added to the BlockableServices queue in this interval.
NetBlockQueueMax FLOAT NOT NULL -(20)9 Maximum number of services on the BlockableServices queue in this interval.
NetBlockQueue FLOAT NOT NULL -(20)9 Total number of services on the BlockableService queue at the current time.
NetTxCircHPBrd FLOAT NOT NULL -(20)9 Number of high priority broadcast circuits transmitted on all BYNETs.
NetRxCircPtP FLOAT NOT NULL -(20)9 Number (both normal and high priority) of point-to-point circuits received on all BYNETs.
NetTxCircHPPtP FLOAT NOT NULL -(20)9 Number of high priority point-to-point circuits transmitted on all BYNETs.
NetRxCircBrd FLOAT NOT NULL -(20)9 Number (both normal and high priority) of broadcast circuits received on all BYNETs.
NetTxCircBrd FLOAT NOT NULL -(20)9 Number (both normal and high priority) of broadcast circuits transmitted on all BYNETs.
NetBackoffs FLOAT NOT NULL -(20)9 Software backoffs, defined as BNS service blocked occurrences, without regard for which net was involved.
NetSemInUseMax FLOAT NOT NULL -(20)9 Maximum number of semaphores in use.
NetChanInUseMax FLOAT NOT NULL -(20)9 Maximum number of channels in use.
NetGroupInUseMax FLOAT NOT NULL -(20)9 Maximum number of groups in use.
NetHWBackoffs FLOAT NOT NULL -(20)9 Hardware backoffs reported by the BLM for all BYNETs.
NetTxCircPtP FLOAT NOT NULL -(20)9 Number (both normal and high priority) of point-to-point circuits transmitted on all BYNETs.
HostBlockReads FLOAT NOT NULL -(20)9 Number of blocks read in from the host.
HostBlockWrites FLOAT NOT NULL -(20)9 Number of blocks written out to the host.
HostMessageReads FLOAT NOT NULL -(20)9 Number of messages read in from the host.
HostMessageWrites FLOAT NOT NULL -(20)9 Number of messages written out to the host.
DBLockBlocks FLOAT NOT NULL -(20)9 Number of times a database lock was blocked.
DBLockDeadlocks FLOAT NOT NULL -(20)9 Number of times a database lock was deadlocked.
FileAcqs FLOAT NOT NULL -(20)9 Number of disk segments acquires that were logically acquired. Only the FileAcqs column is counted as a cache hit.
FileAcqsOther FLOAT NOT NULL -(20)9 Number scratch disk segments that were logically acquired.
FileAcqReads FLOAT NOT NULL -(20)9 Number of disk segment acquired that caused a physical read.
FileRels FLOAT NOT NULL -(20)9 Number of disk segments released by tasks.
FileRelsOther FLOAT NOT NULL -(20)9 Number of scratch disk segments released as part of them being deleted.
FileWrites FLOAT NOT NULL -(20)9 Number of disk segment immediate or delayed physical writes.
FilePres FLOAT NOT NULL -(20)9 Number of times a logical data prefetch was performed (either as a cylinder read or individual block reads).
FilePreReads FLOAT NOT NULL -(20)9 Number of times a data prefetch was physically performed either as a cylinder read or individual blocks read.
FileLockBlocks FLOAT NOT NULL -(20)9 Number of lock requests that were blocked
FileLockDeadlocks FLOAT NOT NULL -(20)9 Number of deadlocks detected on lock requests.
FileLockEnters FLOAT NOT NULL -(20)9 Number of times a lock was requested.
FileSmallDepotWrites FLOAT NOT NULL -(20)9 Number of small writes to the depot performed to protect in-place modifications. Each small Depot write protects a single in-place write of either a write ahead logging (WAL) data block or a database data block.
FileLargeDepotWrites FLOAT NOT NULL -(20)9 Number of large writes to the depot performed to protect in-place modifications. Each large Depot write protects multiple in-place writes of either WAL data blocks or database data blocks.
FileLargeDepotBlocks FLOAT NOT NULL -(20)9 Total number of blocks (either WAL or database) that have been protected by large Depot writes. The average number of blocks protected by each large Depot write = FileLargeDepotBlocks / FileLargeDepotWrites.
MsgChnLastDone FLOAT NOT NULL -(20)9 Number of last done events that occurred on this node.

The last AMP to finish an operation may send a last done broadcast message indicating the work is done for this step. This is used in tracking down the slowest node or AMP in the system.
CmdDDLStmts FLOAT NOT NULL -(20)9 Number of alter, modify, drop, create, replace, grant or revoke commands.
CmdDeleteStmts FLOAT NOT NULL -(20)9 Number of delete commands.
CmdInsertStmts FLOAT NOT NULL -(20)9 Number of insert commands.
CmdSelectStmts FLOAT NOT NULL -(20)9 Number of select commands.
CmdUpdateStmts FLOAT NOT NULL -(20)9 Number of update commands.
CmdUtilityStmts FLOAT NOT NULL -(20)9 Number of utility commands.
CmdOtherStmts FLOAT NOT NULL -(20)9 Number of other commands.
CmdStmtSuccesses FLOAT NOT NULL -(20)9 Number of statements that departed normally.
CmdStmtFailures FLOAT NOT NULL -(20)9 Number of statements that departed in failure or were aborted.
CmdStmtErrors FLOAT NOT NULL -(20)9 Number of statements that departed in error.
AmpsFlowControlled FLOAT NOT NULL -(20)9 Number of AMPs currently in flow control on the work input mailbox.
FlowCtlCnt FLOAT NOT NULL -(20)9 Number of times this period that the node entered the flow control state from a non-flow controlled state.
AwtInuse FLOAT NOT NULL -(20)9 Number of AMP Worker Tasks currently in use for this node.
AwtInuseMax FLOAT NOT NULL -(20)9 Peak number of AMP Worker Tasks (Max) on this node. This is not the Peak or the Max value stored in the Priority Scheduler (sch) data structure and reported by the puma utility.
PSNumRequests FLOAT NOT NULL -(20)9 Number of work requests received for all Performance Groups on this node.
TvsReadRespMax FLOAT NOT NULL -(20)9 Maximum read response time value during the reporting period.
TvsWriteRespMax FLOAT NOT NULL -(20)9 Maximum response time of logical device writes during the reporting period.
NLBActiveSessionsMax FLOAT NOT NULL -(20)9 Maximum concurrent Node Level Buffering sessions.
NLBSessionsInuse FLOAT NOT NULL -(20)9 Current number of active Node Level Buffering sessions.
NLBSessionsCompleted FLOAT NOT NULL -(20)9 Number of Node Level Buffering sessions completed.
NLBMsgFlowControlled FLOAT NOT NULL -(20)9 Number of Node Level Buffered messages being flow controlled on the sender side (or node).
NetActiveMrg FLOAT NOT NULL -(20)9 Number of concurrent active merges on all BYNETs.
NetMrgCompleted FLOAT NOT NULL -(20)9 Number of BYNET merges completed.
FileSmallDepotBusy FLOAT NOT NULL -(20)9 Number of times a Small Depot I/O request waited for a free Slot.
FileLargeDepotBusy FLOAT NOT NULL -(20)9 Number of times a Large Depot I/O request waited for a free Slot.
SegMaxAvailMB FLOAT NOT NULL -(20)9 Current MB of maximum PDE segment files available.
SegInuseMB FLOAT NOT NULL -(20)9 Current MB of PDE segment files in use.
SegCacheMB FLOAT NOT NULL -(20)9 Current MB of segment cache.
SegMDLAlloc FLOAT NOT NULL -(20)9 Number of segments of all sizes allocated for the MDL pool during this period.
SegMDLFree FLOAT NOT NULL -(20)9 Number of dirty segments of all sizes freed from the MDL pool during this period.
SegMDLRelease FLOAT NOT NULL -(20)9 Number of clean segments of all sizes freed from the MDL pool during this period.
SegMDLRecycle FLOAT NOT NULL -(20)9 Number of segments of all sizes recycled to the MDL pool during this period.
SegMDLAllocKB FLOAT NOT NULL -(20)9 KB of segments of all sizes allocated for the MDL pool during this period.
SegMDLFreeKB FLOAT NOT NULL -(20)9 KB of dirty segments of all sizes freed from the MDL pool during this period.
SegMDLReleaseKB FLOAT NOT NULL -(20)9 KB of clean segments of all sizes freed from the MDL pool during this period.
SegMDLRecycleKB FLOAT NOT NULL -(20)9 KB of segments of all sizes recycled to the MDL pool during this period.
RTCpuTime FLOAT NOT NULL -(20)9 Total CPU time in milliseconds consumed by boosted real-time tasks.
RTTasksMax FLOAT NOT NULL -(20)9 Maximum number of tasks running in boosted real-time priority.
TDEnabledCPUs FLOAT NOT NULL -(20)9 Number of CPUs available for Teradata tasks at the end of the reporting period.