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.96) (envelope-from ) id 1w3a3i-001Mce-20 for pgsql-novice@arkaria.postgresql.org; Fri, 20 Mar 2026 13:38:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w3a3g-006GcF-2k for pgsql-novice@arkaria.postgresql.org; Fri, 20 Mar 2026 13:38:37 +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.96) (envelope-from ) id 1w3a3g-006Gc5-1o for pgsql-novice@lists.postgresql.org; Fri, 20 Mar 2026 13:38:37 +0000 Received: from mail-wm1-x32b.google.com ([2a00:1450:4864:20::32b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w3a3e-00000000Anx-4ANP for pgsql-novice@lists.postgresql.org; Fri, 20 Mar 2026 13:38:35 +0000 Received: by mail-wm1-x32b.google.com with SMTP id 5b1f17b1804b1-485410a0a8aso5063325e9.2 for ; Fri, 20 Mar 2026 06:38:34 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1774013912; x=1774618712; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=XT0U25+/dcxhY7zzQ4nhOaL8e4Kt1ac5TXqidHIfgY8=; b=nds7cnhDQg+aOJKiYNZ6NjEH8GEtaYU5zzqjb9eBXwbp/Ius7L8Vi3DnMNcQJfzXLj lXSMTevm2OIFGDONgdc6RG+4LDIprDOkvMymVKGVmdIayJ91SAIfrRfhE+RFe3t02ZYy KjZHtKh8EGziB3WfRlYTcVV8l+jiLq+SL9dF/b9yPmro4B2nanGVfa/FiKjcshYCCB4r 36BRTYvOFdhYd1rzMZBR5Mhzci68RMK93GDL8+bz2p8bleyanrYEZIX+nGq6YMXLzEBv q2t9xUvuNMxAbBcUSN2t+ZAmJVimz9+8PFvbeUfXSGAfuj5ZaDEC9dUe+Xh8ksiBu5Qi cYeg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1774013912; x=1774618712; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=XT0U25+/dcxhY7zzQ4nhOaL8e4Kt1ac5TXqidHIfgY8=; b=PHiOS+cT528exQAPoBTKcw1K746c89iKDkjP7xY+rXdodJI9sw3N5ZpQtSMhiNaybn 3CZm6fw8s3HV7CeRgHtGCIoCZISdA6p0I1T4xNuTxMrtexmD9hzY18KI65s9QSCj+2G/ O+3U200bIMe4GLnrfAwwlVAP6cyt0PNAHNpMq4yQKITr79b5FctPmKPhv6ZcsTBbsj+g E4Hzv1x2VDuUClIqiaqQpcEL8vZUMotSCw0b6Ui8PEe9U+0PC9Pon5Qln43E6lgOVDAr V7dl5/SHLggS0j1mfihT/5sge9QSgVf4qsk8Uuk8uaMsz6OfCwysY9Ije5IwKL6jROcl ZNkg== X-Forwarded-Encrypted: i=1; AJvYcCUzOJ4XUA4rkssgerRL6UCKUnSxHwc8KKQcFEUQYaaP0jAS4AT1DZytQ9jqQpOMX4o9I6JKmaSxxuYUGJo=@lists.postgresql.org X-Gm-Message-State: AOJu0YxTTrk450+Ayebs9lAO/vCUREhTG8eszUkKWILJMBotvy7kYBf+ x1Sbt1tsGbRi25hRJIIi3wSO0fszBI8FTTXxzNA9C/YFX4B5xDL6F22cgoBsW/HpXvHsEQDQ71n n2OXqfm0= X-Gm-Gg: ATEYQzyeE6Bg1nJrZMgkLCzvKKBsOoCKj7Wr55YtuRWcb1PEpdncDSbnCSonfmLhKgI rkZqElG9cu/E9vkeOLvmkD+yZUpcJZkgivgMZkRHFI3XMEO3g0OGpKaVrgxW2GUsZirN5cNBzzS MFkN5GLRSB8mxpNYHW+wyGTJHmkedhMGD0WAeetQSTlxSbyj+apV6qmKjGCcFdvMEfFcugWkYjK kCZ9tSm3/vL16qbghxUeg3x19n2u7uUM4BKj9LkBfF7FH5MwVxKDVo1ZULtMNgyrFK2OLyDQlqc ZsQgUJvHjP5/o98dqlwwJKGW7VuoxtzBs/m82JUZKVslZ3jXUpQY/gWPE7rzk5OeBlnDDPaHYCs e2ZQbAKWh0V7/8n/RFfgnoJovKDF34KifOFjvJtQ866t4Ls5/lwDw77Eqp1o1qPDoIA3bsCJx6W /huI4tbLvWhW1xv4tcW8A8H1QndgLPMKgRJZX0VXgKGYdSAn0sdA0= X-Received: by 2002:a05:600c:4705:b0:485:3a86:6392 with SMTP id 5b1f17b1804b1-486fee0d816mr45441985e9.20.1774013912145; Fri, 20 Mar 2026 06:38:32 -0700 (PDT) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:70:e90e:121b:3a33:bb9b:f66]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-48700377b71sm18538865e9.0.2026.03.20.06.38.31 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 20 Mar 2026 06:38:31 -0700 (PDT) Message-ID: <8b38fa5141905f9ad6983b8d5ae944e812e3d28a.camel@cybertec.at> Subject: Re: AW: Replication Testing- How to introduce a Lag From: Laurenz Albe To: "Subramanian,Ramachandran" , "pgsql-novice@lists.postgresql.org" Date: Fri, 20 Mar 2026 14:38:31 +0100 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.58.3 (3.58.3-1.fc43) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, 2026-03-20 at 10:47 +0000, Subramanian,Ramachandran wrote: > how can the last replayed be more than the last received? It shouldn't be - but I don't understand your script, in particular which query is issused on which server. Look at "pg_stat_replication" on the primary server. Yours, Laurenz Albe