[Bug 1404076] Re: Optimize Ceilometer resource list query

[Launchpad Bug Tracker]

** Branch linked: lp:ubuntu/trusty-proposed/ceilometer

-- 
You received this bug notification because you are a member of Ubuntu
OpenStack, which is subscribed to ceilometer in Ubuntu.
https://bugs.launchpad.net/bugs/1404076

Title:
  Optimize Ceilometer resource list query

Status in Ceilometer:
  Fix Released
Status in ceilometer package in Ubuntu:
  Fix Released
Status in ceilometer source package in Trusty:
  Fix Committed

Bug description:
  [Impact]

   * Ceilometer resource-list requires an open-ended scan of resource
  and sample tables to retrieve a unique list of resources.  There
  should be a way to optimize the scans.

  [Test Case]

   * Deploy an openstack cloud using the current trusty package of ceilometer.
   * Run a 'ceilometer resource-list' without the patch the running
  time for that command takes (if returns).

  ubuntu at queen:~$ time ceilometer resource-list | wc -l 
  10031 real	1m3.975s user	0m3.572s sys	0m0.187s 
  ubuntu at queen:~$ time ceilometer resource-list | wc -l 
  10036 real	1m54.993s user	0m3.354s sys	0m0.184s 

  * With the included SRU patch :

  real	0m15.693s
  user	0m1.104s

  sys	0m0.065s
  [Regression Potential] 

   * None expected.

  [Other Info]

  * Backport of https://review.openstack.org/142951

To manage notifications about this bug go to:
https://bugs.launchpad.net/ceilometer/+bug/1404076/+subscriptions