Date: Thu, 21 Aug 2025 11:50:53 +0200
From: hubert depesz lubaczewski <depesz@depesz.com>
Sender: depesz@depesz.com
To: Rob Sargent <robjsargent@gmail.com>
Cc: Adrian Klaver <adrian.klaver@aklaver.com>,
	PostgreSQL General <pgsql-general@lists.postgresql.org>
Subject: Re: Streaming replica hangs periodically for ~ 1 second - how to
 diagnose/debug
Message-ID: <aKbr_aULbF02tG5Z@depesz.com>
Reply-To: depesz@depesz.com
References: <aKXy64uaOasow3eK@depesz.com>
 <D79F4468-F335-46C5-95E9-4368D0121CA2@gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
In-Reply-To: <D79F4468-F335-46C5-95E9-4368D0121CA2@gmail.com>
Archived-At: <https://www.postgresql.org/message-id/aKbr_aULbF02tG5Z%40depesz.com>
Precedence: bulk

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