Many wikis have many times more wikidata-injected rows in rc table than edit rows. For example in arwiki, there are 2.4 times more wikidata rows in rc table than edits (many other large wikis are not much better, ukwiki is 3.2 times, nowiki is 7 times, etc.). The list of worst offenders can be found in P78713. I did a quick investigation and many of such rows shouldn't be injected in the first place:
>>! In T396489#10952410, @Ladsgroup wrote:
> Regarding the rows coming from wikibase, I looked at arwiki that has around 760K rows from wikidata (2.3 times the actual number of edits in the wiki). I found a couple of issues:
> - O aspect and aliases. Somehow many pages are subscribing to the O aspect and as result, they are getting all alias changes for that item even in languages that has nothing to do with them. That alone is responsible for ~20% of wikidata injected rows.
> - Statement modifier collapse is a problem. C.P1, ..., collapse to C in general after twenty statements (I think 20, not sure). This is causing a lot of random edits on statements being injected on rc We probably should bump the threshold a bit.
> - Changes to qualifiers and references. They are also triggering a lot of injections while they don't change anything (and I don't think client wikis actually load the references, at least it's quite rare AFAIK). That alone is also responsible for another 20% of rows being injected.
This is drastically contributing to large set of slow queries in recentchanges tables (plus queries being killed for being too slow meaning user-facing impact) and it's also makes them so noisy that people don't check them anymore.