amazon-redshiftvacuum

Amazon Redshift - Vacuum and Analyze details


Is it possible to view the history of all vacuum and analyze commands executed for a specific table in Amazon Redshift.


Solution

  • You can check the history of VACUUM run using query history tables - SVL_STATEMENTTEXT etc.
    Documentation for more details.
    Fair warning, these history tables only store data for last 15 days, so in the long run you might wanna take back ups.

    You can also check the current sorted-unsorted blocks for a current table in Redshift, that gives a good idea of how the table data is stored.
    Documentation for more details.