Re: Is there a way (except from server logs) to know the kind of on-going/last checkpoint?

On Thu, Jan 27, 2022 at 06:56:57PM +0800, Julien Rouhaud wrote:
> 
> What it's showing is the "currently ongoing checkpoint or last completed
> checkpoint" kind.

Ah after double checking I see it's storing the information *after* the
checkpoint completion, so it's indeed the last completed checkpoint.  I'm not
sure how useful it can be, but ok.

> Also, it's only showing the initial triggering conditions of checkpoints.
> For instance, if a timed checkpoint is started and then a backend executes a
> "CHECKPOINT;", it will upgrade the ongoing checkpoint with additional flags but
> AFAICS those new flags won't be saved to the control file.

This one is still valid I think, it's only storing the initial flags and not
the possibly upgraded one in shmem.