Project

General

Profile

Bug #18704

packages page is slow

Added by Brad Buckingham over 2 years ago. Updated 12 months ago.

Status:
Closed
Priority:
High
Category:
API
Target version:
Difficulty:
hard
Triaged:
Yes
Bugzilla link:
Team Backlog:
Fixed in Releases:
Found in Releases:

Description

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:

https://localhost/katello/api/v2/packages?organization_id=1&page=1&paged=true&search=

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 10.10.121.39 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-3.0.0.95/app/views/katello/api/v2/packages/index.json.rabl 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

Associated revisions

Revision f3d1a0da (diff)
Added by Justin Sherrill almost 2 years ago

Fixes #18704 - improve packages api performance

History

#1 Updated by Brad Buckingham over 2 years ago

  • Subject changed from packages page is slow to packages page is slow
  • Target version set to 169
  • Legacy Backlogs Release (now unused) set to 114

#2 Updated by Brad Buckingham over 2 years ago

  • Target version changed from 169 to 178

#3 Updated by John Mitsch over 2 years ago

  • Assignee set to John Mitsch

#4 Updated by Brad Buckingham about 2 years ago

  • Target version changed from 178 to 181

#5 Updated by Brad Buckingham about 2 years ago

  • Target version changed from 181 to 187

#6 Updated by The Foreman Bot about 2 years ago

  • Status changed from New to Ready For Testing
  • Legacy Backlogs Release (now unused) deleted (114)
  • Pull request https://github.com/Katello/katello/pull/6772 added

#7 Updated by Justin Sherrill about 2 years ago

  • Legacy Backlogs Release (now unused) set to 211

#8 Updated by Justin Sherrill about 2 years ago

  • Legacy Backlogs Release (now unused) changed from 211 to 228

#9 Updated by Brad Buckingham about 2 years ago

  • Target version changed from 187 to 193

#10 Updated by John Mitsch about 2 years ago

  • Status changed from Ready For Testing to New
  • Assignee deleted (John Mitsch)
  • Pull request deleted (https://github.com/Katello/katello/pull/6772)

#11 Updated by Justin Sherrill about 2 years ago

  • Legacy Backlogs Release (now unused) changed from 228 to 258

#12 Updated by Brad Buckingham about 2 years ago

  • Target version changed from 193 to 196

#13 Updated by Justin Sherrill about 2 years ago

  • Legacy Backlogs Release (now unused) changed from 258 to 267

#14 Updated by Justin Sherrill about 2 years ago

  • Assignee set to Justin Sherrill
  • Difficulty set to hard

#15 Updated by The Foreman Bot about 2 years ago

  • Status changed from New to Ready For Testing
  • Pull request https://github.com/Katello/katello/pull/6833 added

#16 Updated by Justin Sherrill almost 2 years ago

  • Status changed from Ready For Testing to Closed
  • % Done changed from 0 to 100

#17 Updated by Eric Helms almost 2 years ago

  • Legacy Backlogs Release (now unused) changed from 267 to 281

Also available in: Atom PDF