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?
Luca
--
"E' assurdo impiegare gli uomini di intelligenza eccellente per fare
calcoli che potrebbero essere affidati a chiunque se si usassero delle
macchine"
Gottfried Wilhelm von Leibnitz, Filosofo e Matematico (1646-1716)
"Internet è la più grande biblioteca del mondo.
Ma il problema è che i libri sono tutti sparsi sul pavimento"
John Allen Paulos, Matematico (1945-vivente)
Luca 'remix_tj' Lorenzetto, http://www.remixtj.net , <[email protected]>
--
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.
