Docker CPU Usage

[Query_Admin]

Description: Statistics on Docker container CPU usage.

What The Data Shows: Lists statistics on Docker container CPU usage including a calculated percentage of kernel and user space usage.

SQL: 

SELECT name,cpu_total_usage, 
  SUBSTR((cpu_kernelmode_usage*1.0/cpu_total_usage*100),0,5) AS '% kernel', 
  SUBSTR((cpu_usermode_usage*1.0/cpu_total_usage*100),0,5) AS '% user' 

FROM docker_container_stats 

WHERE id IN (SELECT id FROM docker_containers);