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 1w5umw-003kmQ-0L for pgsql-hackers@arkaria.postgresql.org; Fri, 27 Mar 2026 00:10:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w5umu-006ePD-0y for pgsql-hackers@arkaria.postgresql.org; Fri, 27 Mar 2026 00:10:56 +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 1w5umt-006eP4-2q for pgsql-hackers@lists.postgresql.org; Fri, 27 Mar 2026 00:10:56 +0000 Received: from mail-oo1-xc2f.google.com ([2607:f8b0:4864:20::c2f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w5ums-00000001EA6-10iH for pgsql-hackers@postgresql.org; Fri, 27 Mar 2026 00:10:55 +0000 Received: by mail-oo1-xc2f.google.com with SMTP id 006d021491bc7-67df618d095so942535eaf.0 for ; Thu, 26 Mar 2026 17:10:54 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1774570253; cv=none; d=google.com; s=arc-20240605; b=Hs6z8BzzhY1IQKriXgvyRj1DXjCXcp2XngKsERUkvyldKAlz7K/pJLxybyMXscfYe6 UEtIvJ13Qlo0vCDXP5ggZXQxwIUU+3kYQvpNeeUPXh2qX/WXmn4US+GJkWouwK6qSSPr Oxxyg1FOcoABIKWXBvo96IB4z5X2lak/sKikWD1MXtLx6ES0ukqMrOD5+o+MOMM4+ljR 41+gTKdlv4qMD/y1q++XoI8YasAkubRvyI/3Y3yGKruTN/irVgdQHch5bhN4RVmJna6C exD1vEgJKljAWSy0SVleuucFUryO3aJYPwPbAjv/doHmQDK0a6aYo8gvhpZ/W/uvW7I5 U/uA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=rVBHoZFMsPxoljmWzeTBjbLxnG4lBs5toAVcHzifnZw=; fh=8MsnhqHLXGBsr4IsvkWR3RjZWwautaM0r9ctA40wNo0=; b=EHPwV3G3Ph86VpUaaSnU+S+iU8CYwldA7Pacp0WLLZ/haCCpfuioiYBd9EV9khzEq4 l8xBNuTCjH3kCezd4pYj8AAnF4az9a/niDc5jWQ75IRRtkgZJscsnFKfOpQ/kZQNcdSG U+4kutx2XusbyLnA3jztG9usYF1uPNI0v/DiMnwpP7HMr9YdAnKuCVcXGW8b2pCSzbqt OBZBhrTI+O6LXkXqSdZnI+UpKurZ1BAn3rcjt3g7k4Nr696HfwtL+9R+G+K2yE7SMSrI wPm0V36hkXIOwrPSvCMdTrjbu6j1TRPYBM6KciDYo6YYgFZMTaxoZwNtrKGQplZkZC+m xNUA==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1774570253; x=1775175053; darn=postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=rVBHoZFMsPxoljmWzeTBjbLxnG4lBs5toAVcHzifnZw=; b=D2EYw3Matcxnc0Ru4ePNukvwKZwdI/rwL2uE6ChSWr8fA9HsP8GU2Ffsrqr2MRWqZm yfu5A+tDoa1+Mx7d+677QuCCOSbOyvUzHvowxGLVEDjx45cEOHKuqfDM455u4G8Cy2/L rGwNdg3jgH75p1RXeCFAQ1FCyIzULEjK0rhOZ1LtM0jB6XEmYIFjcv95Nlh6n/67Pekw 2gApu2oPv8n8R0E4Lb8JIyqcVTx63RjW0/3gmSsS7vxDDVSiDzIa8b8M1biuboHzHZwb LzyFuR+yN3CDMsPly6m4ILvFEuqPmZXoNN/X5EfQE89yZp2Jaa3rIcup65uInBSOU6GM keqw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1774570253; x=1775175053; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=rVBHoZFMsPxoljmWzeTBjbLxnG4lBs5toAVcHzifnZw=; b=OLsClftM/dYnuFljWBMyQRos5N4KPA1J5KsmSqCcza/MKWIC9zw2GUjgEvCPlhjm5t 0x0KYmMTBSvlg0TEyhEqz0ZtDWqBnBQvUZnBVQRgqImqhQJ35bApl0y4dNNT/PiLzmUY ysOfVqBOv+TE5EanQzpNtqP2jEe1OEDEnWyRnmQKXz2IK9+TJ+7znLFmRDL89qiQQZyJ /lw3V3/v18k3OjnRUtPnSIs33P7AlUYA/vjOSrsITtFsysJd5BDzSdgvWET1e686nOA6 onO6sd7T6cbB/rP1Nc6NlZKLMcv/5ZkEPvxsfUdjhFwC44IbMLK2e1KJlOhXmNwoiovX rtKQ== X-Forwarded-Encrypted: i=1; AJvYcCXwHGJ/auoNdrSDQ0hWvec5eTmbou2kX04ybpTN043xtcEtoXsTS6gAms7cGkO3RVkJ4nH29T8y0niBoenb@postgresql.org X-Gm-Message-State: AOJu0YzTxWeYx/eSuOpo2pGO8tcHsT+iEYKWcIp2kcUEJn1j+F1XhqtN dvuih//f9W95OQjuOdg+2xKRoYZo3JKxPAJk2skEZd6F3BDUbpBrC5zgk+THZOcu9sKuvShZJkR m1L68tFuslmsfcdFkp97kDnqspPfgK4wGE8AF1ok= X-Gm-Gg: ATEYQzyrqunsM810oyErylalBv8bNyT1RIOfHbq0XQ5KCASQZW1BX9bo27pu4Q1Is1/ urauA9U5BBIDDZsb7fkNJLjE2b0Iw8H3rjZNcobZka8d2UEuojPGmsrfWrLoig6lGk582fY6Q4L 5djQFMHgSAeyqHzBDy0fXV7kmj/447YWFaeaG4U77SXgoBHRyAnF8HvgObz4eTD4JeeykpwZ5hj bDMXUYHHDcNqdi7RejbpXehEX5gYRv43r1RgqO0OfvBTWKs+YT9NPKGViG+x2ppGCyRrrRos6x0 Q5D49A== X-Received: by 2002:a05:6820:1897:b0:67e:e42:d4c1 with SMTP id 006d021491bc7-67e185e4053mr325874eaf.10.1774570253407; Thu, 26 Mar 2026 17:10:53 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Bharath Rupireddy Date: Thu, 26 Mar 2026 17:10:41 -0700 X-Gm-Features: AQROBzAC5YdY1DqSQuCqTpUUG3s6wpUhEn1PtbvCJdRZTWmooODzWkoXoLUaDPw Message-ID: Subject: Re: log XLogPrefetch stats at end of recovery To: Lakshmi N Cc: Jakub Wartak , Thomas Munro , SATYANARAYANA NARLAPURAM , pgsql-hackers@postgresql.org Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On Thu, Mar 26, 2026 at 1:06=E2=80=AFAM Lakshmi N = wrote: > > Address this in the attached patch. Please let me know if this looks good= . > 2026-03-26 00:51:19.797 PDT [91881] LOG: redo prefetch stats: prefetched= 418376 blocks, skipped (362419 in the buffer pool, 418479 zero-initialized= , 0 non-existent, 9 full page image, 39183318 recently prefetched) Thanks for sending the latest patch. It looks good to me with a nit:s/362419 in the buffer pool/362419 already in buffer pool. I will leave it to others' choice. --=20 Bharath Rupireddy Amazon Web Services: https://aws.amazon.com