>Okay, I've just tested this with a newly-loaded table (1,252,973 of jsonb
Thanks a lot!
>but after it's finished, I end up with this:
>json=# select * from pg_stat_vacuum_progress;
>-[ RECORD 1 ]-------+-------
>pid | 5569
>total_pages | 217941
>scanned_pages | 175243
>total_heap_pages | 175243
>scanned_heap_pages | 175243
>total_index_pages | 42698
>percent_complete | 80
>This was running with a VACUUM ANALYZE. This output seems to suggest that it
Ok. The patch fails here because 'total pages to be scanned' takes into account
index pages and no index pages are actually scanned.
So the scanned pages count does not reach total pages count . I will fix this.
It seems that no index pages were scanned during this because there were no
dead tuples to be cleaned as the table was newly loaded.
>After, I ran VACUUM FULL. pg_stat_vacuum_progress didn't change from before,
>so that doesn't appear to show up in the view.
The scope of this patch is to report progress of basic VACUUM . It does not
take into account VACUUM FULL yet. I think this can be included after basic
VACUUM progress is done.
>I then deleted 40,000 rows from my table, and ran VACUUM ANALYZE again. This
>time it progressed and percent_complete reached 100
Disclaimer: This email and any attachments are sent in strictest confidence
for the sole use of the addressee and may contain legally privileged,
confidential, and proprietary data. If you are not the intended recipient,
please advise the sender by replying promptly to this email and then delete
and destroy this email and any attachments without any further use, copying
Sent via pgsql-hackers mailing list (firstname.lastname@example.org)
To make changes to your subscription: