root@db1176.eqiad.wmnet[mediabackups]> START TRANSACTION; select count(*), status_name, backup_status_name FROM files JOIN wikis ON wikis.id = files.wiki JOIN backup_status ON backup_status.id = files.backup_status JOIN file_status ON files.status = file_status.id WHERE wiki=392 GROUP BY status, backup_status; select count(*), TIMESTAMPDIFF(MINUTE, '2021-09-03 07:30:00', max(backup_time)) as time, count(*)/ TIMESTAMPDIFF(SECOND, '2021-09-03 07:30:00', max(backup_time)) as speed from backups where wiki=392 and backup_time >= '2021-09-03 07:30:00'; select count(*), sum(size) from files where wiki=392 and backup_status=3; COMMIT;
Query OK, 0 rows affected (0.001 sec)

+----------+-------------+--------------------+
| count(*) | status_name | backup_status_name |
+----------+-------------+--------------------+
| 56824185 | public      | pending            |
|    18000 | public      | processing         |
| 19428001 | public      | backedup           |
|     3160 | public      | error              |
|      839 | public      | duplicate          |
|  5910460 | archived    | pending            |
|  6551674 | deleted     | pending            |
+----------+-------------+--------------------+
7 rows in set (2 min 32.894 sec)

+----------+------+---------+
| count(*) | time | speed   |
+----------+------+---------+
| 13157923 | 4532 | 48.3804 |
+----------+------+---------+
1 row in set (9.376 sec)

+----------+----------------+
| count(*) | sum(size)      |
+----------+----------------+
| 19428001 | 85480862272126 |
+----------+----------------+
1 row in set (23.009 sec)

Query OK, 0 rows affected (0.000 sec)