Umherirrender added a comment.
It is a bit slower (only 267k in 24h, not 352k in 24h):
MariaDB [warwiki_p]> SELECT NOW() AS asof, COUNT(*) AS total,
SUM(page_links_updated < '20220301182633') AS backlog FROM page INNER JOIN
templatelinks ON page_id = tl_from WHERE tl_namespace = 10 AND tl_title =
'Wikidata_image';
+---------------------+---------+---------+
| asof | total | backlog |
+---------------------+---------+---------+
| 2022-03-03 18:41:42 | 1140205 | 511570 |
+---------------------+---------+---------+
1 row in set (1.04 sec)
MariaDB [warwiki_p]> 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-03 18:41:46 | 3079103 | 1150208 | 500208 |
+---------------------+---------+------------+--------+
1 row in set (1.06 sec)
TASK DETAIL
https://phabricator.wikimedia.org/T296383
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: noarave, Umherirrender
Cc: Umherirrender, Ladsgroup, Aklapper, Lydia_Pintscher, hoo, Michael,
Marostegui, alaa, Lucas_Werkmeister_WMDE, Lmlmljs, karapayneWMDE, Invadibot,
maantietaja, Akuckartz, Nandana, lucamauri, Lahi, Gq86, GoranSMilovanovic,
QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, Wikidata-bugs, aude,
Addshore, Mbch331
_______________________________________________
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org
