The Content Hosts page is loading very slowly on Satellite 6
Cloned from https://bugzilla.redhat.com/show_bug.cgi?id=1191711
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):
Steps to Reproduce:
Try to visit Hosts-->Content Hosts page with some more number of systems(>50).
The Content Hosts page loads very slowly.
It should be faster when having system with good configuration.
Could not see any informative messages in /var/log/foreman/production.log when foreman logging increased.
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