Created attachment 1554505 [details] production.log Description of problem: When filling a google-style filter while generating the Registered Hosts report, the filtering is done very inefficiently. On my instance (with RHEL channel synced and only two hosts registered), filtering took ~20 minutes. Version-Release number of selected component (if applicable): Reproduced on Sat 6.5 snap 23 How reproducible: Steps to Reproduce: 1. Have a Satellite with RHEL channel synced and some hosts 2. Monitoring -> Reporting Templates -> generate Registered Hosts 3. Fill filter in form "<system_name>" matching some of the systems, submit Actual results: Generating takes absurdly long - 20 minutes for 2 systems! Expected results: Generating should take reasonable time Additional info: production.log attached
Verified with Sat 6.5 snap 24. With the same configuration, generating with google-style filter was virtually immediate and the results were correct.
Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory, and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://access.redhat.com/errata/RHSA-2019:1222