Re: Streaming replica hangs periodically for ~ 1 second - how to diagnose/debug

hubert depesz lubaczewski <depesz@depesz.com>

From: hubert depesz lubaczewski <depesz@depesz.com>
To: Rob Sargent <robjsargent@gmail.com>
Cc: Adrian Klaver <adrian.klaver@aklaver.com>, PostgreSQL General <pgsql-general@lists.postgresql.org>
Date: 2025-08-21T09:50:53Z
Lists: pgsql-general
On Wed, Aug 20, 2025 at 11:24:29AM -0600, Rob Sargent wrote:
> > On Wed, Aug 20, 2025 at 08:14:47AM -0700, Adrian Klaver wrote:
> >> Hmm.
> >> 
> >> From initial post:
> >> 
> >> "For ~ 1 second there are no logs going to log (we usually have at 5-20
> >> messages logged per second), no connection, nothing. And then we get
> >> bunch (30+) messages with the same milisecond time."
> 
> Is that logger ms or db server ms?  The latter seems unlikely to me. 

Sorry, I don't understand your question.

I know it's unlikely, so it seems that something "froze" pg, for ~ 1s.
The question is how to diagnose/debug what it is.

Best regards,

depesz