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;