Project

General

Profile

Bug #25624

Registered hosts' report performs poorly

Added by Marek Hulán 8 months ago. Updated 6 months ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Reporting
Target version:
-
Team Backlog:
Fixed in Releases:
Found in Releases:

Description

Cloned from https://bugzilla.redhat.com/show_bug.cgi?id=1655628

Description of problem:
Performance testing shows that there's most likely something done inefficiently in the Registered hosts report. I've tested on a Satellite with 10 000 systems.

When running a report without filters, it takes 8 minutes (there are no performance requirements specified so this should be fine). However, when running with a host filter such that it limits hosts to only 500 of these 10 000, the report generation consistently fails with ISE after 30 minutes.

Tested on a RHEL7 machine with Intel Xeon, 4 sockets, 32 cores, hyperthreading, 2.7 Ghz, 128 GB RAM

Version-Release number of selected component (if applicable):
6.5 snap 5

How reproducible:
Deterministic on one machine but may be influenced by the machine's performance.

Steps to Reproduce:
1. Have a Satellite with 10 000 systems, 500 of them with some easily filterable name
2. Monitor -> Report Templates -> Registered Hosts -> Generate
3. Fill in a filter such that it selects 500 systems
4. Submit

Actual results:
ISE after 30 minutes

Expected results:
Report generated. I'd expect it to be faster than without the filter

Associated revisions

Revision 8a76900b (diff)
Added by Marek Hulán 7 months ago

Fixes #25624 - add explicit kernel release fact loader

The problem with registered hosts report is that for each host we load
all host facts just in order to display kernelrelease fact value. We
can define explicit association for this fact so we can `:include` it.
To use it in templates a new macro `host_kernel_release` is introduced.

Revision 697b949f (diff)
Added by Marek Hulán 6 months ago

Refs #25624 - improve performance for registered hosts

History

#1 Updated by Marek Hulán 8 months ago

  • Assignee set to Marek Hulán
  • Category changed from Statistics to Reporting
  • Subject changed from Registered hosts' report performs poorly to Registered hosts' report performs poorly

#2 Updated by The Foreman Bot 8 months ago

  • Status changed from New to Ready For Testing
  • Pull request https://github.com/theforeman/community-templates/pull/542 added

#3 Updated by The Foreman Bot 8 months ago

  • Pull request https://github.com/theforeman/foreman/pull/6305 added

#4 Updated by Tomer Brisker 7 months ago

  • Fixed in Releases 1.21.0 added

#5 Updated by Marek Hulán 7 months ago

  • Status changed from Ready For Testing to Closed

Also available in: Atom PDF