[RFE] Additional log analysis

[jsenkyri]

There's a lot more we can do other than to just look for errors/failures in logs. A few examples:

• Servers with the most http requests to Satellite:

# awk '{ print $1 }' /var/log/httpd/foreman-ssl_access_ssl.log | sort | uniq -c | sort -nr -k 1 | head -n 10
---
    471 <IP address of host a>
    226 <IP address of host b>
    143 <IP address of host c>
     23 <IP address of host d>
---

• Identify long running postgresql queries:

# grep duration /var/lib/pgsql/data/log/postgresql-Mon.log | awk '{print $1,$2,$3,$4,$5,$6}' | sort -k6 -r
---
2023-10-23 12:29:16 CEST LOG: duration: 2552.686
2023-10-23 12:29:46 CEST LOG: duration: 2546.754
2023-10-23 12:21:32 CEST LOG: duration: 2542.685
---