pg_stat_progress_vacuum empty when running vacuum full

From: Luca Ferrari <fluca1978(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: pg_stat_progress_vacuum empty when running vacuum full
Date: 2021-02-12 11:00:46
Message-ID: CAKoxK+4+7=DJXT9xL5AwkLNnNFc3zD0e-kO6Ovik=s+AUxPgzw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Thanks,
Luca

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ian Lawrence Barwick 2021-02-12 11:17:52 Re: pg_stat_progress_vacuum empty when running vacuum full
Previous Message Matthias Apitz 2021-02-12 10:24:37 kernel.shmmax and kernel.shmall for Linux server