Project

General

Profile

Actions

Bug #25624

closed

Registered hosts' report performs poorly

Added by Marek Hulán almost 6 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Reporting
Target version:
-
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

Actions #1

Updated by Marek Hulán almost 6 years ago

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

Updated by The Foreman Bot almost 6 years ago

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

Updated by The Foreman Bot almost 6 years ago

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

Updated by Tomer Brisker almost 6 years ago

  • Fixed in Releases 1.21.0 added
Actions #5

Updated by Marek Hulán almost 6 years ago

  • Status changed from Ready For Testing to Closed
Actions

Also available in: Atom PDF