Displays information from /proc/stat file about the time the cpu cores spent in different parts of the system.

Platform support

Please be aware that some queries can only be run against certain platforms. Below is a list of the supported platforms that this query supports. Zercurity will automatically pause queries from running if errors are detected. Running a query against an unsupported platform will result in the following error: no such table: cpu_time

  • Linux
  • Mac OSX

Table schema

Name Type Description
core INTEGER Name of the cpu (core)
user BIGINT Time spent in user mode
nice BIGINT Time spent in user mode with low priority (nice)
system BIGINT Time spent in system mode
idle BIGINT Time spent in the idle task
iowait BIGINT Time spent waiting for I/O to complete
irq BIGINT Time spent servicing interrupts
softirq BIGINT Time spent servicing softirqs
steal BIGINT Time spent in other operating systems when running in a virtualized environment
guest BIGINT Time spent running a virtual CPU for a guest OS under the control of the Linux kernel
guest_nice BIGINT Time spent running a niced guest

Query examples

Select all the results for the given table.

SELECT * FROM cpu_time;