Hi,
we have a huge performance problem on the puppet class view. It takes
abount 30 seconds to open the page.
2016-10-13 08:21:47 4d13dccb [app] [I] Started GET "/puppetclasses" for
172.29.70.9 at 2016-10-13 08:21:47 +0200
2016-10-13 08:21:47 4d13dccb [app] [I] Processing by
PuppetclassesController#index as HTML
2016-10-13 08:21:47 4d13dccb [app] [D] Cache read:
_session_id:4d13dccb22fd168676dfa37aa39b7057
2016-10-13 08:21:47 4d13dccb [app] [D] Setting current user thread-local
variable to mtnu
2016-10-13 08:21:47 4d13dccb [app] [D] Cache read:
authorize_login_delegation
2016-10-13 08:21:47 4d13dccb [app] [D] Cache read:
authorize_login_delegation
2016-10-13 08:21:47 4d13dccb [app] [D] Cache read: idle_timeout
2016-10-13 08:21:47 4d13dccb [app] [D] Setting current organization
thread-local variable to zed
2016-10-13 08:21:47 4d13dccb [app] [D] Cache read: entries_per_page
2016-10-13 08:22:16 4d13dccb [app] [I] Rendered
puppetclasses/index.html.erb within layouts/application (909.7ms)
2016-10-13 08:22:16 4d13dccb [app] [I] Rendered
common/_searchbar.html.erb (5.5ms)
2016-10-13 08:22:16 4d13dccb [app] [I] Rendered
layouts/_application_content.html.erb (6.0ms)
2016-10-13 08:22:16 4d13dccb [app] [D] Cache read: use_gravatar
2016-10-13 08:22:16 4d13dccb [app] [I] Rendered
home/_user_dropdown.html.erb (2.8ms)
2016-10-13 08:22:16 4d13dccb [app] [D] Cache read:
views/tabs_and_title_records-8 ({:skip_digest=>true})
2016-10-13 08:22:16 4d13dccb [app] [I] Read fragment
views/tabs_and_title_records-8 (0.3ms)
2016-10-13 08:22:16 4d13dccb [app] [I] Rendered home/_topbar.html.erb
(7.1ms)
2016-10-13 08:22:16 4d13dccb [app] [I] Rendered layouts/base.html.erb
(8.9ms)
2016-10-13 08:22:16 4d13dccb [app] [I] Completed 200 OK in 28831ms (Views:
901.8ms | ActiveRecord: 4243.4ms)
2016-10-13 08:22:16 4d13dccb [app] [D] Cache write:
_session_id:4d13dccb22fd168676dfa37aa39b7057 ({:expires_in=>86400})
We have 289 Puppetclasses importet in foreman. We are using the
organization feature, so users can only manage the puppetclasses that they
have importet on the smart proxy which belongs to their organization. This
is filtered via user groups and permissions. The permission for viewing the
classes is "environment ~ $org_name". (The environments of the
organizations beginns with the name of the organization.)
If we search for a puppetclass that only one organization use, the search
takes only about 10 secounds. But if we search for a class almost all
organizations use, the search takes several minutes and the foreman
processes eats almost all ram on the server.
The log above shows that Views and DB are quick, but the complete request
takes 28831ms.
Is there a way we can debug this? We are using Foreman 1.13.0
Thanks for your help!
Martin