How to handle diff types of missing assets from s3

How to find the missing assets from S3?
I’m familiar with all the basic rake (and rails) commands.
I can also find ‘deleted’ files from S3 buckets (thru web console and thru Cli)
I found many missing images from diff posts/topics and restored them from ‘deleted objects’ in/under S3 successfully. But can’t find how to tackle ‘118 missing rows in post uploads’; ‘other missing uploads: 524’; 529 missing rows in users uploaded avatar id’; and so on…

Can someone send me in right direction?