Plugins » Katello

These rpm and errata counts have been optimized quite a bit, i think the only thing left is to cache these values on the content_facet table.

Daniel Kimsey wrote:

I noticed this when l try to pull up the content hosts view or when I was using the foreman plugin for ansible.

In short, the /api/v2/hosts call takes a very long time. With jsherril's help I've extracted some debug logs (attached). It looks like most of the SQL time is spent in lookups to rpms and errata with some more in reports.

Did you follow the partitioning recommendations for host?
https://access.redhat.com/documentation/en-us/red_hat_satellite/6.2/html/installation_guide/preparing_your_environment_for_installation#hardware_storage_prerequisites

This did the boost for me.

Sorry for the delay, I wanted to go look on the host. But yes, we did follow the sizing guidelines. We are making some tweaks based on the Appendix A section regarding large deployments though I feel that will just affect our host's registration performance and the like.