Red Hat Satellite engineering is moving the tracking of its product development work on Satellite to Red Hat Jira (issues.redhat.com). If you're a Red Hat customer, please continue to file support cases via the Red Hat customer portal. If you're not, please head to the "Satellite project" in Red Hat Jira and file new tickets here. Individual Bugzilla bugs will be migrated starting at the end of May. If you cannot log in to RH Jira, please consult article #7032570. That failing, please send an e-mail to the RH Jira admins at rh-issues@redhat.com to troubleshoot your issue as a user management inquiry. The email creates a ServiceNow ticket with Red Hat. Individual Bugzilla bugs that are migrated will be moved to status "CLOSED", resolution "MIGRATED", and set with "MigratedToJIRA" in "Keywords". The link to the successor Jira issue will be found under "Links", have a little "two-footprint" icon next to it, and direct you to the "Satellite project" in Red Hat Jira (issue links are of type "https://issues.redhat.com/browse/SAT-XXXX", where "X" is a digit). This same link will be available in a blue banner at the top of the page informing you that that bug has been migrated.

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

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