Let’s say I’ve deleted an archive set in the csr and ran the purge delete archive set job. Although the job was successful ran, but when I go look at the csr | archive set, stat show the status as deleted with the number of objects in the archive set.
The csr_ps_swat row is left there with a status on it (deleted). This is because of other tables that are out there that have that archive set id on them (like migration history). What is removed is the csr_ps_swat_obj rows and the associated shadow tables.