cpu_time

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;