2017-11-08 0:45 GMT+01:00 Tom Lane <t...@sss.pgh.pa.us>: > =?UTF-8?Q?Ulf_Lohbr=C3=BCgge?= <ulf.lohbrue...@gmail.com> writes: > > I just ran "check_postgres.pl --action=bloat" 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