Database: td_metric_svc
If you need detailed statistics for each CPU within the system, use this view to evaluate parallelism of CPUs within a node.
| 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 | Number of seconds since midnight, January 1, 1970. |
| 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(1) LATIN NOT CASESPECIFIC | X(1) | 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%. |
| cpuid | SMALLINT NOT NULL | -6(9) | Identifies the CPU within this node. The values are 0 through NCPUs-1. In Summary Mode, the value is -1. |
| CPUFrequencyMHz | FLOAT NOT NULL | -(20)9 | CPU Frequencies in MHz. |
| Active | FLOAT NOT NULL | -(20)9 | Controls whether the rows are logged to the resource usage tables if Active Row Filter Mode is enabled. |
| CPUIdle | FLOAT NOT NULL | -(20)9 | Time in centiseconds the CPU is idle and not waiting for I/O. |
| CPUIoWait | FLOAT NOT NULL | -(20)9 | Time in centiseconds CPU is waiting for I/O completion. |
| CPUUServ | FLOAT NOT NULL | -(20)9 | Time in centiseconds CPU is busy executing kernel system calls or servicing I/O and timer hardware interrupts. |
| CPUUExec | FLOAT NOT NULL | -(20)9 | Time in centiseconds CPU is busy executing user execution code, that is, time spent in a user state on behalf of a process. |
| TDEnabled | FLOAT NOT NULL | -(20)9 | Indicates whether the CPU is TD-enabled at the end of the reporting period. |