The SVL_VACUUM_PERCENTAGE view reports the percentage of data blocks allocated to a table after performing a vacuum. This percentage number shows how much disk space was reclaimed. See the VACUUM command for more information about the vacuum utility.
SVL_VACUUM_PERCENTAGE is visible only to superusers. For more information, see Visibility of Data in System Tables and Views.
|Column Name||Data Type||Description|
|xid||bigint||Transaction ID for the vacuum statement.|
|table_id||integer||Table ID for the vacuumed table.|
|percentage||bigint||Percentage of data blocks after a vacuum (relative to the number of blocks in the table before the vacuum was run).|
The following query displays the percentage for a specific operation on table 100238:
select * from svl_vacuum_percentage where table_id=100238 and xid=2200; xid | table_id | percentage -----+----------+------------ 1337 | 100238 | 60 (1 row)
After this vacuum operation, the table contained 60 percent of the original blocks.