Bug #26777
add index on taxable_taxonomies table
Status:
Closed
Priority:
Normal
Assignee:
Category:
Organizations and Locations
Target version:
-
Difficulty:
Triaged:
No
Bugzilla link:
Pull request:
Description
foreman=# create index index_taxable_taxonomies_on_taxonomy_id_taxable_type on taxable_taxonomies (taxonomy_id,taxable_type);
CREATE INDEX
Related issues
Associated revisions
History
#1
Updated by The Foreman Bot about 4 years ago
Updated by - Status changed from New to Ready For Testing
- Pull request https://github.com/theforeman/foreman/pull/6749 added
#2
Updated by Anonymous almost 4 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
#3
Updated by Lukas Zapletal almost 4 years ago
Updated by - Status changed from Ready For Testing to Closed
Applied in changeset 19c679cec3b1b6ef130e4fd062bc4aa2f852622e.
#4
Updated by Lukas Zapletal almost 4 years ago
- Related to Bug #26760: Audits page is very slow added
#5
Updated by Tomer Brisker almost 4 years ago
Updated by - 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
Fixes #26777 - added taxonomy_taxable id and type index