File type statistics are calculated using a PostgreSQL query that extracts file extensions from the filename. The results are sorted by total size (largest first) and exclude soft-deleted files (deleted_at IS NULL).
The total_storage value represents actual file sizes stored in the database. If physical files are deleted or modified outside the API, this value may become inaccurate.