Project

General

Profile

Actions

Bug #26777

closed

add index on taxable_taxonomies table

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

Status:
Closed
Priority:
Normal
Category:
Organizations and Locations
Target version:
-
Difficulty:
Triaged:
No
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 1 (0 open1 closed)

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

Updated by The Foreman Bot almost 5 years ago

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

Updated by Anonymous almost 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 #3

Updated by Lukas Zapletal almost 5 years ago

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

Updated by Lukas Zapletal almost 5 years ago

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

Updated by Tomer Brisker over 4 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

Also available in: Atom PDF