On Wed, Jan 6, 2021 at 11:19 AM Don Seiler <don(at)seiler(dot)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
>