Bug #18704

packages page is slow

Added by Brad Buckingham about 1 month ago. Updated 14 days ago.

Assigned To:John Mitsch
Target version:Team Brad - Iteration 12
Difficulty: Pull request:
Bugzilla link:1419139
Story points-
Velocity based estimate-
ReleaseBacklogRelease relationshipAuto


Cloned from https://bugzilla.redhat.com/show_bug.cgi?id=1419139

Description of problem:

If the katello install has a large number of packages, the packages page can be very slow (over 18 seconds). In particular, this API call takes quite some time to return:


Ideally, the page would load in less than 5 seconds.

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

Steps to Reproduce:
1. sync a bunch of repos containing numerous packages
2. go to content -> packages page
3. wait

Actual results: 18+ seconds of waiting

Expected results: 5 or less seconds of waiting

Additional info:

2017-02-03 11:49:07 [app] [I] Started GET "/katello/api/v2/packages?organization_id=1&page=2&paged=true&search=" for at 2017-02-03 11:49:07 -0500
2017-02-03 11:49:07 [app] [I] Processing by Katello::Api::V2::PackagesController#index as JSON
2017-02-03 11:49:07 [app] [I] Parameters: {"organization_id"=>"1", "page"=>"2", "paged"=>"true", "search"=>"", "api_version"=>"v2"}
2017-02-03 11:49:18 [app] [I] Rendered /opt/theforeman/tfm/root/usr/share/gems/gems/katello- within katello/api/v2/layouts/collection (3513.7ms)
2017-02-03 11:49:18 [app] [I] Completed 200 OK in 10947ms (Views: 22.9ms | ActiveRecord: 10829.9ms)

the SQL is too big to paste, but the explain is at https://explain.depesz.com/s/JZG


#1 Updated by Brad Buckingham about 1 month ago

  • Subject changed from packages page is slow to packages page is slow
  • Target version set to Team Brad - Iteration 11
  • Release set to Backlog

#2 Updated by Brad Buckingham 16 days ago

  • Target version changed from Team Brad - Iteration 11 to Team Brad - Iteration 12

#3 Updated by John Mitsch 14 days ago

  • Assigned To set to John Mitsch

Also available in: Atom PDF