Project

General

Custom queries

Profile

Actions
Copy link

Bug #26777

closed

add index on taxable_taxonomies table

Added by Lukas Zapletal almost 6 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Lukas Zapletal
Category:
Organizations and Locations
Target version:
-
Difficulty:
Triaged:
No
Bugzilla link:
1708422
Pull request:
https://github.com/theforeman/foreman/pull/6749
Fixed in Releases:
1.23.0
Found in Releases:
Red Hat JIRA:

Description

foreman=# create index index_taxable_taxonomies_on_taxonomy_id_taxable_type on taxable_taxonomies (taxonomy_id,taxable_type);
CREATE INDEX

Related issues 1 (0 open — 1 closed)

Related to Foreman - Bug #26760: Audits page is very slowClosedTomer BriskerActions
Actions
Copy link
 #1

Updated by The Foreman Bot almost 6 years ago

  • Status changed from New to Ready For Testing
  • Pull request https://github.com/theforeman/foreman/pull/6749 added
Actions
Copy link
 #2

Updated by Anonymous over 5 years ago

  • Subject changed from Queries on taxable_taxonomies table running very slow. This fixes it: to Queries on taxable_taxonomies table running very slow. This fixes it:
  • Fixed in Releases 1.23.0 added
Actions
Copy link
 #3

Updated by Lukas Zapletal over 5 years ago

  • Status changed from Ready For Testing to Closed
Actions
Copy link
 #4

Updated by Lukas Zapletal over 5 years ago

  • Related to Bug #26760: Audits page is very slow added
Actions
Copy link
 #5

Updated by Tomer Brisker over 5 years ago

  • Subject changed from Queries on taxable_taxonomies table running very slow. This fixes it: to add index on taxable_taxonomies table
  • Category changed from Smart Proxy to Organizations and Locations
Actions
Copy link

Also available in: Atom PDF