Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uomYF-00A5Ye-Pb for pgsql-general@arkaria.postgresql.org; Wed, 20 Aug 2025 17:24:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uomYF-00AIBL-6Y for pgsql-general@arkaria.postgresql.org; Wed, 20 Aug 2025 17:24:43 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uomYE-00AIAb-S9 for pgsql-general@lists.postgresql.org; Wed, 20 Aug 2025 17:24:43 +0000 Received: from mail-pj1-x1034.google.com ([2607:f8b0:4864:20::1034]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uomYD-000sgT-0L for pgsql-general@lists.postgresql.org; Wed, 20 Aug 2025 17:24:42 +0000 Received: by mail-pj1-x1034.google.com with SMTP id 98e67ed59e1d1-32326793a85so139239a91.1 for ; Wed, 20 Aug 2025 10:24:41 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1755710681; x=1756315481; darn=lists.postgresql.org; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:from:to:cc:subject:date:message-id :reply-to; bh=H84ftD+DAcoxYrEpi1hEa+twOaIrTyL2gBYL94XCRLI=; b=lltBbYmU60YjW93RrTVSwxoucvPjPcBOEV4iEU0a+BaK2W8L0moHNVW9vZhURFVger YcYoFyzgQwas2WP3ZtKxlR0asnKP6tWJFB9PWW6Gt0Prk9+oD3EGuV/e71OFyYlxxSqm 8k8ZMHz168zqZxOgXClnV/cJ/ZZ7uJgS2sx8zDfQKt8Sz7ECLkoqSlO75wiOAr/5A+8E W9UFg2H26KD0omKX1Snp+eiC4w5++L8rEFhTh3qwWDGXw2htQ3wA6rjPHObbZST1xk3i IUSZqiqURv+MkvNfzCr2UYUDMRflf61RR9ggNMyYKmUtWGWe0LfuXZuT8G9LYbkNmLbD Kj0Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1755710681; x=1756315481; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=H84ftD+DAcoxYrEpi1hEa+twOaIrTyL2gBYL94XCRLI=; b=WFeRFHkodB5rLb07hXAZibcE+Oq/UuWAPcOdN55SPM2M8pjWrrNEseqq50Ek35lhX2 HpcIRAXx3utMQKxQa5zFREAZG4XjK/g6cRRYY0/ast3V2G6UoeDi15WSydgb60i9N2ZH 17WUnes4p+qwst/SSqvZs6eeeZcPCExqQeZzDmKWjDvbq4j3a+n72IqpdQ+DvJms4PwQ sup89cSOErVf/OCwCKYPMoSmIwJOxzxTmqkNPevMYlLiiQSXBSBXPGDTuqy5MrUtmFQn EtSaw5eITChz/VQXKCFopdM0cdU39VRjKfOOS2CkoA3ZQCflfs4BJrjm1BJGU/BIqWfZ 5EpQ== X-Forwarded-Encrypted: i=1; AJvYcCWZoMbZuOWVMl8DNEMQNNFBL4e28zQAorvAvOiVrd2YlU9BxV2J590EEBr4TKVxPkTWEgw2o9lm6jzmD9EY@lists.postgresql.org X-Gm-Message-State: AOJu0YxPiZRjJOtgXtF70PnrDJax2l1ImeZqaZZU3MQrzai5biV37uv4 pJ55qQDoEoH9htOjsGfP3BtKCH7CB9B/aYqmyRmRWRlFfLOt1KL2ZYEay7aDeQ== X-Gm-Gg: ASbGnctsayphnZjVxOBynv8uAJe6nWLZIPS/9U+RcsZBKYtpBwfeLoBW0JlIfLQSt24 2evuYbdYgONd25FJ4U+OUFfxk4/cWi/zDbAsx4jtsHNhpPm4a4BtbJJKnVl3Soe9Rs6bSmpHWAh qPCVkvmeoXVKITauyHrsZ313aB02p8z8+zBsKXr/g8Gjlv6l4RIVq82O/uRW+vslRcSk65m19h7 5PnRf7MlQ16F19xMbp3U2Ikvibgcgox2bS4Uh4l/8AbzH8DUpgfxxLZE0GWKPYOI66ukCqUcXoH 85x/3gHvzNdodkggBwsttpgVpS+rxsH3jfg78rDVvOeZDJmiTmG7GfWZrEkEOuJMawW6wqTci0v umMHTH+7DQBwJnFAv+XnOS/afxkarsj2IEvgGvQ7oZeXerA== X-Google-Smtp-Source: AGHT+IENFluv0cVUy6AWZdFmi7gWYKvapuTJEHbzG/S27wTJB4a1mlHxGqD5YsxOlW5CsDSUV8FuwQ== X-Received: by 2002:a17:90b:3f4c:b0:31e:c1fb:dbc6 with SMTP id 98e67ed59e1d1-324e13e463amr4893267a91.22.1755710680872; Wed, 20 Aug 2025 10:24:40 -0700 (PDT) Received: from smtpclient.apple ([15.220.17.202]) by smtp.gmail.com with ESMTPSA id 41be03b00d2f7-b4763fbc711sm2765655a12.2.2025.08.20.10.24.40 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 20 Aug 2025 10:24:40 -0700 (PDT) Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable From: Rob Sargent Mime-Version: 1.0 (1.0) Subject: Re: Streaming replica hangs periodically for ~ 1 second - how to diagnose/debug Date: Wed, 20 Aug 2025 11:24:29 -0600 Message-Id: References: Cc: Adrian Klaver , PostgreSQL General In-Reply-To: To: depesz@depesz.com X-Mailer: iPhone Mail (22G86) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On Aug 20, 2025, at 10:08=E2=80=AFAM, hubert depesz lubaczewski wrote: >=20 > =EF=BB=BFOn Wed, Aug 20, 2025 at 08:14:47AM -0700, Adrian Klaver wrote: >> Hmm. >>=20 >> =46rom initial post: >>=20 >> "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.=20