Bug 1846310 - Add index on locks for resource type and task id
Summary: Add index on locks for resource type and task id
Keywords:
Status: CLOSED DUPLICATE of bug 1846313
Alias: None
Product: Red Hat Satellite
Classification: Red Hat
Component: Tasks Plugin
Version: 6.2.0
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: Unspecified
Assignee: Tomer Brisker
QA Contact: Peter Ondrejka
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2020-06-11 11:02 UTC by Adam Ruzicka
Modified: 2020-06-11 13:22 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2020-06-11 13:22:10 UTC
Target Upstream Version:
Embargoed:

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Foreman Issue Tracker 30103 0 Normal Ready For Testing Add index on locks for resource type and task id 2020-06-11 11:02:50 UTC

Description Adam Ruzicka 2020-06-11 11:02:48 UTC 
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/
Comment 1 Adam Ruzicka 2020-06-11 11:02:53 UTC 
Created from redmine issue http://projects.theforeman.org/issues/30103
Comment 2 Bryan Kearney 2020-06-11 12:02:22 UTC 
Upstream bug assigned to tbrisker
Comment 3 Bryan Kearney 2020-06-11 12:02:24 UTC 
Upstream bug assigned to tbrisker
Comment 4 Tomer Brisker 2020-06-11 13:22:10 UTC 

*** This bug has been marked as a duplicate of bug 1846313 ***
Note You need to log in before you can comment on or make changes to this bug.