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