Project

General

Custom queries

Profile

Actions
Copy link

Bug #16238

closed

dashboard widget for latests events can be exteramlly slow

Added by Ohad Levy over 8 years ago. Updated almost 7 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Ohad Levy
Category:
Performance
Target version:
1.12.3
Difficulty:
Triaged:
Bugzilla link:
Pull request:
https://github.com/theforeman/foreman/pull/3764
Fixed in Releases:
Found in Releases:
Red Hat JIRA:

Description

when having many hosts, the latest event widget can take around a minute to load.

the line in question is most likely the issue:

 def latest_events
    # 9 reports + header fits the events box nicely...
    @latest_events ||= ConfigReport.authorized(:view_config_reports).my_reports.interesting.where(:host_id => hosts.pluck(:id)).search_for('reported > "7 days ago"').limit(9).includes(:host)
 end

Related issues 4 (0 open — 4 closed)

Related to Foreman - Bug #16044: Errors in individual dashboard widgets fail entire pageClosedTomer Brisker08/10/2016Actions
Related to Foreman - Bug #16627: Puppet general tab new error on 1.12.3ClosedTomer Brisker09/20/2016Actions
Related to Foreman - Bug #16704: Searching fails on dashboardClosedTomer Brisker09/27/2016Actions
Related to Foreman - Bug #18893: dashboard widget for puppet report latest events can be very slow on large amount of reportsClosedTomer Brisker03/14/2017Actions
#2

Updated by Ohad Levy over 8 years ago

  • Related to Bug #16044: Errors in individual dashboard widgets fail entire page added
#3

Updated by The Foreman Bot over 8 years ago

  • Status changed from New to Ready For Testing
  • Assignee set to Ohad Levy
  • Pull request https://github.com/theforeman/foreman/pull/3764 added
#4

Updated by Ohad Levy over 8 years ago

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

Updated by Dominic Cleal over 8 years ago

  • Translation missing: en.field_release set to 181
#6

Updated by Dominic Cleal over 8 years ago

  • Related to Bug #16627: Puppet general tab new error on 1.12.3 added
#7

Updated by Dominic Cleal over 8 years ago

  • Related to Bug #16704: Searching fails on dashboard added
#9

Updated by Ohad Levy about 8 years ago

  • Related to Bug #18893: dashboard widget for puppet report latest events can be very slow on large amount of reports added
Actions
Copy link

Also available in: Atom PDF