On Tue, Oct 20, 2015 at 4:58 AM, Syed, Rahila <Rahila.Syed@nttdata.com> wrote:
>>I think that you should add the flag or something which indicates whether this backend is running VACUUM or not, into
PgBackendStatus.
>>pg_stat_vacuum_progress should display the entries of only backends with that flag set true. This design means that
youneed to set the flag to true when starting VACUUM and reset at the end of VACUUM progressing.
> Please find attached updated patch which adds a flag in PgBackendStatus which indicates whether this backend in
runningVACUUM.
Flag isn't reset on error.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company