On Fri, Sep 7, 2018 at 8:00 AM Patrick Molgaard <draag...@gmail.com> wrote:
> Hi folks, > > I've been seeing some curious behaviour on a postgres server I administer. > > Intermittently (one or two times a week), all queries on that host are > simultaneously blocked for extended periods (10s of seconds). > > The blocked queries are trivial & not related to locking - I'm seeing > slowlogs of the form: > > `LOG: duration: 22627.299 ms statement: SET client_encoding='''utf-8''';` > > Do you have log_lock_waits set to on? If not, you might want to turn it on. Cheers, Jeff