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

Description of problem:

Even if it is 300 hosts or 200 hosts, We can generate reports from Template like "Host - Registered Content Hosts" or "Host - Statuses" in a couple of minutes but if a custom template will be created that only parses five to ten host facts, then generation of the result for that report template could take 30minutes to 1 hour against the same set of hosts.

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

Satellite 6.11.4

How reproducible:

In the Customer's environment for 2000+ hosts with a good amount of sub-man & ansible facts in each

Steps to Reproduce:

NA ( Please check the reproducer details in the private comment )

Actual results:

Host - Statuses > Has the least amount of data to be collected -> Took 30 seconds

Host - Registered Content Hosts > Has more data to collect for each system including applicable errata names and subscriptions -> Took 3 minutes and then gave the results.

SSS_Access_Control > Has only 8 ansible facts to collect from each host -> Took 28 minutes

Expected results:

The "SSS_Access_Control" report template or any other "Host Facts" related templates, should not take that huge amount of time to get the resulting CSV data. It should be completed withing 1 - 5 minutes only ( if host count is 200 - 2000 ) .

Additional info:

NA