Steps to reproduce:
- Upgraded from 5.0.x to 6.0.7
- Create user with role user
- Go to Monitoring -> Hosts
The Hosts page takes a long time to load (~30s). The debug shows this is caused by one SQL query, that fetches the number of graphs for each of the hosts (the Graphs column)
This is not an issue for super user accounts.
The load time for the query should be shorter