...
Count | Size |
|---|---|
2198971 | 8286060045314 (7.5TB) |
Synapse Storage Report
From the synapse storage report that is generated monthly and stored in a synapse table we can get an idea of how much data is used by synapse entities in projects, the following query gets the aggregated sum of the size in bytes for the last 10 months:
SELECT `Date`, SUM(sizeInBytes) FROM syn18406644 GROUP BY `Date` ORDER BY `Date` DESC LIMIT 10
Date | SUM(sizeInBytes) |
|---|---|
11/07/2020 8:19 AM | 625884553013513 (569TB) |
10/07/2020 9:19 AM | 601258482253040 |
09/07/2020 9:18 AM | 582341331814681 |
08/07/2020 9:17 AM | 578802072068115 |
07/07/2020 9:16 AM | 571523659700716 |
06/07/2020 9:16 AM | 565440327890856 |
05/07/2020 9:15 AM | 553787060613178 |
04/07/2020 9:14 AM | 548567403971529 |
03/07/2020 8:14 AM | 515099665980791 |
02/07/2020 8:13 AM | 496359704897457 |
Note that this report does not account for file handles that are referenced in tables or other objects or file handles that are not linked to anything which seem to account for about 70TB of data.
Multipart Uploads
In prod we do not clean up unfinished multipart uploads, the following script was used to fetch some statistics about those:
...