Description of problem:
The freeform search can be slow since it includes installed packages and applicable errata by default.
Version-Release number of selected component (if applicable): 6.2
Steps to Reproduce:
1. set up a number of hosts that are reporting their installed packages (> 100 hosts at least)
2. use the freeform search box to search for a string
Actual results:
search can take an excessively long time, many seconds
Expected results: search should be reasonably fast
Additional info:
If you see a query like this in the postgres log, it's likely this bug:
2016-09-27 13:34:23 EDT LOG: duration: 103464.745 ms execute <unnamed>: SELECT DISTINCT "hosts"."id", "hosts"."name" AS alias_0 FROM "hosts" LEFT OUTER JOIN "models" ON "models"."id" = "hosts"."model_id" LEFT OUTER JOIN....
the query is extremely long, but will contain references to 'katello_installed_packages'
Verified in Satellite 6.2.4.
System had 220 content hosts, each with approximately 150 installable errata. Search time did not lag behind, after all errata applicability had been completed (general performance hit during mass registration). Each search was completed well under a second. I will upload a verification video, however the capture didn't turn out well.
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/RHBA-2016:2699