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 1u5fxd-004KSq-2L for pgsql-admin@arkaria.postgresql.org; Fri, 18 Apr 2025 07:16:29 +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 1u5fxa-008bSc-Ud for pgsql-admin@arkaria.postgresql.org; Fri, 18 Apr 2025 07:16:27 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u5fxa-008bSR-HW for pgsql-admin@lists.postgresql.org; Fri, 18 Apr 2025 07:16:27 +0000 Received: from mail-lj1-x22d.google.com ([2a00:1450:4864:20::22d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u5fxY-000hge-0m for pgsql-admin@lists.postgresql.org; Fri, 18 Apr 2025 07:16:27 +0000 Received: by mail-lj1-x22d.google.com with SMTP id 38308e7fff4ca-3105ef2a070so16651251fa.2 for ; Fri, 18 Apr 2025 00:16:25 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1744960584; x=1745565384; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=UnKTKM8NdeC63XKmnSgDkShGlrwMhnM1CV+sjj5RjE4=; b=QOZhZgXaj9MS4DBddZJ4VMNWpbKUZKMC2RXD+Ao2fsLDvQTTwsCDwb2/Cp/ecLnNT4 lfFB761Y21oWrg4rNAgWffWgg2qraA+n5RVWzlvy1jSIVmzHeYedPvnTMGs7eObuuSHe ThfSqPOLFG3LzCiwoMu9U4IQBQjvjuL7z/4j92caPs/PLjaW+e4U0V+328dr/Sy72E/k 2URw4QeP3V6BnIMlGuxTkmq8PZ/ekn1DeYePuvYCFIzKPGIrUw5FAyTS+1Mb7TZ5JgF8 BKzygTQrtD7/qc3dlcmUPudaNMU4m+QnA80FoSOH9qdPuGUBq7fEHyPHErS5i5XvmLWM LWfw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1744960584; x=1745565384; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=UnKTKM8NdeC63XKmnSgDkShGlrwMhnM1CV+sjj5RjE4=; b=L4vQCKCqAyEk/HY53mCD7UMh9qbRb1TWdd9a+sXblZFvYiqL/jSEmrzSFeEbWDMWZX WJsJ56QSe89Wct+MrXsSs59hUrRI7Ah5VHEgElPd7hvEDj+wiZREDMy3M0Pn6LaU7a1u u7XTNDzxAycY7cNc/g8BU5oPgLfg21RwAFjUPbmSRix28x9GHPWIMulnfa7xmAo6bU3W 4CejzzBBG8VcDBS0cE0N85y1KhpTkjRfTzT86FlVOB/dECuVilcApcxJrhG+TWOErp1E amGhdd10oBIZ64pu3GNqgA+NBZbzC0+1qfDhff02jE6bLgHbLSxqK6vmrv8P3hyr1zmP 0QRg== X-Gm-Message-State: AOJu0YwSeXIYlsIw0SvDnKrEW1UFBfVpbpJ0en9mabmfZnMAEvIB2oln dWJi8e3KOaAqZoR9kGERoHuQEMz4p/vzzFQVoF7TR06QzQeu26i0NVKYYCrrvIuJHT1C/TbHHGK XVNEe8+qX3CDP/dZhYo/BYLSfi3vFgg== X-Gm-Gg: ASbGnct8vMSY0jPAlSbYjPy0oLf62Es/tAPHFe5U+lzzaEVxPaYzl2506O3Nu3eI7q3 Q7HDNaCbJqlwXueQchBU3AJ000kNjT5APmQ/LVwIJpjrPnKLlPF27pFnDSgAmHFRgAc8b22uVx0 tpP0C3yqXHFjf2Lclsdn+VxZ6HzkCQ31qG1yxNdf3jAUj6GSbfp7RM6xNQBRI3AloC X-Google-Smtp-Source: AGHT+IGX9Ahzv5/ajZO9lGsIeItBg2xpBYdksli2E+I8kbXWbDWmJTEliLDY6ZEtPB1eVdFODnwzlRJ0ScKzxCGspIM= X-Received: by 2002:a05:6512:1313:b0:54c:a49:d3ee with SMTP id 2adb3069b0e04-54d6e61c9f3mr68264e87.3.1744921797588; Thu, 17 Apr 2025 13:29:57 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: "Kellyn Pot'Vin-Gorman" Date: Thu, 17 Apr 2025 13:28:37 -0700 X-Gm-Features: ATxdqUGOOtffmDLw13wm5Suq-4ukdv0GxhcYr9S-8-KlrEp-_inAHh0jsmPgyM4 Message-ID: Subject: Re: Replication lag To: Wasim Devale Cc: Pgsql-admin , pgsql-admin Content-Type: multipart/alternative; boundary="000000000000e7fd6e0632ff43ff" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000e7fd6e0632ff43ff Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hey Wasim, You've already checked the lag information in pg_stat_replication, pg_stat_statements and pg_stat_activity? Is there any delay in the setup that might be causing the lag? max_standby_streaming_delay and/or max_standby_archive_delay