Audits page is very slow
Description of problem:
Satelllite Audits page is very slow
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1.Navigate to Satellite UI -> Monitor -> Audits page.
It took 37 seconds to load this page. (production.log postgresql.log attached)
2019-04-26T10:57:42 [I|app|97741] Completed 200 OK in 37373ms (Views: 265.2ms | ActiveRecord: 15229.5ms)
- time curl
k -u admin https://satellite.example.com/api/audits > audit:--:-- 0:00:17 --:--:-- 3534
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 -
- head audit
- 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.
Audit page should load faster