Thanks David, I've just tried this, and joining to pg_stat_activity on pid works great. I'll do that.
Sorry for the noise đ , Rob On Tue, Jan 20, 2026 at 11:22âŻAM David G. Johnston < [email protected]> wrote: > On Monday, January 19, 2026, Rob Moore <[email protected]> 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. > > >
