Yaniv Dary has uploaded a new change for review. Change subject: history: added storage domain status to 3.2 views ......................................................................
history: added storage domain status to 3.2 views Change-Id: Ib25d5d8baf093dc6393c502eca862cec41e887a4 Signed-off-by: Yaniv Dary <[email protected]> --- M data-warehouse/historydbscripts_postgres/create_views_3_0.sql M data-warehouse/historydbscripts_postgres/create_views_3_1.sql M data-warehouse/historydbscripts_postgres/create_views_3_2.sql 3 files changed, 42 insertions(+), 30 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-dwh refs/changes/54/11954/1 diff --git a/data-warehouse/historydbscripts_postgres/create_views_3_0.sql b/data-warehouse/historydbscripts_postgres/create_views_3_0.sql index 4b2ff27..19a9bed 100644 --- a/data-warehouse/historydbscripts_postgres/create_views_3_0.sql +++ b/data-warehouse/historydbscripts_postgres/create_views_3_0.sql @@ -124,35 +124,38 @@ CREATE OR REPLACE VIEW v3_0_storage_domain_samples_history_view AS SELECT - history_id as history_id, + min(history_id) as history_id, history_datetime as history_datetime, storage_domain_id as storage_domain_id, - available_disk_size_gb as available_disk_size_gb, - used_disk_size_gb as used_disk_size_gb, - storage_configuration_version as storage_configuration_version -FROM storage_domain_samples_history; + max(available_disk_size_gb) as available_disk_size_gb, + max(used_disk_size_gb) as used_disk_size_gb, + max(storage_configuration_version) as storage_configuration_version +FROM storage_domain_samples_history +GROUP BY history_datetime, storage_domain_id; CREATE OR REPLACE VIEW v3_0_storage_domain_hourly_history_view AS SELECT - history_id as history_id, + min(history_id) as history_id, history_datetime as history_datetime, storage_domain_id as storage_domain_id, - available_disk_size_gb as available_disk_size_gb, - used_disk_size_gb as used_disk_size_gb, - storage_configuration_version as storage_configuration_version -FROM storage_domain_hourly_history; + max(available_disk_size_gb) as available_disk_size_gb, + max(used_disk_size_gb) as used_disk_size_gb, + max(storage_configuration_version) as storage_configuration_version +FROM storage_domain_hourly_history +GROUP BY history_datetime, storage_domain_id; CREATE OR REPLACE VIEW v3_0_storage_domain_daily_history_view AS SELECT - history_id as history_id, + min(history_id) as history_id, cast(history_datetime as TIMESTAMP WITH TIME ZONE) as history_datetime, storage_domain_id as storage_domain_id, - available_disk_size_gb as available_disk_size_gb, - used_disk_size_gb as used_disk_size_gb, - storage_configuration_version as storage_configuration_version -FROM storage_domain_daily_history; + max(available_disk_size_gb) as available_disk_size_gb, + max(used_disk_size_gb) as used_disk_size_gb, + max(storage_configuration_version) as storage_configuration_version +FROM storage_domain_daily_history +GROUP BY history_datetime, storage_domain_id; CREATE OR REPLACE VIEW v3_0_cluster_configuration_view AS diff --git a/data-warehouse/historydbscripts_postgres/create_views_3_1.sql b/data-warehouse/historydbscripts_postgres/create_views_3_1.sql index da4f777..69c3e9b 100644 --- a/data-warehouse/historydbscripts_postgres/create_views_3_1.sql +++ b/data-warehouse/historydbscripts_postgres/create_views_3_1.sql @@ -124,35 +124,38 @@ CREATE OR REPLACE VIEW v3_1_storage_domain_samples_history_view AS SELECT - history_id as history_id, + min(history_id) as history_id, history_datetime as history_datetime, storage_domain_id as storage_domain_id, - available_disk_size_gb as available_disk_size_gb, - used_disk_size_gb as used_disk_size_gb, - storage_configuration_version as storage_configuration_version -FROM storage_domain_samples_history; + max(available_disk_size_gb) as available_disk_size_gb, + max(used_disk_size_gb) as used_disk_size_gb, + max(storage_configuration_version) as storage_configuration_version +FROM storage_domain_samples_history +GROUP BY history_datetime, storage_domain_id; CREATE OR REPLACE VIEW v3_1_storage_domain_hourly_history_view AS SELECT - history_id as history_id, + min(history_id) as history_id, history_datetime as history_datetime, storage_domain_id as storage_domain_id, - available_disk_size_gb as available_disk_size_gb, - used_disk_size_gb as used_disk_size_gb, - storage_configuration_version as storage_configuration_version -FROM storage_domain_hourly_history; + max(available_disk_size_gb) as available_disk_size_gb, + max(used_disk_size_gb) as used_disk_size_gb, + max(storage_configuration_version) as storage_configuration_version +FROM storage_domain_hourly_history +GROUP BY history_datetime, storage_domain_id; CREATE OR REPLACE VIEW v3_1_storage_domain_daily_history_view AS SELECT - history_id as history_id, + min(history_id) as history_id, history_datetime as history_datetime, storage_domain_id as storage_domain_id, - available_disk_size_gb as available_disk_size_gb, - used_disk_size_gb as used_disk_size_gb, - storage_configuration_version as storage_configuration_version -FROM storage_domain_daily_history; + max(available_disk_size_gb) as available_disk_size_gb, + max(used_disk_size_gb) as used_disk_size_gb, + max(storage_configuration_version) as storage_configuration_version +FROM storage_domain_daily_history +GROUP BY history_datetime, storage_domain_id; CREATE OR REPLACE VIEW v3_1_cluster_configuration_view AS diff --git a/data-warehouse/historydbscripts_postgres/create_views_3_2.sql b/data-warehouse/historydbscripts_postgres/create_views_3_2.sql index f9342ae..87a628b 100644 --- a/data-warehouse/historydbscripts_postgres/create_views_3_2.sql +++ b/data-warehouse/historydbscripts_postgres/create_views_3_2.sql @@ -127,6 +127,8 @@ history_id as history_id, history_datetime as history_datetime, storage_domain_id as storage_domain_id, + storage_domain_status, + minutes_in_status, available_disk_size_gb as available_disk_size_gb, used_disk_size_gb as used_disk_size_gb, storage_configuration_version as storage_configuration_version @@ -138,6 +140,8 @@ history_id as history_id, history_datetime as history_datetime, storage_domain_id as storage_domain_id, + storage_domain_status, + minutes_in_status, available_disk_size_gb as available_disk_size_gb, used_disk_size_gb as used_disk_size_gb, storage_configuration_version as storage_configuration_version @@ -149,6 +153,8 @@ history_id as history_id, history_datetime as history_datetime, storage_domain_id as storage_domain_id, + storage_domain_status, + minutes_in_status, available_disk_size_gb as available_disk_size_gb, used_disk_size_gb as used_disk_size_gb, storage_configuration_version as storage_configuration_version -- To view, visit http://gerrit.ovirt.org/11954 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: Ib25d5d8baf093dc6393c502eca862cec41e887a4 Gerrit-PatchSet: 1 Gerrit-Project: ovirt-dwh Gerrit-Branch: master Gerrit-Owner: Yaniv Dary <[email protected]> _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
