welcome screens query is not optimized
When starting foreman for the first time, foreman tries to show some help messages.
which simply count the amount of entires (i.e. hosts, reports, facts).
When the tables are large, this takes a lot of time, as it does not uses a index (see https://groups.google.com/group/foreman-users/browse_thread/thread/2729d0b6583037eb?hl=en).