Bug 1796258 - GET /owners/{owner_key}/pools is very slow
Summary: GET /owners/{owner_key}/pools is very slow
Alias: None
Product: Red Hat Satellite
Classification: Red Hat
Component: Candlepin
Version: 6.6.0
Hardware: All
OS: All
Target Milestone: 6.7.0
Assignee: satellite6-bugs
QA Contact: jcallaha
Depends On: 1806574
TreeView+ depends on / blocked
Reported: 2020-01-30 01:19 UTC by matt jia
Modified: 2020-04-14 13:28 UTC (History)
6 users (show)

Fixed In Version: candlepin-2.9.25-1
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
: 1806574 (view as bug list)
Last Closed: 2020-04-14 13:28:34 UTC
Target Upstream Version:

Attachments (Terms of Use)

System ID Priority Status Summary Last Updated
Red Hat Product Errata RHSA-2020:1454 None None None 2020-04-14 13:28:48 UTC

Description matt jia 2020-01-30 01:19:42 UTC
Description of problem:

In a Satellite environment where it has 2k+ hypervisors, it takes 15+ minutes to call this api to get a list for pools which is considerably slow.

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


How reproducible:


Steps to Reproduce:
1. set up a satellite server with 3k+ hypervisors. 
2. call the api

Actual results:

It takes 15min+ for the api to return all the pools.

Expected results:

It shouldn't take this long.

Comment 12 jcallaha 2020-03-12 17:26:15 UTC
Verified in Satellite 6.7 Snap 16.

I pushed my system beyond 5k hypervisors and got the following results:

irb(main):005:0> Benchmark.bm{|x| x.report{ Katello::Pool.get_for_owner('Default_Organization') }}
       user     system      total        real
   6.281571   0.585320   6.866891 ( 10.714442)
=> [#<Benchmark::Tms:0x000000002103d600 @label="", @real=10.714441663003527, @cstime=0.0, @cutime=0.0, @stime=0.5853199999999994, @utime=6.281571, @total=6.866890999999999>]

Comment 14 errata-xmlrpc 2020-04-14 13:28:34 UTC
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.


Note You need to log in before you can comment on or make changes to this bug.