Description of problem: https://community.theforeman.org/t/slow-products-page-on-2-0/19142/23 has indicated adding this index can lead to significant speed up of products page queries/ Version-Release number of selected component (if applicable): How reproducible: always Steps to Reproduce: 1. Have several products which have been synced 2. Open the products page 3. Actual results: It takes long time to load Expected results: It should load faster Additional info:
The attached fix can reduce the load times quite drastically, see the thread on discourse. That's why I'd like to propose this for 6.8
*** Bug 1846310 has been marked as a duplicate of this bug. ***
*** Bug 1846312 has been marked as a duplicate of this bug. ***
Moving this bug to POST for triage into Satellite 6 since the upstream issue https://projects.theforeman.org/issues/30103 has been resolved.
Verified on Satellite 6.8 snap 9 using the export analyze query from the associated foreman.community discussion, the index_tasks_locks_on_task_id_resource_type_and_resource_id has been added and is applied
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 (Important: Satellite 6.8 release), 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-2020:4366