2017-11-08 0:45 GMT+01:00 Tom Lane <tgl@xxxxxxxxxxxxx>:
=?UTF-8?Q?Ulf_Lohbr=C3=BCgge?= <ulf.lohbruegge@xxxxxxxxx> writes:
> I just ran "check_postgres.pl --action="" and got the following output:
> ...
> Looks fine, doesn't it?
A possible explanation is that something is taking an exclusive lock
on some system catalog and holding it for a second or two. If so,
turning on log_lock_waits might provide some useful info.
regards, tom lane
I just checked my configuration and found out that "log_lock_waits" was already enabled.
Unfortunately there is no log output of locks when those long running "SET ROLE" statements occur.
Regards,
Ulf
