** Changed in: nova
Status: Fix Committed => Fix Released
** Changed in: nova
Milestone: None => kilo-1
--
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Compute (nova).
https://bugs.launchpad.net/bugs/1383469
Title:
InstanceList.get_active_by_window_joined only needs system_metadata
for expected_attrs in simple-tenant-usage API
Status in OpenStack Compute (Nova):
Fix Released
Bug description:
The os-simple-tenant-usage API queries the database over a given time
range (default is 1 month at most from Horizon and novaclient) and
pulls all instance information from the database for a given tenant.
As you add more instances, this API is going to take longer given the
joins required in the database for the instances table here:
http://git.openstack.org/cgit/openstack/nova/tree/nova/api/openstack/compute/contrib/simple_tenant_usage.py?id=2014.2#n142
However, the only join we really need there is on system_metadata when
getting the flavor information:
http://git.openstack.org/cgit/openstack/nova/tree/nova/api/openstack/compute/contrib/simple_tenant_usage.py?id=2014.2#n114
This means we're joining on these other tables unnecessarily:
INSTANCE_DEFAULT_FIELDS = ['metadata', 'system_metadata',
'info_cache', 'security_groups']
To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/1383469/+subscriptions
--
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : [email protected]
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
