lucaswerkmeister-wmde@stat1007:~$ sudo -u analytics-wmde analytics-mysql cebwiki <<< 'SELECT table_name, table_rows FROM information_schema.tables WHERE table_schema = "cebwiki" AND table_name IN ("wbc_entity_usage", "recentchanges");' | expand -t20
table_name          table_rows
recentchanges       841431
wbc_entity_usage    13725390

MariaDB [cebwiki]> SELECT NOW() AS asof, COUNT(*) AS total, SUM(eu_aspect LIKE 'C%') AS statements, SUM(eu_aspect LIKE 'O%') AS others FROM wbc_entity_usage;
+---------------------+----------+------------+---------+
| asof                | total    | statements | others  |
+---------------------+----------+------------+---------+
| 2022-03-09 16:16:25 | 15229870 |          0 | 4797898 |
+---------------------+----------+------------+---------+
1 row in set (6.703 sec)

MariaDB [cebwiki]> SELECT NOW() AS asof, COUNT(*) AS total, SUM(eu_aspect LIKE 'C%') AS statements, SUM(eu_aspect LIKE 'O%') AS others FROM wbc_entity_usage;
+---------------------+----------+------------+---------+
| asof                | total    | statements | others  |
+---------------------+----------+------------+---------+
| 2022-08-02 10:29:47 | 15038456 |          0 | 4780944 |
+---------------------+----------+------------+---------+
1 row in set (16.876 sec)

MariaDB [cebwiki]> SELECT NOW() AS asof, COUNT(*) AS total, SUM(rc_type = 5 /* RC_EXTERNAL */) AS fromwikidata FROM recentchanges;
+---------------------+--------+--------------+
| asof                | total  | fromwikidata |
+---------------------+--------+--------------+
| 2022-08-02 10:34:10 | 144266 |       136686 |
+---------------------+--------+--------------+
1 row in set (0.070 sec)

MariaDB [cebwiki]> SELECT NOW() AS asof, COUNT(*) AS total, SUM(eu_aspect LIKE 'C%') AS statements, SUM(eu_aspect LIKE 'O%') AS others FROM wbc_entity_usage;
+---------------------+----------+------------+--------+
| asof                | total    | statements | others |
+---------------------+----------+------------+--------+
| 2022-08-29 10:37:54 | 28565735 |   17755420 | 551913 |
+---------------------+----------+------------+--------+
1 row in set (9.765 sec)

MariaDB [cebwiki]> SELECT NOW() AS asof, COUNT(*) AS total, SUM(rc_type = 5 /* RC_EXTERNAL */) AS fromwikidata FROM recentchanges;
+---------------------+--------+--------------+
| asof                | total  | fromwikidata |
+---------------------+--------+--------------+
| 2022-08-29 10:38:08 | 170182 |       166925 |
+---------------------+--------+--------------+
1 row in set (0.102 sec)

MariaDB [cebwiki]> SELECT NOW() AS asof, COUNT(*) AS total, SUM(eu_aspect LIKE 'C%') AS statements, SUM(eu_aspect LIKE 'O%') AS others FROM wbc_entity_usage;
+---------------------+----------+------------+--------+
| asof                | total    | statements | others |
+---------------------+----------+------------+--------+
| 2022-08-31 11:01:52 | 28402531 |   17755452 | 388666 |
+---------------------+----------+------------+--------+
1 row in set (9.727 sec)

$ units
Currency exchange rates from FloatRates (USD base) on 2020-11-15 
3677 units, 109 prefixes, 114 nonlinear units

You have: 388666 / ((551913 - 388666) / 24.5 hours)
You want: time
        2 day + 10 hr + 19 min + 50.63505 sec

