The system table SYSINFO.TASKGROUPSTATISTICS contains information about task groups and their resource usage since the last start of the database.
TASKGROUPID |
FIXED(10) |
Identification of the task group |
THREADID |
FIXED(10) |
Identification of the thread in the operating system |
TASKCLUSTER |
CHAR(20) |
Task cluster to which this task group belongs |
TASKCOUNT |
FIXED(10) |
Number of tasks in this group |
THREADSTATE |
CHAR(20) |
Operation state of this task group |
USEDRUNQUEUELENGTH |
FIXED(10) |
Number of tasks lined up for CPU assignment |
MAXUSEDRUNQUEUELENGTH |
FIXED(10) |
Maximum number of tasks lined up for CPU assignment |
DISPATCHCOUNT |
FIXED(20) |
Number of task scheduler calls |
TASKSWITCHCOUNT |
FIXED(20) |
Number of task switches in this task group |
COMMANDCOUNT |
FIXED(20) |
Number of commands executed by the tasks of this task group |
IDLECOUNT |
FIXED(20) |
Number of time intervals in which the CPU was released |
IDLETIME |
FIXED(20) |
Total time for which the CPU was released (µs) |
IOWAITCOUNT |
FIXED(20) |
Number of time intervals in which waits for outstanding I/O operations occurred |
IOWAITTIME |
FIXED(20) |
Total wait time for outstanding I/O operations (µs) |
USEDSYSTEMTIME |
FIXED(20) |
Total CPU time used in system mode (µs) |
USEDUSERTIME |
FIXED(20) |
Total CPU time used in user mode (µs) |