On Tue, Sep 20, 2016 at 3:16 AM, sinux shen <[email protected]> wrote:
> I just simply search a specific hostname in the search bar, for example > “foo”, and then have to wait for a long time, normally 20~30 secs, I will > try to turn the slow query on and see what happened. > You should not use queries like foo unless you want to search across all host associations, you should use the auto completer to use a more specific term, e.g. name ~ foo when not defining the field to search on, we have to query across multiple tables, which makes quite a few sql queries which are probably are not required if you define a more specific search term. Ohad > > Thanks > -Sinux > > On Sep 14, 2016, at 3:59 PM, Lukas Zapletal <[email protected]> wrote: > > > >> what was the search query that you used? > > > > And do you experience this when loading "intelligent completion" or when > > doing actual query? > > > > Are you able to enable slow queries logging in your postgres and send us > > the output? > > > > https://wiki.postgresql.org/wiki/Logging_Difficult_Queries > > > > Easiest is to set log_min_duration_statement to reasonable value (1 > > second). > > > > -- > > Later, > > Lukas #lzap Zapletal > > > > -- > > 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. > > -- > 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. > -- 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.
