Bug #10152

The Content Hosts page is loading very slowly on Satellite 6

Added by dustin tsang about 7 years ago. Updated almost 4 years ago.

Web UI
Target version:
Bugzilla link:
Fixed in Releases:
Found in Releases:
Red Hat JIRA:


Cloned from
Description of problem:

The Content Hosts page is very slow to load when having 70 ESX hosts registered on Satellite and 1 virtual system. It takes about 2~3 minutes to load list of systems. The Satellite system is bare metal system with Intel Xeon(R) CPU and 46 GB of RAM.

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

Satellite 6.0.6

How reproducible:

Every time.

Steps to Reproduce:

Try to visit Hosts-->Content Hosts page with some more number of systems(>50).

Actual results:

The Content Hosts page loads very slowly.

Expected results:

It should be faster when having system with good configuration.

Additional info:

Could not see any informative messages in /var/log/foreman/production.log when foreman logging increased.

Associated revisions

Revision 20fecb64 (diff)
Added by dustin tsang about 7 years ago

Fixes #10152 - reduce num querys in sys#index

  • system's rabl index does not use the show template
  • include :content_view, :activation_keys in elastic query for N+1

Revision bf2c0d35
Added by dustin tsang about 7 years ago

Merge pull request #5180 from dustints/redmine10152

Fixes #10152 - reduce num queries in sys#index


#1 Updated by The Foreman Bot about 7 years ago

  • Status changed from New to Ready For Testing
  • Pull request added
  • Pull request deleted ()

#2 Updated by Eric Helms about 7 years ago

  • Legacy Backlogs Release (now unused) set to 51
  • Triaged changed from No to Yes

#3 Updated by Mike McCune about 7 years ago

  • Assignee changed from Partha Aji to dustin tsang

#4 Updated by dustin tsang about 7 years ago

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

Also available in: Atom PDF