On 09/02/2016 08:48 AM, Luca 'remix_tj' Lorenzetto wrote: > On Fri, Sep 2, 2016 at 2:32 PM, Chris Duryee <[email protected]> wrote: > [cut] >> Can you enable slow sql logging? >> > > Yes, done. > >> 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 >> > > > LOG: duration: 188745.456 ms execute <unnamed>: SELECT DISTINCT > "katello_errata".* FROM "katello_errata" INNER JOIN > "katello_content_facet_errata" ON > "katello_content_facet_errata"."erratum_id" = "katello_errata"."id" > INNER JOIN "katello_content_facet_errata" > "content_facet_errata_katello_errata_join" ON > "content_facet_errata_katello_errata_join"."erratum_id" = > "katello_errata"."id" INNER JOIN "katello_content_facets" ON > "katello_content_facets"."id" = > "content_facet_errata_katello_errata_join"."content_facet_id" WHERE > "katello_content_facets"."host_id" IN (SELECT "hosts"."id" FROM > "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND > "hosts"."organization_id" IN (3)) ORDER BY updated desc LIMIT 6 > > > > >> The issue you hit might be fixed in Katello 3.1, but if we get the SQL >> then we can know for sure. > > Can you tell if it's so?
ya, it should be fixed by http://projects.theforeman.org/issues/15389 which is marked for 3.1.0. > > Luca > -- 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.
