root@db1115.eqiad.wmnet[zarcillo]> select SUBSTRING_INDEX(file_name, '.', 1) as db, sum(size) as size FROM backup_files WHERE backup_id = 1862 and file_name not like '%-schema-create.sql.gz' GROUP BY db ORDER BY size desc LIMIT 20;
+---------------+------------+
| db            | size       |
+---------------+------------+
| mediawikiwiki | 4539665654 |
| loginwiki     | 2829553543 |
| plwiktionary  | 2358407852 |
| ruwiktionary  | 2355786729 |
| frwikisource  | 2315194029 |
| dewiktionary  | 2192119974 |
| enwikisource  | 1933894489 |
| dawiki        | 1818772589 |
| sourceswiki   | 1795213418 |
| dewikivoyage  | 1495157942 |
| skwiki        | 1449949778 |
| euwiki        | 1377163347 |
| elwiki        | 1371151371 |
| bewiki        | 1303039764 |
| enwikinews    | 1267055352 |
| simplewiki    | 1266661189 |
| specieswiki   | 1241517305 |
| ruwikisource  | 1218843714 |
| hywiki        | 1213727020 |
| slwiki        | 1212863732 |
+---------------+------------+
20 rows in set (0.20 sec)

root@db1115.eqiad.wmnet[zarcillo]> select SUBSTRING_INDEX(file_name, '.', 1) as db, sum(size) as size FROM backup_files WHERE backup_id = 1866 and file_name not like '%-schema-create.sql.gz' GROUP BY db ORDER BY size desc LIMIT 20;
+---------------+------------+
| db            | size       |
+---------------+------------+
| mediawikiwiki | 4539656355 |
| loginwiki     | 2829590706 |
| plwiktionary  | 2358419554 |
| ruwiktionary  | 2355797164 |
| frwikisource  | 2315213285 |
| dewiktionary  | 2204128063 |
| enwikisource  | 1933912943 |
| dawiki        | 1818751991 |
| sourceswiki   | 1795214102 |
| dewikivoyage  | 1495165313 |
| skwiki        | 1449944125 |
| elwiki        | 1371124258 |
| euwiki        | 1371034939 |
| bewiki        | 1303054008 |
| enwikinews    | 1267056284 |
| simplewiki    | 1266639862 |
| hywiki        | 1247715009 |
| specieswiki   | 1241538353 |
| ruwikisource  | 1218846265 |
| slwiki        | 1212866336 |
+---------------+------------+
20 rows in set (0.21 sec)