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