Hi all, We've recently upgraded to 9.6.1 and now playing with newly available pg_stat_progress_vacuum view. There are 7 stages for standard VACUUM process which is reportable via this view. For time consuming stages like "scanning heap" or "vacuuming heap" you are able to get stage progress idea by doing: (heap_blks_scanned | heap_blks_vacuumed) / heap_blks_total * 100% However stage "vacuuming indexes" does not give any idea of how long this stage might take. We have some rather big (500M+ records) with 5-7 indexes. Sometimes it takes us 20 hours+ to get table vacuumed and all progress reporting we have for stage 3 is that it is stage 3. According to code (https://github.com/postgres/postgres/blob/1d25779284fe1ba08ecd57e647292a9deb241376/src/backend/commands/vacuumlazy.c#L708-L712) looks like there might be a way to report number of indexes left to be vacuumed. The question is: is it a right thing to expect a patch which adds more detailed stage 3 reporting? Say index number being vacuumed. Thanks. -- Alexander Shchapov -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
