On Wed, Jan 6, 2021 at 11:19 AM Don Seiler <d...@seiler.us> wrote: > Good morning, > > This week we've noticed that we're starting to see spikes where COMMITs > are taking much longer than usual. Sometimes, quite a few seconds to > finish. After a few minutes they disappear but then return seemingly at > random. This becomes visible to the app and end user as a big stall in > activity. >
How are you monitoring the COMMIT times? What do you generally see in pg_stat_activity.wait_event during the spikes/stalls? Cheers, Jeff >
