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: