docker_container_stats
======================

Docker container statistics. Queries on this table take at least one second.

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: docker_container_stats``

- Linux
- Mac OSX

Table schema
------------

========================  =======  ===================================================
Name                      Type     Description                                        
========================  =======  ===================================================
id                        TEXT     Container ID                                       
name                      TEXT     Container name                                     
pids                      INTEGER  Number of processes                                
read                      BIGINT   UNIX time when stats were read                     
preread                   BIGINT   UNIX time when stats were last read                
interval                  BIGINT   Difference between read and preread in nano-seconds
disk_read                 BIGINT   Total disk read bytes                              
disk_write                BIGINT   Total disk write bytes                             
num_procs                 INTEGER  Number of processors                               
cpu_total_usage           BIGINT   Total CPU usage                                    
cpu_kernelmode_usage      BIGINT   CPU kernel mode usage                              
cpu_usermode_usage        BIGINT   CPU user mode usage                                
system_cpu_usage          BIGINT   CPU system usage                                   
online_cpus               INTEGER  Online CPUs                                        
pre_cpu_total_usage       BIGINT   Last read total CPU usage                          
pre_cpu_kernelmode_usage  BIGINT   Last read CPU kernel mode usage                    
pre_cpu_usermode_usage    BIGINT   Last read CPU user mode usage                      
pre_system_cpu_usage      BIGINT   Last read CPU system usage                         
pre_online_cpus           INTEGER  Last read online CPUs                              
memory_usage              BIGINT   Memory usage                                       
memory_max_usage          BIGINT   Memory maximum usage                               
memory_limit              BIGINT   Memory limit                                       
network_rx_bytes          BIGINT   Total network bytes read                           
network_tx_bytes          BIGINT   Total network bytes transmitted                    
========================  =======  ===================================================

Query examples
--------------

.. code-block:: sql

   select * from docker_container_stats where id = 'de8cfdc74c850967'


.. code-block:: sql

   select * from docker_container_stats where id = 'de8cfdc74c850967fd3832e128f4d12e2d5476a4aea282734bfb7e57f66fce2f'