Statistics/Content size

Results

Last run on 2017-10-19 12:38:24 +0000, querying the replica DB on somerset.internal.softwareheritage.org.

Min.	1st Qu.	Median	Mean	3rd Qu.	Max.
2.000e+00	1.052e+03	3.387e+03	8.011e+04	1.247e+04	1.314e+09

Unit is length in bytes of uncompressed contents.

Sample size: 3.837.249 contents.

SQL:

SELECT length
FROM content TABLESAMPLE BERNOULLI (0.1);  -- 0.1% of known blobs

R:

length(sizes)
summary(sizes)

png('content_sizes.png')
hist(log10(sizes))
dev.off()