At times, it would be required to review the storage space utilized by one particular repository from Artifactory to decide on the logic to be scripted/programmed for executing the automated tasks, as a part of the cleanup mechanism. In such cases, executing the following query against the database would help to identify the actual binary size. i.e., The amount of physical storage occupied by the binaries in your system, from a particular repository).
$ select sum(binaries.bin_length) from binaries where binaries.sha1 in (select distinct(nodes.sha1_actual) from nodes where repo = '<REPOSITORY_NAME>');The output would be in the following format (in bytes),
sum ------------ 6524390 (1 row)