Re: Proposal: Add backup start time to pg_stat_progress_basebackup - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: Proposal: Add backup start time to pg_stat_progress_basebackup
Date
Msg-id CAKFQuwZiBDDJABkR2VVSKgY1H90K8c8OgLVwDxS-R9guLASyzQ@mail.gmail.com
Whole thread Raw
In response to Proposal: Add backup start time to pg_stat_progress_basebackup  (Rob Moore <robmoore121@gmail.com>)
Responses Re: Proposal: Add backup start time to pg_stat_progress_basebackup
List pgsql-hackers
On Monday, January 19, 2026, Rob Moore <robmoore121@gmail.com> wrote:

Was backup start time intentionally omitted from pg_stat_progress_basebackup, or would it be okay for me or someone else to add it as a column? Or, am I being daft and there is another obvious way to get the start time for an in-progress base backup?


Not sure about base backup but the other progress reporting commands would get that info from pg_stat_activity.query_start which can be joined to using pid.  backend_start is likely close enough for pg_basebackup if it doesn’t recognize the replication protocol as a “command”.  I haven’t checked.

David J.

 

pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: Row pattern recognition
Next
From: Henson Choi
Date:
Subject: Re: Row pattern recognition