-

CREATE TABLE crdb(
epoch numeric NOT NULL,
application text NOT NULL,
collection text NOT NULL,
cpu_boottime numeric NOT NULL,
cpu_context numeric NOT NULL,
cpu_idle numeric NOT NULL,
cpu_iowait numeric NOT NULL,
cpu_irq numeric NOT NULL,
cpu_kernel numeric NOT NULL,
cpu_nice numeric NOT NULL,
cpu_process_blocked numeric NOT NULL,
cpu_process_count numeric NOT NULL,
cpu_process_running numeric NOT NULL,
cpu_softirq numeric NOT NULL,
cpu_user numeric NOT NULL,
dc text NOT NULL,
descriptor_count numeric NOT NULL,
environment text NOT NULL,
fault_address numeric NOT NULL,
fingerprint text NOT NULL,
hostname text NOT NULL,
process_age numeric NOT NULL,
sched_cs_nonvoluntary numeric NOT NULL,
sched_cs_voluntary numeric NOT NULL,
system_memory_active numeric NOT NULL,
system_memory_buffers numeric NOT NULL,
system_memory_cached numeric NOT NULL,
system_memory_dirty numeric NOT NULL,
system_memory_free numeric NOT NULL,
system_memory_inactive numeric NOT NULL,
system_memory_slab numeric NOT NULL,
system_memory_swap_cached numeric NOT NULL,
system_memory_swap_free numeric NOT NULL,
system_memory_swap_total numeric NOT NULL,
system_memory_total numeric NOT NULL,
system_memory_vmalloc_chunk numeric NOT NULL,
system_memory_vmalloc_total numeric NOT NULL,
system_memory_vmalloc_used numeric NOT NULL,
system_memory_writeback numeric NOT NULL,
tag text NOT NULL,
tag_owner text NOT NULL,
timestamp numeric NOT NULL,
uname_release text NOT NULL,
vm_locked_size numeric NOT NULL,
vm_pte_size numeric NOT NULL,
vm_rss_peak numeric NOT NULL,
vm_rss_size numeric NOT NULL,
vm_shared_size numeric NOT NULL,
vm_stack_size numeric NOT NULL,
vm_swap_size numeric NOT NULL,
vm_vma_peak numeric NOT NULL,
vm_vma_size numeric NOT NULL,
PRIMARY KEY(epoch));