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.

Table columns

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).

Sample query

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.