Bug #8593: N+1 query on Puppet class index, looking up class_params - Foreman

Actions

Copy link

Bug #8593

closed

N+1 query on Puppet class index, looking up class_params

Added by Dominic Cleal about 10 years ago. Updated over 6 years ago.

Status:

Closed

Priority:

Normal

Assignee:

Tomer Brisker

Category:

Database

Target version:

1.8.1

Difficulty:

Triaged:

Bugzilla link:

Pull request:

https://github.com/theforeman/foreman/pull/2280

Fixed in Releases:

Found in Releases:

Red Hat JIRA:

Description

http://0.0.0.0:3000/puppetclasses
N+1 Query detected
  Puppetclass => [:class_params]
  Add to your finder: :include => [:class_params]
N+1 Query method call stack
  /home/dcleal/code/foreman/foreman/app/views/puppetclasses/index.html.erb:30:in `block in _app_views_puppetclasses_index_html_erb__247937742040578848_83062380'
  /home/dcleal/code/foreman/foreman/app/views/puppetclasses/index.html.erb:15:in `_app_views_puppetclasses_index_html_erb__247937742040578848_83062380'
  /home/dcleal/code/foreman/foreman/app/models/concerns/foreman/thread_session.rb:33:in `clear_thread'
  /home/dcleal/code/foreman/foreman/lib/middleware/catch_json_parse_errors.rb:9:in `call'

This seems to be coming from the check for whether to display the "Override all parameters" action button, which checks for overridden lookup keys.

Actions

Copy link

Updated by Dominic Cleal about 10 years ago

Intermittently I also see:

user: dcleal
http://0.0.0.0:3000/puppetclasses
N+1 Query detected
  Puppetclass => [:config_group_classes]
  Add to your finder: :include => [:config_group_classes]
N+1 Query method call stack
  /home/dcleal/code/foreman/foreman/app/models/puppetclass.rb:89:in `host_ids_from_config_groups'
  /home/dcleal/code/foreman/foreman/app/models/puppetclass.rb:95:in `all_hostgroups'
  /home/dcleal/code/foreman/foreman/app/views/puppetclasses/index.html.erb:23:in `block in _app_views_puppetclasses_index_html_erb__247937742040578848_70301942862740'
  /home/dcleal/code/foreman/foreman/app/views/puppetclasses/index.html.erb:15:in `_app_views_puppetclasses_index_html_erb__247937742040578848_70301942862740'
  /home/dcleal/code/foreman/foreman/app/models/concerns/foreman/thread_session.rb:33:in `clear_thread'
  /home/dcleal/code/foreman/foreman/lib/middleware/catch_json_parse_errors.rb:9:in `call'

Actions

Copy link