Project

General

Profile

Bug #26777

add index on taxable_taxonomies table

Added by Lukas Zapletal 7 months ago. Updated 4 months ago.

Status:
Closed
Priority:
Normal
Category:
Organizations and Locations
Target version:
-
Difficulty:
Triaged:
No
Bugzilla link:
Fixed in Releases:
Found in Releases:

Description

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


Related issues

Related to Foreman - Bug #26760: Satelllite Audits page is very slowClosed

Associated revisions

Revision 19c679ce (diff)
Added by Lukas Zapletal 6 months ago

Fixes #26777 - added taxonomy_taxable id and type index

History

#1 Updated by The Foreman Bot 7 months ago

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

#2 Updated by Michael Moll 6 months 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

#3 Updated by Lukas Zapletal 6 months ago

  • Status changed from Ready For Testing to Closed

#4 Updated by Lukas Zapletal 6 months ago

  • Related to Bug #26760: Satelllite Audits page is very slow added

#5 Updated by Tomer Brisker 4 months ago

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

Also available in: Atom PDF