Menu
Amazon Redshift
Database Developer Guide (API Version 2012-12-01)

SVV_VACUUM_PROGRESS

This view returns an estimate of how much time it will take to complete a vacuum operation that is currently in progress.

SVV_VACUUM_PROGRESS is visible only to superusers. For more information, see Visibility of Data in System Tables and Views.

Table Columns

Column Name Data Type Description
table_name text Name of the table currently being vacuumed, or the table that was last vacuumed if no operation is in progress.
status text Description of the current activity being done as part of the vacuum operation:
  • Initialize

  • Sort

  • Merge

  • Delete

  • Select

  • Failed

  • Complete

  • Skipped

  • Building INTERLEAVED SORTKEY order

time_remaining_estimate text Estimated time left for the current vacuum operation to complete, in minutes and seconds: 5m 10s, for example. An estimated time is not returned until the vacuum completes its first sort operation. If no vacuum is in progress, the last vacuum that was executed is displayed with Completed in the STATUS column and an empty TIME_REMAINING_ESTIMATE column. The estimate typically becomes more accurate as the vacuum progresses.

Sample Queries

The following queries, run a few minutes apart, show that a large table named SALESNEW is being vacuumed.

Copy
select * from svv_vacuum_progress; table_name | status | time_remaining_estimate --------------+-------------------------------+------------------------- salesnew | Vacuum: initialize salesnew | (1 row) ... select * from svv_vacuum_progress; table_name | status | time_remaining_estimate -------------+------------------------+------------------------- salesnew | Vacuum salesnew sort | 33m 21s (1 row)

The following query shows that no vacuum operation is currently in progress. The last table to be vacuumed was the SALES table.

Copy
select * from svv_vacuum_progress; table_name | status | time_remaining_estimate -------------+----------+------------------------- sales | Complete | (1 row)