Re: Why does [auto-]vacuum delay not report a wait event?

Andres Freund <andres@anarazel.de>

From: Andres Freund <andres@anarazel.de>
To: Justin Pryzby <pryzby@telsasoft.com>
Cc: pgsql-hackers@postgresql.org
Date: 2020-03-24T06:00:32Z
Lists: pgsql-hackers
Hi,

On 2020-03-21 17:24:57 -0700, Andres Freund wrote:
> > diff --git a/src/include/pgstat.h b/src/include/pgstat.h
> > index 851d0a7246..4db40e23cc 100644
> > --- a/src/include/pgstat.h
> > +++ b/src/include/pgstat.h
> > @@ -848,7 +848,8 @@ typedef enum
> >  	WAIT_EVENT_BASE_BACKUP_THROTTLE = PG_WAIT_TIMEOUT,
> >  	WAIT_EVENT_PG_SLEEP,
> >  	WAIT_EVENT_RECOVERY_APPLY_DELAY,
> > -	WAIT_EVENT_RECOVERY_RETRIEVE_RETRY_INTERVAL
> > +	WAIT_EVENT_RECOVERY_RETRIEVE_RETRY_INTERVAL,
> > +	WAIT_EVENT_VACUUM_DELAY,
> >  } WaitEventTimeout;
> 
> Looks good to me - unless somebody protests I'm going to apply this
> shortly.

And pushed. The only thing I changed was to remove the added trailing ,
:)

Thanks for the patch,

Andres



Commits

  1. Report wait event for cost-based vacuum delay.