From postgresql document, I know vacuum can skip pages that are already marked in visibility map, so vacuum progress only vacuum pages which requires vacuum,and we call this partival vacuum; Sometimes all pages of a table happen to require vacuuming to remove dead row version, we call this whole table vacuum ( not vacuum full ), My question is: How can we see if a vacuum is a partial vacuum or whole table vacuum, the following is the output of vacuum verbose commond, can we judge from this ?
--vacuum verbose mydb=> vacuum verbose test_vacuum2; INFO: vacuuming "mydb.test_vacuum2" INFO: "test_vacuum2": found 0 removable, 774 nonremovable row versions in 5 out of 5 pages DETAIL: 0 dead row versions cannot be removed yet. There were 226 unused item pointers. 0 pages are entirely empty. CPU 0.00s/0.00u sec elapsed 0.00 sec. VACUUM