These columns represent CPU activities on the node associated with the AMP Worker Task, Dispatcher, Parser, or miscellaneous activities.
When an external routine (such as C, C++, Java UDF, or external stored procedure) forks a child process or thread, the CPU time is not reported to these fields. As a result, the resource usage table shows a lower CPU usage than shown in the ResUsageSpma table even if the external routine consumes a large amount of CPU time. If there are child processes or threads running on your system, this may account for the larger CPU times reported in the ResUsageSpma table compared to this table. To confirm that the difference in CPU usage reported by the ResUsageSpma table is caused by child processes or threads, contact your Teradata Support Center personnel.
Column Name | Mode | Description | Data Type |
---|---|---|---|
CPUUServ | count | CPU time in milliseconds spent by AMP Worker Task or Dispatcher/Parser executing user service code. If VprType is AMP, the field contains the system-level AMP worker task CPU usage. If VprType is PE, the field contains the system-level Dispatcher/Parser CPU usage. | FLOAT |
CPUUServOther | count | Time in milliseconds CPUs are busy executing miscellaneous activities for user service code. This is the system-level time spent on a process. | FLOAT |
CPUUExec | count | CPU time in milliseconds spent by AMP Worker Task or Dispatcher/Parser executing user execution code. If VprType is AMP, the field contains the user-level AMP worker task CPU usage. If VprType is PE, the field contains the user-level Dispatcher/Parser CPU usage. | FLOAT |
CPUUExecOther | count | Time in milliseconds CPUs are busy executing miscellaneous activities for user execution code. This is the user-level time spent on a process. | FLOAT |