I can provide some insight about the files.

When a user uploads something in a form but never submits, the file remains a ghost until it's either submitted by the user or by the next pruning, if the pruning snags it, it's deleted.

Same goes for profile pictures and covers. When a user changes them, the old ones are still housed on the server until next prune, to which they are deleted.