# MV\_SYSINFO\_CPU

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

| 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`                                                                                                                    |
| `memsql_total_cumulative_ns`  | CPU usage by theSingleStoreprocess since its startup.                                                                                  |
| `memsql_user_cumulative_ns`   | CPU usage by theSingleStoreprocess, in user mode, since process startup.                                                               |
| `memsql_system_cumulative_ns` | CPU usage by theSingleStoreprocess, in kernel mode, since process startup.                                                             |
| `total_used_cumulative_ns`    | CPU usage since the startup of the machine. It refers to the whole machine, and not toSingleStorecgroup.                               |
| `user_used_cumulative_ns`     | CPU usage in user mode since the startup of the machine.                                                                               |
| `nice_cumulative_ns`          | CPU usage in nice mode since the startup of the machine.                                                                               |
| `system_cumulative_ns`        | CPU usage in kernel mode since the startup of the machine.                                                                             |
| `idle_cumulative_ns`          | CPU idle time since the startup of the machine.                                                                                        |
| `iowait_cumulative_ns`        | CPU waiting time for I/O since the startup of the machine.                                                                             |
| `irq_cumulative_ns`           | Time spent on servicing interrupts.                                                                                                    |
| `softirq_cumulative_ns`       | Time spent on servicing soft interrupts.                                                                                               |
| `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).                       |
| `cfs_quota_ns`                | The amount of time in nanoseconds that the cgroup (that thisSingleStoreprocess is a member of) is allowed to spend per`cfs_period_ns`. |
| `cfs_period_ns`               | Used in conjunction with`cfs_quota_ns`.                                                                                                |
| `num_cpus`                    | The number of cores on host.                                                                                                           |
| `timestamp_ns`                | The time when the data was received.                                                                                                   |

***

Modified at: August 29, 2022

Source: [/db/v9.1/reference/information-schema-reference/management/mv-sysinfo-cpu/](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/management/mv-sysinfo-cpu/)

(An index of the documentation is available at /llms.txt)