Odoo's filestore stores a file by its checksum, so attaching the same PDF to ten records stores it once. A "duplicates" report that adds up sizes will overstate what you could save. The number that matters is the stored size, counting each file once.
Disclosure: I make a paid Odoo module that reports on this (link at the bottom).
Orphans are the other surprise. If an attachment's record was deleted (by SQL, or a failed cascade), Odoo hides the attachment from every user except the superuser, so the Attachments list never shows it. They take space and nobody can see them.
A third case is a database row whose file is gone from the filestore. Pages that show attachments fail on those.
I wrote a module that reports total and stored size, the biggest files, duplicate groups, orphans (with a confirmed delete that re-checks first) and missing files. It's called Attachment Analyser, 39 EUR on the Apps Store: https://apps.odoo.com/apps/modules/19.0/attachment_analyser/
