Arik Hadas has submitted this change and it was merged. Change subject: core: improve vm_monitoring_view ...................................................................... core: improve vm_monitoring_view Instead of querying vm_static and then filtering VMs (rather than templates and instance types), lets do it more efficiently: we query vm_dynamic (only VMs have entry in vm_dynamic) and join the result with vm_static. Change-Id: Icf4c1130826b1118354f97878d4b82001621f471 Signed-off-by: Arik Hadas <ahadas(a)redhat.com&gt; --- M packaging/dbscripts/create_views.sql 1 file changed, 3 insertions(+), 4 deletions(-) Approvals: Eli Mesika: Looks good to me, but someone else must approve Shahar Havivi: Looks good to me, approved Jenkins CI: Passed CI tests Arik Hadas: Verified -- To view, visit https://gerrit.ovirt.org/60341 To unsubscribe, visit https://gerrit.ovirt.org/settings Gerrit-MessageType: merged Gerrit-Change-Id: Icf4c1130826b1118354f97878d4b82001621f471 Gerrit-PatchSet: 2 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Arik Hadas <ahadas(a)redhat.com&gt; Gerrit-Reviewer: Arik Hadas <ahadas(a)redhat.com&gt; Gerrit-Reviewer: Eli Mesika <emesika(a)redhat.com&gt; Gerrit-Reviewer: Jenkins CI Gerrit-Reviewer: Michal Skrivanek <michal.skrivanek(a)redhat.com&gt; Gerrit-Reviewer: Shahar Havivi <shavivi(a)redhat.com&gt; Gerrit-Reviewer: gerrit-hooks <automation(a)ovirt.org&gt;