rl544
15 lines
432 B
SQL
15 lines
432 B
SQL
DROP TABLE IF EXISTS client_metrics;
|
|
CREATE TABLE client_metrics (
|
|
id SERIAL PRIMARY KEY,
|
|
hostname VARCHAR(255) NOT NULL,
|
|
timestamp TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP,
|
|
total_cpu_percent FLOAT,
|
|
total_mem_percent FLOAT,
|
|
dpc_interrupt_percent FLOAT,
|
|
top_cpu_processes JSONB,
|
|
top_mem_processes JSONB,
|
|
top_io_processes JSONB,
|
|
network_connections JSONB,
|
|
hung_processes JSONB
|
|
);
|