Page MenuHomePhabricator

Get some statistics from CheckUser log
Closed, ResolvedPublic2 Estimated Story Points

Description

CheckUser log uses six distinct log messages for its CU log.

"checkuser-log-entry-userips": "$3, $1 got IP addresses for $2",
"checkuser-log-entry-ipedits": "$3, $1 got edits for <bdi>$2</bdi>",
"checkuser-log-entry-ipusers": "$3, $1 got users for <bdi>$2</bdi>",
"checkuser-log-entry-ipedits-xff": "$3, $1 got edits for XFF <bdi>$2</bdi>",
"checkuser-log-entry-ipusers-xff": "$3, $1 got users for XFF <bdi>$2</bdi>",
"checkuser-log-entry-useredits": "$3, $1 got edits for $2",

We want to see how often each of these show up in the logs, which in turn tells us about which features are used most and least frequently.

Acceptance criteria:

For the following wikis:

  • enwiki
  • eswiki
  • fawiki
  • zhwiki
  • jawiki

generate stats for how often were the different log messages used till date.

You can put the stats in this ticket. Access is restricted to our team members.

Event Timeline

Niharika triaged this task as Medium priority.Sep 30 2019, 11:44 PM
Niharika created this task.
Niharika created this object with visibility "Custom Policy".
Niharika changed the edit policy from "All Users" to "Subscribers".Sep 30 2019, 11:50 PM
Niharika set the point value for this task to 2.Oct 3 2019, 6:20 PM

I'd suggest eswiki, potentially zhwiki as a known outlier that relies entirely on steward CU work (but is of a comparable size to wikis with medium-sized local CU groups).

Niharika changed the visibility from "Custom Policy" to "All Users".Oct 22 2019, 2:35 PM
dbarratt shifted this object from the S1 Public space to the Restricted Space space.Oct 25 2019, 2:18 PM
dbarratt changed the visibility from "All Users" to "Public (No Login Required)".

Here is the query used to generate the statistics:

SELECT cul_type,  COUNT(cul_type) AS count FROM cu_log GROUP BY cul_type;

And here are the results:

enwiki

cul_typecount
ipedits153583
ipedits-xff2011
ipusers207858
ipusers-xff1975
useredits21366
userips215872

eswiki

cul_typecount
ipedits13484
ipedits-xff68
ipusers18294
ipusers-xff47
useredits849
userips18170

fawiki

cul_typecount
ipedits878
ipedits-xff18
ipusers3270
ipusers-xff115
useredits1236
userips2478

zhwiki

cul_typecount
ipedits4328
ipedits-xff39
ipusers9008
ipusers-xff65
useredits946
userips8962

jawiki

cul_typecount
ipedits42650
ipedits-xff742
ipusers49183
ipusers-xff837
useredits3227
userips60193
Niharika shifted this object from the Restricted Space space to the S1 Public space.Nov 6 2019, 7:44 PM