Project

General

Profile

Bug #26760

Audits page is very slow

Added by Kavita Gaikwad 9 months ago. Updated about 2 months ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Audit Log
Target version:
Difficulty:
Triaged:
No
Bugzilla link:
Fixed in Releases:
Found in Releases:

Description

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

Description of problem:
Satelllite Audits page is very slow

Version-Release number of selected component (if applicable):
Satellite 6.4.2

How reproducible:
Always

Steps to Reproduce:
1.Navigate to Satellite UI -> Monitor -> Audits page.

Actual results:
It took 37 seconds to load this page. (production.log postgresql.log attached)
/var/log/foreman/production.log:
2019-04-26T10:57:42 [I|app|97741] Completed 200 OK in 37373ms (Views: 265.2ms | ActiveRecord: 15229.5ms)

  1. time curl k -u admin https://satellite.example.com/api/audits > audit
    Enter host password for user 'admin':
    % Total % Received % Xferd Average Speed Time Time Time Current
    Dload Upload Total Spent Left Speed
    100 13950 0 13950 0 0 817 0 -
    :--:-- 0:00:17 --:--:-- 3534

real 0m19.485s
user 0m0.047s
sys 0m0.066s

  1. head audit {
    "total": 5136427,
    "subtotal": 5136427,
    "page": 1,
    "per_page": 30,
    "search": null,
    "sort": {
    "by": null,
    "order": null
    },

Note:
- The response time increases with the number of audit entries. In the above example, I had 5.1 mill entries.
- The response time also increases in a production satellite with live traffic, the satellite I used had zero client production traffic.

Expected results:
Audit page should load faster

Additional info:


Subtasks

Refactor #27588: refactor audit extensions to rely less on taxonomixClosedTomer Brisker

Related issues

Related to Foreman - Bug #26777: add index on taxable_taxonomies tableClosed
Related to OpenSCAP - Bug #27332: List all hosts page in an organization takes long time when there is a lot of reportsClosed

Associated revisions

Revision 9a16e811 (diff)
Added by Tomer Brisker 5 months ago

Fixes #26760 - Improve lookup of partially taxed audits

History

#1 Updated by The Foreman Bot 7 months ago

  • Assignee set to Ondřej Pražák
  • Status changed from New to Ready For Testing
  • Pull request https://github.com/theforeman/foreman/pull/6856 added

#2 Updated by Lukas Zapletal 7 months ago

  • Related to Bug #26777: add index on taxable_taxonomies table added

#3 Updated by Ondřej Pražák 6 months ago

  • Related to Bug #27332: List all hosts page in an organization takes long time when there is a lot of reports added

#4 Updated by Tomer Brisker 5 months ago

  • Target version set to 1.24.0

#5 Updated by The Foreman Bot 5 months ago

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

#6 Updated by The Foreman Bot 5 months ago

  • Fixed in Releases 1.24.0 added

#7 Updated by Tomer Brisker 5 months ago

  • Status changed from Ready For Testing to Closed

#8 Updated by Tomer Brisker about 2 months ago

  • Subject changed from Satelllite Audits page is very slow to Audits page is very slow

#9 Updated by Tomer Brisker about 2 months ago

  • Assignee changed from Ondřej Pražák to Tomer Brisker
  • Pull request deleted (https://github.com/theforeman/foreman/pull/6856)

Also available in: Atom PDF