Bug 1350313 - Add index for better performance to vm disks usage tables
Summary: Add index for better performance to vm disks usage tables
Keywords:
Status: CLOSED DEFERRED
Alias: None
Product: Red Hat Enterprise Virtualization Manager
Classification: Red Hat
Component: ovirt-engine-dwh
Version: 3.6.8
Hardware: Unspecified
OS: Unspecified
unspecified
medium
Target Milestone: ---
: ---
Assignee: Shirly Radco
QA Contact: Pavel Stehlik
URL:
Whiteboard:
Depends On: 1347996
Blocks:
TreeView+ depends on / blocked
 
Reported: 2016-06-27 06:26 UTC by Shirly Radco
Modified: 2022-07-13 07:55 UTC (History)
10 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of: 1347996
Environment:
Last Closed: 2016-06-27 06:49:38 UTC
oVirt Team: Metrics
Target Upstream Version:
Embargoed:

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker RHV-47625 0 None None None 2022-07-13 07:55:35 UTC
oVirt gerrit 59449 0 None None None 2016-06-27 06:26:28 UTC

Description Shirly Radco 2016-06-27 06:26:29 UTC 
+++ This bug was initially created as a clone of Bug #1347996 +++

Description of problem:
Add index for better performance to vm disks usage tables

Version-Release number of selected component (if applicable):
4.0

How reproducible:


Steps to Reproduce:
1.Test query results against the tables in scale env before and after the change.

--- Additional comment from Oved Ourfali on 2016-06-22 02:44:48 EDT ---

Shirly - this isn't posted/merged in 4.0, so can't move to modified.
Alexander's patch is already merged on 4.0. Can you make sure to backport this ASAP?
Note You need to log in before you can comment on or make changes to this bug.