Postgres VACUUM taking forever

Question

I have an specific table that is taking forever o VACUUM.

There are no locks in the DB and even letting it overnight the VACUUM didn't finish.

According to the statistics (ANALYZE works fine) the table has 45GB in size and around 250K rows.

Is there some way to show the current status of the VACUUM and/or improve the way it executes?

Abdel P. · Accepted Answer · 2019-08-17 01:36:30Z

You can see the progress of vacuum with

select * from pg_stat_progress_vacuum;

Here are some tips for vacuuming large tables

You do not have to wait too long for autovacuuming

1 Answer 1