On 09/02/2016 05:11 AM, Luca Lorenzetto wrote: > Hello, > > i just did a new setup of katello 3.0.2. After setting up everything i > started registering hosts (both for contents and configuration management). > At the moment ~300 servers are registered. Now logging into katello is very > slow (requires about 30s) due to dashboard. > While waiting the dashboard to appear i see that there is a postgresql > SELECT process that is using 100% of CPU for several time. > However accessing directly to /hosts is very fast and so as far as i can > experiment is related only to dashboard tasks. > > What can i do? Some parts of dashboard can be useful, but not if is this > slow. > > Luca >
Can you enable slow sql logging? It is set in /var/lib/pgsql/data/postgresql.conf, setting log_min_duration_statement to 100 or 250 should do the trick. Once it is set, you will need to do a "service postgresql reload" to pick up the change, then try to load the dashboard again. The log should be in /var/lib/pgsql/data/pg_log/postgresql-<day of week>.log The issue you hit might be fixed in Katello 3.1, but if we get the SQL then we can know for sure. Thanks! -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/foreman-users. For more options, visit https://groups.google.com/d/optout.
