Database: td_metric_svc
If you need detailed statistics for AMP Worker Tasks (AWT) per AMP in the system, use this view to:
- Get a historical view of AWT utilization across the system.
- Get the length of each AMP message queue (mailbox), the queue which holds work messages from the Dispatcher that are waiting to be serviced by an AMP Worker Task.
- Get the frequency and duration for which an AMP entered flow control during the logging interval.
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. |
SummaryFlag | CHAR(1) LATIN NOT CASESPECIFIC NOT NULL | X(1) | Summarization status of this row. Possible values are N if the row is a non-summary row, and S if the row is a summary row. |
ReservedS0 | CHAR(7) LATIN NOT CASESPECIFIC NOT NULL | X(7) | Reserved for future use. |
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%. |
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%. |
vprId | INTEGER NOT NULL | -11(9) | Identifies the AMP vproc. |
Active | FLOAT NOT NULL | -(20)9 | Controls whether the rows are logged to the resource usage tables if Active Row Filter Mode is enabled. |
MailBoxDepth | FLOAT NOT NULL | -(20)9 | Current depth of the AMP work mailbox at the end of the period. |
FlowControlled | FLOAT NOT NULL | -(20)9 | If the value is non-zero, then the AMP is in flow control. Indicates flow control on incoming mailbox for AMPs only: work mailbox name 2-11, where 2 is the mailbox number and 11 is the AMP Worker Task partition. |
FlowCtlCnt | FLOAT NOT NULL | -(20)9 | Number of times during the log period that the system entered the flow control state from a non-flow controlled state. |
FlowCtlTime | FLOAT NOT NULL | -(20)9 | Total time, in milliseconds, that an AMP is in flow control. |
InuseMax | FLOAT NOT NULL | -(20)9 | Maximum number of AMP Worker Tasks in use at any one time during the log period. |
Available | FLOAT NOT NULL | -(20)9 | Number of unreserved AMP Worker Tasks from the pool that are not being used at the end of the interval. |
AvailableMin | FLOAT NOT NULL | -(20)9 | Minimum number of unreserved AMP Worker Tasks available in the pool for each AMP for the logged period. For example, a zero value means there were no unreserved AMP Worker Tasks available in the pool at some point during the reporting period. |
AWTsConfigured | FLOAT NOT NULL | -(20)9 | Current setting for AMP Worker Task (for example, 80, 100, or so on). |
WorkTypeInuse00 | FLOAT NOT NULL | -(20)9 | Current number of AMP Worker Tasks in use during the log period for work type MSGWORKNEW for the VprId vproc. |
WorkTypeInuse01 | FLOAT NOT NULL | -(20)9 | Current number of AMP Worker Tasks in use during the log period for work type MSGWORKONE for the VprId vproc. |
WorkTypeInuse02 | FLOAT NOT NULL | -(20)9 | Current number of AMP Worker Tasks in use during the log period for work type MSGWORKTWO for the VprId vproc. |
WorkTypeInuse03 | FLOAT NOT NULL | -(20)9 | Current number of AMP Worker Tasks in use during the log period for work type MSGWORKTHREE for the VprId vproc. |
WorkTypeInuse04 | FLOAT NOT NULL | -(20)9 | Current number of AMP Worker Tasks in use during the log period for work type MSGWORKFOUR for the VprId vproc. The WorkTypeInuse04 column value is at least 1 due to the internal database design for the Control AMP rows in the ResUsageSawt table. |
WorkTypeInuse05 | FLOAT NOT NULL | -(20)9 | Current number of AMP Worker Tasks in use during the log period for work type MSGWORKFIVE for the VprId vproc. |
WorkTypeInuse06 | FLOAT NOT NULL | -(20)9 | Current number of AMP Worker Tasks in use during the log period for work type MSGWORKSIX for the VprId vproc. |
WorkTypeInuse07 | FLOAT NOT NULL | -(20)9 | Current number of AMP Worker Tasks in use during the log period for work type MSGWORKSEVEN for the VprId vproc. |
WorkTypeInuse08 | FLOAT NOT NULL | -(20)9 | Current number of AMP Worker Tasks in use during the log period for work type MSGWORKEIGHT for the VprId vproc. |
WorkTypeInuse09 | FLOAT NOT NULL | -(20)9 | Current number of AMP Worker Tasks in use during the log period for work type MSGWORKNINE for the VprId vproc. |
WorkTypeInuse10 | FLOAT NOT NULL | -(20)9 | Current number of AMP Worker Tasks in use during the log period for work type MSGWORKTEN for the VprId vproc. |
WorkTypeInuse11 | FLOAT NOT NULL | -(20)9 | Current number of AMP Worker Tasks in use during the log period for work type MSGWORKELEVEN for the VprId vproc. |
WorkTypeInuse12 | FLOAT NOT NULL | -(20)9 | Current number of AMP Worker Tasks in use during the log period for work type MSGWORKABORT for the VprId vproc. |
WorkTypeInuse13 | FLOAT NOT NULL | -(20)9 | Current number of AMP Worker Tasks in use during the log period for work type MSGWORKSPAWN for the VprId vproc. |
WorkTypeInuse14 | FLOAT NOT NULL | -(20)9 | Current number of AMP Worker Tasks in use during the log period for work type MSGWORKNORMAL for the VprId vproc. |
WorkTypeInuse15 | FLOAT NOT NULL | -(20)9 | Current number of AMP Worker Tasks in use during the log period for work type MSGWORKCONTROL for the VprId vproc. |
WorkTypeMax00 | FLOAT NOT NULL | -(20)9 | Maximum number of AMP Worker Tasks in use at one time during the log period for work type MSGWORKNEW for the VprId vproc. |
WorkTypeMax01 | FLOAT NOT NULL | -(20)9 | Maximum number of AMP Worker Tasks in use at one time during the log period for work type MSGWORKONE for the VprId vproc. |
WorkTypeMax02 | FLOAT NOT NULL | -(20)9 | Maximum number of AMP Worker Tasks in use at one time during the log period for work type MSGWORKTWO for the VprId vproc. |
WorkTypeMax03 | FLOAT NOT NULL | -(20)9 | Maximum number of AMP Worker Tasks in use at one time during the log period for work type MSGWORKTHREE for the VprId vproc. |
WorkTypeMax04 | FLOAT NOT NULL | -(20)9 | Maximum number of AMP Worker Tasks in use at one time during the log period for work type MSGWORKFOUR for the VprId vproc. |
WorkTypeMax05 | FLOAT NOT NULL | -(20)9 | Maximum number of AMP Worker Tasks in use at one time during the log period for work type MSGWORKFIVE for the VprId vproc. |
WorkTypeMax06 | FLOAT NOT NULL | -(20)9 | Maximum number of AMP Worker Tasks in use at one time during the log period for work type MSGWORKSIX for the VprId vproc. |
WorkTypeMax07 | FLOAT NOT NULL | -(20)9 | Maximum number of AMP Worker Tasks in use at one time during the log period for work type MSGWORKSEVEN for the VprId vproc. |
WorkTypeMax08 | FLOAT NOT NULL | -(20)9 | Maximum number of AMP Worker Tasks in use at one time during the log period for work type MSGWORKEIGHT for the VprId vproc. |
WorkTypeMax09 | FLOAT NOT NULL | -(20)9 | Maximum number of AMP Worker Tasks in use at one time during the log period for work type MSGWORKNINE for the VprId vproc. |
WorkTypeMax10 | FLOAT NOT NULL | -(20)9 | Maximum number of AMP Worker Tasks in use at one time during the log period for work type MSGWORKTEN for the VprId vproc. |
WorkTypeMax11 | FLOAT NOT NULL | -(20)9 | Maximum number of AMP Worker Tasks in use at one time during the log period for work type MSGWORKELEVEN for the VprId vproc. |
WorkTypeMax12 | FLOAT NOT NULL | -(20)9 | Maximum number of AMP Worker Tasks in use at one time during the log period for work type MSGWORKABORT for the VprId vproc. |
WorkTypeMax13 | FLOAT NOT NULL | -(20)9 | Maximum number of AMP Worker Tasks in use at one time during the log period for work type MSGWORKSPAWN for the VprId vproc. |
WorkTypeMax14 | FLOAT NOT NULL | -(20)9 | Maximum number of AMP Worker Tasks in use at one time during the log period for work type MSGWORKNORMAL for the VprId vproc. |
WorkTypeMax15 | FLOAT NOT NULL | -(20)9 | Maximum number of AMP Worker Tasks in use at one time during the log period for work type MSGWORKCONTROL for the VprId vproc. |
UnReservedAwtPoolSize | FLOAT NOT NULL | -(20)9 | Total number of AWTs in the unreserved AWT pool. |
AvailableForWork00 | FLOAT NOT NULL | -(20)9 | Unused limit of AWTs for work type 00 at end period. |
AvailableForWork08 | FLOAT NOT NULL | -(20)9 | Unused limit of AWTs for work type 08 at end period. |
AvailableForWork00Min | FLOAT NOT NULL | -(20)9 | The minimum value of AvailableForWork00 over the entire period. |
AvailableForWork08Min | FLOAT NOT NULL | -(20)9 | The minimum value of AvailableForWork08 over the entire period. |
SpaceReactiveCnt | FLOAT NOT NULL | -(20)9 | Current number of AMP worker tasks waiting for reactive space allocations. |
SpaceReactiveWaitTime | FLOAT NOT NULL | -(20)9 | Total time in milliseconds AMP worker tasks were waiting for reactive space allocations. |
WorkTypeAWTExhausted00 | FLOAT NOT NULL | -(20)9 | Number of times a work message cannot be assigned to an AWT. |
WorkTypeAWTExhausted01 | FLOAT NOT NULL | -(20)9 | Number of times a work message cannot be assigned to an AWT. |
WorkTypeAWTExhausted02 | FLOAT NOT NULL | -(20)9 | Number of times a work message cannot be assigned to an AWT. |
WorkTypeAWTExhausted03 | FLOAT NOT NULL | -(20)9 | Number of times a work message cannot be assigned to an AWT. |
WorkTypeAWTExhausted04 | FLOAT NOT NULL | -(20)9 | Number of times a work message cannot be assigned to an AWT. |
WorkTypeAWTExhausted05 | FLOAT NOT NULL | -(20)9 | Number of times a work message cannot be assigned to an AWT. |
WorkTypeAWTExhausted06 | FLOAT NOT NULL | -(20)9 | Number of times a work message cannot be assigned to an AWT. |
WorkTypeAWTExhausted07 | FLOAT NOT NULL | -(20)9 | Number of times a work message cannot be assigned to an AWT. |
WorkTypeAWTExhausted08 | FLOAT NOT NULL | -(20)9 | Number of times a work message cannot be assigned to an AWT. |
WorkTypeAWTExhausted09 | FLOAT NOT NULL | -(20)9 | Number of times a work message cannot be assigned to an AWT. |
WorkTypeAWTExhausted10 | FLOAT NOT NULL | -(20)9 | Number of times a work message cannot be assigned to an AWT. |
WorkTypeAWTExhausted11 | FLOAT NOT NULL | -(20)9 | Number of times a work message cannot be assigned to an AWT. |
WorkTypeAWTExhausted12 | FLOAT NOT NULL | -(20)9 | Number of times a work message cannot be assigned to an AWT. |
WorkTypeAWTExhausted13 | FLOAT NOT NULL | -(20)9 | Number of times a work message cannot be assigned to an AWT. |
WorkTypeAWTExhausted14 | FLOAT NOT NULL | -(20)9 | Number of times a work message cannot be assigned to an AWT. |
WorkTypeAWTExhausted15 | FLOAT NOT NULL | -(20)9 | Number of times a work message cannot be assigned to an AWT. |