Bug 1846310

Summary:	Add index on locks for resource type and task id
Product:	Red Hat Satellite	Reporter:	Adam Ruzicka <aruzicka>
Component:	Tasks Plugin	Assignee:	Tomer Brisker <tbrisker>
Status:	CLOSED DUPLICATE	QA Contact:	Peter Ondrejka <pondrejk>
Severity:	unspecified	Docs Contact:
Priority:	unspecified
Version:	6.2.0	CC:	aruzicka
Target Milestone:	Unspecified
Target Release:	Unused
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2020-06-11 13:22:10 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

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 ***