SVL_VACUUM_PERCENTAGE - Amazon Redshift

SVL_VACUUM_PERCENTAGE

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.

Some or all of the data in this table can also be found in the SYS monitoring view SYS_VACUUM_HISTORY. The data in the SYS monitoring view is formatted to be easier to use and understand. We recommend that you use the SYS monitoring view for your queries.

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.