Hi @ochnerd ,
Have you gone through our tuning guide? There are quite a few “knobs” that you can turn to help Foreman be more performant depending on your situation. It’s a place to start at least if you haven’t seen it yet.
When you mention having usergroups and roles, it reminds me of this solved issue that I saw somewhat recently: Bug: Orgs and Locs + Job Templates are broken in 3.18 (probably 3.17 as well) - #17 by singularity001
There is a patch in there that could be worth trying depending if the situation is at all similar to yours. The user was reporting that Postgres was doing too much work for some particular endpoints, so it might be helpful if you can narrow down what is taking too long. Is it Postgres? Is it the web server processing things? Or something else? The timing information in the production logs along with postgres logs are your friend here.