Re: pg_stat_progress_vacuum empty when running vacuum full - Mailing list pgsql-general

From Ian Lawrence Barwick
Subject Re: pg_stat_progress_vacuum empty when running vacuum full
Date
Msg-id CAB8KJ=ggE==4UQVPwzOqqEGKQW0tU_c_2uhWh+a6RDZgEpBmNA@mail.gmail.com
Whole thread Raw
In response to pg_stat_progress_vacuum empty when running vacuum full  (Luca Ferrari <fluca1978@gmail.com>)
List pgsql-general
2021年2月12日(金) 20:01 Luca Ferrari <fluca1978@gmail.com>:
Hi all,
I'm running 11.5 and I'm monitoring pg_stat_progress_vacuum every 2
seconds, while doing from another connection per-table VACUUMs. Every
vacuum last 30 or more seconds, so I was expecting to see a record
within pg_stat_progress_vacuum, but nothing appears if the vacuum is
full. I suspect this is due to vacuum full performing a side-by-side
table rewriting, rather than in-place actions against the original
table, but I'm not sure if this is real reason or if I'm missing
something.


If you're executing VACUUM FULL, you should be looking at pg_stat_progress_cluster:


Though that doesn't appear until Pg 12.

Regards

Ian Barwick
--

pgsql-general by date:

Previous
From: Luca Ferrari
Date:
Subject: pg_stat_progress_vacuum empty when running vacuum full
Next
From: luis.roberto@siscobra.com.br
Date:
Subject: Re: pg_stat_progress_vacuum empty when running vacuum full