On 24 January 2017 at 06:57, Michael Paquier <michael.paquier@xxxxxxxxx> wrote: > On Mon, Jan 23, 2017 at 8:32 PM, Alexander Shchapov > <alexanderad@xxxxxxxxx> wrote: >> 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. > > Yes, things could be improved here. Yes, it seems that VACUUM progress reporting feature is only about 40% complete. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
