Hi Tony,
There is no default retention policy defined.
To clean up such records for cinder you can run command
cinder-manage db purge <days to retain>
For nova it's a bit more complicated as first you would archive these records and only then purge them from shadow tables. This is done with nova-manage command.
You can check docs regarding it's usage:
Hi,
I see the record for deleted resource stay in database.
What's the retention policy for those records?
Is it configurable?
Any manual cleanup is required?
Thanks!
Tony