MV_SYSINFO_CPULIST

This view describes the total CPU usage breakdown of SingleStore and other processes per core.

To get the breakdown per host, aggregate the values for each core grouped by host.

Column name	Description
`node_id`	The ID of the node.
`ip_addr`	The IP address of the node.
`port`	The port on which the node is listening.
`type`	`MA`, `Leaf`, or `CA`
`cpu_id`	The ID of the core.
`total_used_cumulative_ns`	Per core CPU usage since the startup of the machine.
`user_used_cumulative_ns`	Per core CPU usage, in user mode, since the startup of the machine.
`nice_cumulative_ns`	Per core CPU usage, in nice mode, since the startup of the machine.
`system_cumulative_ns`	Per core CPU usage, in kernel mode, since the startup of the machine.
`idle_cumulative_ns`	Per core CPU idle time since the startup of the machine.
`iowait_cumulative_ns`	Per core CPU waiting time for I/O since the startup of the machine.
`irq_cumulative_ns`	Time spent on servicing interrupts on the core.
`softirq_cumulative_ns`	Time spent on servicing soft interrupts on the core.
`steal_cumulative_ns`	Stolen time, which is the time spent in other operating systems when running in a virtualized environment.
`guest_cumulative_ns`	Time spent running a virtual CPU for guest operating systems under the control of the Linux kernel.
`guest_nice_cumulative_ns`	Time spent running a nice guest (virtual CPU for guest operating systems under the control of the Linux kernel).
`timestamp_ns`	The time when the data was received.

Was this article helpful?