Project

General

Profile

Bug #21928

SQL SELECT from Katello_subscription_facets taking too long to execute (10000ms+)

Added by Tomer Brisker almost 3 years ago. Updated over 2 years ago.

Status:
Closed
Priority:
High
Assignee:
Category:
Subscriptions
Target version:
Difficulty:
Triaged:
Bugzilla link:
Fixed in Releases:
Found in Releases:

Description

Cloned from https://bugzilla.redhat.com/show_bug.cgi?id=1516244

Description of problem:
While registering 30k content hosts to Satellite, postgresql recorded a slow query which was running for 10,000ms+
x----snip----x
2017-11-22 05:57:45 EST LOG: duration: 10139.895 ms execute <unnamed>: SELECT "katello_subscription_facets"."id" FROM "katello_subscription_facets" WHERE "katello_subscription_facets"."uuid" IN ('f371fe1b-fd52-48c0-b93d-f98d867bb976', '984665ea-3d2d-456e-89cb-1635856c7255', '679c7128-91da-46f3-a3d6-c6e7924193ee', '64462ee8-9f37-4ffe-8d4b-688c2f9fac44', '09eb500d-8931-419e-b8c9-3d50e7969836', '5af1e513-7057-43a3-abc2-df240878626f', 'f77bf17b-bf97-4ec2-b676-37dc63a1c386', '739b2ee2-0a69-4641-a745-86a64ba1b371', '1810b5df-5698-4773-9779-fa6520d4fa5f', 'f1a01cb7-79b3-43f0-86b0-d93e1a1e1534', '4b1eda84-e379-4184-b0c4-9bd5bb32e3f8', 'a2b3df33-31e8-439f-9b0b-ea433eb1a6b3', '17c47146-a6c4-4b88-87eb-56261bba55a5', 'a945e6fe-1d73-48e0-87cd-da4b23c2cc79', 'cf0191db-0e93-4363-9e91-0469eab302ef', 'db0ed952-1187-4de1-bd7a-dcf8ff34fe5f', '332df744-2235-4ab5-a217-88d3508d8405', 'f4d36987-da71-49ec-a8d1-1bea2b613704', 'fdc3199a-755b-421d-9afc-a9fab1f3b2f1', 'cf019252-97a5-4bd8-bb72-3da229c0e33b', 'ab8aac77-4d6a-41f8-81ec-00a77766af8b', '4583b375-3e1a-4d9d-9372-3309bcbaf28c', '21a43763-209e-4d21-b64b-285d73164731', '8ef6fbe1-a4a2-4d63-9037-a57b24eb7433', 'b8fee33d-3196-4618-8131-a2867a6889b8', 'fe7b25ec-fc1a-49a0-a8f4-91857c2b58ef', '9229b6cc-17cf-4083-bbf0-6effe67b205d', '432cd848-2ae3-46c8-9175-ede1752eca36', 'ac24e334-6708-4e8d-b7e1-fcdb16028a78', 'f6943295-5388-4b59-a92f-cd1c4285c8bd', 'b4de2388-5895-4d67-b08d-0a7029c1d386', '2a4bd031-777a-4f90-8e0a-1093041d5c81', 'e6c80374-fcb4-4925-bff3-834ac3d45848', 'be394f0a-835c-4a50-8b58-92a08cee5238', 'a04c7417-fa00-46e4-93ab-86959d21dc02', '77002089-ac86-4b85-b026-8abb8db7eabb', '3e65d89c-70a0-4241-ae3a-5fff90c68a8c', 'd0abe560-3931-41c4-8868-e0cfd19d7cd9', '68125942-5ab5-4905-93a0-ba0b001d72ae', '2e08f1ef-d6e0-4dad-a9ac-970829970310', '10deff9a-9d69-4c3e-8acd-d7441cc2000e', '222f0720-89f8-4009-9fe7-fe6680e59bb5', 'de9d794a-35c3-40b0-ae59-da9685e7183c', '7342474c-dfc9-4f9a-b53d-23c248af1230', '7d5bf79d-bfe8-4d78-be99-2604135f6acf', '394c5b2c-f8e0-4758-b4f9-e9c6b1ac9536', '79eb69e7-395d-4594-80da-94630adcc64d', '42a56795-473c-4b8c-8e97-242063344fb5', '1073e487-4e20-400e-9bc7-90873988c894', 'c1d6fc86-903e-4443-b66d-ea2e4a66b8b8', 'be130cf2-65d3-4985-992c-ae3afeae8290', '15af85d7-8191-44de-9bd8-ab9d14e7c1b9', '3f0ff9a5-3......
x----snip----x

Associated revisions

Revision d1753454 (diff)
Added by Tomer Brisker almost 3 years ago

Fixes #21928 - add uuid index to katello_subscription_facets

History

#1 Updated by The Foreman Bot almost 3 years ago

  • Assignee set to Tomer Brisker
  • Status changed from New to Ready For Testing
  • Pull request https://github.com/Katello/katello/pull/7108 added

#2 Updated by Anonymous almost 3 years ago

  • % Done changed from 0 to 100
  • Status changed from Ready For Testing to Closed

#3 Updated by Andrew Kofink almost 3 years ago

  • Legacy Backlogs Release (now unused) set to 329
  • Category set to Subscriptions

Also available in: Atom PDF