From cbdbf818004040b60aa122dc6cb98ef635fa5ac1 Mon Sep 17 00:00:00 2001
From: Fabian Mastenbroek <mail.fabianm@gmail.com>
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

