# 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.                                                                                                   |

The system-wide CPU columns (`TOTAL_USED_CUMULATIVE_NS`, `USER_CUMULATIVE_NS`, `SYSTEM_CUMULATIVE_NS`, `IDLE_CUMULATIVE_NS`, `IOWAIT_CUMULATIVE_NS`, `IRQ_CUMULATIVE_NS`, `SOFTIRQ_CUMULATIVE_NS`, `STEAL_CUMULATIVE_NS`, `GUEST_CUMULATIVE_NS`, and `GUEST_NICE_CUMULATIVE_NS`) reflect total CPU activity as reported by the underlying host, without accounting for namespace segregation such as cgroups or kernel namespaces.

To measure CPU usage for your SingleStore process, use the `MEMSQL_TOTAL_CUMULATIVE_NS`, `MEMSQL_USER_CUMULATIVE_NS`, and `MEMSQL_SYSTEM_CUMULATIVE_NS` columns. These columns track only the SingleStore engine process.

The `CFS_QUOTA_NS` and `CFS_PERIOD_NS` columns report the cgroup CPU limits assigned to your cluster. Use these columns to determine your allocated CPU capacity.

***

Modified at: July 9, 2026

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)