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

-- 
You received this message because you are subscribed to the Google Groups 
"Foreman users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to foreman-users+unsubscr...@googlegroups.com.
To post to this group, send email to foreman-users@googlegroups.com.
Visit this group at https://groups.google.com/group/foreman-users.
For more options, visit https://groups.google.com/d/optout.

Reply via email to