Request a Demo
Home   >   mailing lists

Re: log XLogPrefetch stats at end of recovery - Mailing list pgsql-hackers

From SATYANARAYANA NARLAPURAM
Subject Re: log XLogPrefetch stats at end of recovery
Date
Msg-id CAHg+QDfLh-yb+OacN6qPYF6H3SPDmVJUiors7vkSMq4yxfhNrA@mail.gmail.com
Whole thread
In response to log XLogPrefetch stats at end of recovery  (Lakshmi N <lakshmin.jhs@gmail.com>)
Responses Re: log XLogPrefetch stats at end of recovery
List pgsql-hackers
Tree view
Hi,

On Wed, Mar 18, 2026 at 12:18 AM Lakshmi N <lakshmin.jhs@gmail.com> wrote:
Hi,

While investigating a long recovery, I noticed that XLogPrefetch stats were not logged at the end of recovery. This log message will be useful to understand how effective XLogPrefetch was during recovery. Adding a patch to address this.

Applied this patch and validated the log message. This log message appears to be useful to me, particularly while doing fleet wide analysis. I am wondering if we can periodically log this in standby mode as well, not just before promoting?

2026-03-20 23:33:13.756 PDT [2265441] LOG:  XLogPrefetcher stats: prefetch=14, hit=6, skip_init=5, skip_new=28, skip_fpw=18, skip_rep=996 

Thanks,
Satya

pgsql-hackers by date:

Previous
From: Richard Guo
Date:
Subject: Re: Remove inner joins based on foreign keys
Next
From: jian he
Date:
Subject: Re: CAST(... ON DEFAULT) - WIP build on top of Error-Safe User Functions