You can look at the ost_file table.
The size column tells you the size of the attached file.
So if you wanted to see all attachments large than say 1,500,000 you could do something like:
SELECT * FROM ost_file WHERE size > '1500000'
The id is the file_id in ost_file_chunk.