From cbdbf818004040b60aa122dc6cb98ef635fa5ac1 Mon Sep 17 00:00:00 2001 From: Fabian Mastenbroek Date: Thu, 7 May 2020 23:31:07 +0200 Subject: feat: Add initial version of Postgres reporter --- opendc/opendc-experiments-sc20/schema.sql | 22 ++++++++++++++++++++++ 1 file changed, 22 insertions(+) create mode 100644 opendc/opendc-experiments-sc20/schema.sql (limited to 'opendc/opendc-experiments-sc20/schema.sql') diff --git a/opendc/opendc-experiments-sc20/schema.sql b/opendc/opendc-experiments-sc20/schema.sql new file mode 100644 index 00000000..51990a75 --- /dev/null +++ b/opendc/opendc-experiments-sc20/schema.sql @@ -0,0 +1,22 @@ +DROP TABLE IF EXISTS host_reports; +CREATE TABLE host_reports ( + id BIGSERIAL PRIMARY KEY NOT NULL, + experiment_id BIGINT NOT NULL, + time BIGINT NOT NULL, + duration BIGINT NOT NULL, + requested_burst BIGINT NOT NULL, + granted_burst BIGINT NOT NULL, + overcommissioned_burst BIGINT NOT NULL, + interfered_burst BIGINT NOT NULL, + cpu_usage DOUBLE PRECISION NOT NULL, + cpu_demand DOUBLE PRECISION NOT NULL, + image_count INTEGER NOT NULL, + server TEXT NOT NULL, + host_state TEXT NOT NULL, + host_usage DOUBLE PRECISION NOT NULL, + power_draw DOUBLE PRECISION NOT NULL, + total_submitted_vms BIGINT NOT NULL, + total_queued_vms BIGINT NOT NULL, + total_running_vms BIGINT NOT NULL, + total_finished_vms BIGINT NOT NULL +); -- cgit v1.2.3