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
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