MariaDB [cebwiki]> SELECT NOW() AS asof, COUNT(*) AS total, SUM(eu_aspect LIKE 'C%') AS statements, SUM(eu_aspect LIKE 'O%') AS others FROM wbc_entity_usage;
+---------------------+----------+------------+--------+
| asof                | total    | statements | others |
+---------------------+----------+------------+--------+
| 2022-09-12 09:12:07 | 28016614 |   17755028 |   4250 |
+---------------------+----------+------------+--------+
1 row in set (9.757 sec)
MariaDB [cebwiki]> SELECT NOW() AS asof, COUNT(*) AS total, SUM(eu_aspect LIKE 'C%') AS statements, SUM(eu_aspect LIKE 'O%') AS others FROM wbc_entity_usage;
+---------------------+----------+------------+--------+
| asof                | total    | statements | others |
+---------------------+----------+------------+--------+
| 2022-09-12 09:43:13 | 28016614 |   17755028 |   4250 |
+---------------------+----------+------------+--------+
1 row in set (9.852 sec)

(venv) lucaswerkmeister-wmde@tools-sgebastion-10:~/purge-other-usages$ ./purge-other-usages ceb.wikipedia.org '' 0
Processed up to P9395, 10621606.
Processed up to Q1020685, 9869118.
Processed up to Q1020939, 55358.
Processed up to Q103825, 10942920.
Processed up to Q103958, 10942920.
Processed up to Q104071, 10942920.
Processed up to Q106790, 10942920.
Processed up to Q107454, 9869118.
Processed up to Q107559, 9869118.
Processed up to Q111372, 10942920.
Processed up to Q111677, 10942920.
Processed up to Q12692, 10942920.
Processed up to Q12853, 9869118.
Processed up to Q12893, 9869118.
^CTraceback (most recent call last):
  File "./purge-other-usages", line 79, in <module>
    time.sleep(75)
KeyboardInterrupt

MariaDB [cebwiki]> SELECT NOW() AS asof, COUNT(*) AS total, SUM(eu_aspect LIKE 'C%') AS statements, SUM(eu_aspect LIKE 'O%') AS others FROM wbc_entity_usage;
+---------------------+----------+------------+--------+
| asof                | total    | statements | others |
+---------------------+----------+------------+--------+
| 2022-09-12 10:24:58 | 28016613 |   17755028 |   4249 |
+---------------------+----------+------------+--------+
1 row in set (9.862 sec)

MariaDB [cebwiki]> SELECT NOW() AS asof, COUNT(*) AS total, SUM(eu_aspect LIKE 'C%') AS statements, SUM(eu_aspect LIKE 'O%') AS others FROM wbc_entity_usage;
+---------------------+----------+------------+--------+
| asof                | total    | statements | others |
+---------------------+----------+------------+--------+
| 2022-09-13 08:59:18 | 28016659 |   17755039 |   4272 |
+---------------------+----------+------------+--------+
1 row in set (9.662 sec)

MariaDB [cebwiki]> SELECT eu_page_id, COUNT(*) FROM wbc_entity_usage WHERE eu_aspect LIKE 'O%' GROUP BY eu_page_id ORDER BY COUNT(*) DESC LIMIT 3;
+------------+----------+
| eu_page_id | COUNT(*) |
+------------+----------+
|   10942920 |     1737 |
|    9869118 |     1737 |
|      46428 |       17 |

SELECT eu_page_id, COUNT(*) FROM wbc_entity_usage USE INDEX (`eu_entity_id`) WHERE eu_aspect LIKE 'O%' GROUP BY eu_page_id ORDER BY COUNT(*) DESC LIMIT 25;

MariaDB [cebwiki]> SELECT NOW() AS asof, SUM(eu_aspect LIKE 'C.%') AS modifier, SUM(eu_aspect = 'C') AS general FROM wbc_entity_usage;
+---------------------+----------+---------+
| asof                | modifier | general |
+---------------------+----------+---------+
| 2022-09-13 10:18:21 | 17754901 |     138 |
+---------------------+----------+---------+
1 row in set (9.446 sec)