Project

General

Profile

Actions
Copy link

Bug #18843

closed

Change eager_load to includes statement in hosts api controller's index action

Added by Shimon Shtein about 7 years ago. Updated almost 6 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Shimon Shtein
Category:
Database
Target version:
1.14.3
Difficulty:
Triaged:
Bugzilla link:
Pull request:
https://github.com/theforeman/foreman/pull/4365
Fixed in Releases:
Found in Releases:
Red Hat JIRA:

Description

Since the query is pretty wide (contains multiple joins) the execution plan will try to make all joins and only then try to filter unnecessary rows. This causes PG to load a huge temporary table into memory, and since it's too big to fit in, the CPU sky rockets.

Actions
Copy link
 #1

Updated by Dominic Cleal about 7 years ago

  • Category set to Database
Actions
Copy link
 #2

Updated by The Foreman Bot about 7 years ago

  • Status changed from New to Ready For Testing
  • Assignee set to Shimon Shtein
  • Pull request https://github.com/theforeman/foreman/pull/4365 added
Actions
Copy link
 #3

Updated by Ivan Necas about 7 years ago

  • Target version set to 1.12.2
Actions
Copy link
 #4

Updated by Shimon Shtein about 7 years ago

  • Status changed from Ready For Testing to Closed
  • % Done changed from 0 to 100
Actions
Copy link
 #5

Updated by Dominic Cleal about 7 years ago

  • translation missing: en.field_release set to 227
Actions
Copy link

Also available in: Atom PDF