Shirly Radco has uploaded a new change for review. Change subject: history: update dwh_vm_disks_history_view ......................................................................
history: update dwh_vm_disks_history_view updated dwh_vm_disks_history_view. changed logic of vm_disk_actual_size_mb field to include the size of the vm snapshots. Change-Id: I1a96176c6b2c8455cb46f53cbcc71b6d64ef1efe Bug-Url:https://bugzilla.redhat.com/1169105 Signed-off-by: Shirly Radco <sra...@redhat.com> --- M packaging/dbscripts/create_dwh_views.sql 1 file changed, 25 insertions(+), 7 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/98/37798/1 diff --git a/packaging/dbscripts/create_dwh_views.sql b/packaging/dbscripts/create_dwh_views.sql index f62a4c4..9b4c502 100644 --- a/packaging/dbscripts/create_dwh_views.sql +++ b/packaging/dbscripts/create_dwh_views.sql @@ -396,7 +396,7 @@ SELECT d.disk_id as vm_disk_id, images.image_guid as image_id, cast(images.imageStatus as smallint) as vm_disk_status, - cast(disk_image_dynamic.actual_size / 1048576 as int) as vm_disk_actual_size_mb, + vm_disk_actual_size.vm_disk_actual_size_mb AS vm_disk_actual_size_mb, disk_image_dynamic.read_rate as read_rate_bytes_per_second, disk_image_dynamic.read_latency_seconds as read_latency_seconds, disk_image_dynamic.write_rate as write_rate_bytes_per_second, @@ -404,13 +404,31 @@ disk_image_dynamic.flush_latency_seconds as flush_latency_seconds FROM images INNER JOIN - disk_image_dynamic ON images.image_guid = disk_image_dynamic.image_id + disk_image_dynamic ON images.image_guid = disk_image_dynamic.image_id INNER JOIN - base_disks as d ON images.image_group_id = d.disk_id - LEFT OUTER JOIN vm_device ON vm_device.device_id = images.image_group_id - LEFT OUTER JOIN vm_static ON vm_static.vm_guid = vm_device.vm_id + base_disks as d ON images.image_group_id = d.disk_id + LEFT OUTER JOIN + vm_device ON vm_device.device_id = images.image_group_id + LEFT OUTER JOIN + vm_static ON vm_static.vm_guid = vm_device.vm_id + LEFT JOIN + ( + SELECT e.disk_id AS vm_disk_id, + cast(SUM(disk_image_dynamic.actual_size / 1048576) as int) AS vm_disk_actual_size_mb + FROM images images_b + INNER JOIN + disk_image_dynamic ON images_b.image_guid = disk_image_dynamic.image_id + INNER JOIN + base_disks e ON images_b.image_group_id = e.disk_id + LEFT OUTER JOIN + vm_device ON vm_device.device_id = images_b.image_group_id + LEFT OUTER JOIN + vm_static ON vm_static.vm_guid = vm_device.vm_id + WHERE vm_static.entity_type = 'VM' OR vm_static.entity_type IS NULL + GROUP BY vm_disk_id) AS vm_disk_actual_size + ON d.disk_id = vm_disk_actual_size.vm_disk_id WHERE images.active = true AND - (vm_static.entity_type = 'VM' OR vm_static.entity_type IS NULL); + (vm_static.entity_type = 'VM' OR vm_static.entity_type IS NULL) ; CREATE OR REPLACE VIEW dwh_remove_tags_relations_history_view AS SELECT tag_id as entity_id, @@ -535,4 +553,4 @@ true AS active, _create_date AS create_date, _update_date AS update_date -FROM users; \ No newline at end of file +FROM users; -- To view, visit http://gerrit.ovirt.org/37798 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I1a96176c6b2c8455cb46f53cbcc71b6d64ef1efe Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Shirly Radco <sra...@redhat.com> _______________________________________________ Engine-patches mailing list Engine-patches@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-patches
