Red Hat Bugzilla – Bug 1380486
free form search is very slow, not excluding installed packages and applicable errata
Last modified: 2017-05-10 04:35:53 EDT
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'
Upstream bug assigned to jsherril@redhat.com
Upstream bug component is Other
Moving this bug to POST for triage into Satellite 6 since the upstream issue http://projects.theforeman.org/issues/16647 has been resolved.
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.
Created attachment 1217836 [details] verification video
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