Re: Multi-second pauses blocking even trivial activity

Hi Jeff,

Thanks for your reply. Are locks relevant in this case, though?

To be clear, the slow statements are the first thing happening on the
connection and don't look like they should be acquiring any kind of lock -
eg. 'select version();' also seems to be paused when it occurs.

Or are there some system level locks that a trivial query, touching no
relations, might be contending for?

Best
Patrick

On Fri, 7 Sep 2018, 15:32 Jeff Janes, <jeff(dot)janes(at)gmail(dot)com> wrote:

> On Fri, Sep 7, 2018 at 8:00 AM Patrick Molgaard <draaglom(at)gmail(dot)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
>