Project

General

Profile

Actions

Bug #18843

closed

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

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

Status:
Closed
Priority:
Normal
Assignee:
Category:
Database
Target version:
Difficulty:
Triaged:
Fixed in Releases:
Found in Releases:

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 #1

Updated by Dominic Cleal over 7 years ago

  • Category set to Database
Actions #2

Updated by The Foreman Bot over 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 #3

Updated by Ivan Necas over 7 years ago

  • Target version set to 1.12.2
Actions #4

Updated by Shimon Shtein over 7 years ago

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

Updated by Dominic Cleal over 7 years ago

  • Translation missing: en.field_release set to 227
Actions

Also available in: Atom PDF