Allon Mureinik has submitted this change and it was merged. Change subject: core: CalculateStorageUsage psql function refactoring. ...................................................................... core: CalculateStorageUsage psql function refactoring. CalculateStorageUsage psql function was joining tables that were already joined by images_storage_domain_view, also- executed almost the same query twice- while it could be consolidated into one query by adding a simple condition. This patch changes the query to select only from images_storage_domain_view, and consolidating the two queries. Change-Id: I3997cb4f310ca8ebaf8d36f9ffae1d126fa7de00 Signed-off-by: Amit Aviram <aaviram@redhat.com> --- M packaging/dbscripts/create_functions.sql 1 file changed, 9 insertions(+), 20 deletions(-) Approvals: Jenkins CI: Passed CI tests Amit Aviram: Verified Allon Mureinik: Looks good to me, approved Maor Lipchuk: Looks good to me, approved -- To view, visit https://gerrit.ovirt.org/48309 To unsubscribe, visit https://gerrit.ovirt.org/settings Gerrit-MessageType: merged Gerrit-Change-Id: I3997cb4f310ca8ebaf8d36f9ffae1d126fa7de00 Gerrit-PatchSet: 7 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Amit Aviram <aaviram@redhat.com> Gerrit-Reviewer: Allon Mureinik <amureini@redhat.com> Gerrit-Reviewer: Amit Aviram <aaviram@redhat.com> Gerrit-Reviewer: Daniel Erez <derez@redhat.com> Gerrit-Reviewer: Jenkins CI Gerrit-Reviewer: Maor Lipchuk <mlipchuk@redhat.com> Gerrit-Reviewer: Roy Golan <rgolan@redhat.com> Gerrit-Reviewer: gerrit-hooks <automation@ovirt.org>