Just upgraded Foreman instance to 1.11.2 in our main environment (~7000 hosts), and have found loading the dashboard takes an excessive amount of time ~ 1 minute. Upgrade which took place was from version 1.10.2, where this issue did not occur at all. Also worth mentioning we're running other Foreman instances with ~700-1000 hosts on 1.11.2 where we're not getting this issue.

See the pastebin below for logs of selecting the dashboard. Note that the SELECT "hosts" begin from when the call is made even though this isn't how it appears in the logs?

https://pastebin.mozilla.org/8875665

Seems like the problem is very generic and is found here;

Rendered dashboard/index.html.erb within layouts/application (56472.1ms)

Also note that on an 8CPU machine average load is ~ 1, and RAM is fine. Only started having issues when I upgraded this morning.

Have raised this as Support initially as i'm not seeing this in other environments, but am quite confused about it as essentially this is a very vanilla instance of Foreman.

Any help would be appreciated, Cheers.