SYS_VACUUM_HISTORY is better option for this use case.
SYS_VACUUM_HISTORY
https://docs.aws.amazon.com/redshift/latest/dg/SYS_VACUUM_HISTORY.html