Page MenuHomePhabricator

Compute metrics required for the Q3 QCI
Closed, ResolvedPublic

Description

Edit summary lengths
  • # of edit summaries greater than 255 bytes for:
  • English: 47473
  • Russian: 28871
  • Malayalam: 3898
  • Spanish: 11096
  • German: 15595
  • Hebrew: 8716
  • Arabic: 16312
  • Hindi: 4052
Edit summary pings
  • # of edit summaries containing user pings for:
  • English:
  • ?
  • # of users who are using the feature for:
  • English:
  • ?
Thanks notifications
  • # of actions that can get thanked now for:
  • English:
  • ?
  • # Comparison of number of thanks sent before and after the project for:
  • English:
  • ?
Global Preferences
  • # of users who edit on multiple wikis: I don't think this is straightforward to query for.
CodeMirror
  • # of people using it in beta for:
  • English: 21,054
  • Spanish: 2564
  • German: 2498
  • French: 2296
  • Russian: 2717
  • Hindi: 145
  • Malayalam: 66
Grant metrics
  • # of organizers: 66
  • # of programs created: 37
  • # of events created: 62
  • total # of participants so far: 1777

(note that this data will potentially include any that we have created for testing purposes)

Event Timeline

Edit summaries greater than 255 bytes, since the time when edit summaries longer than 255 characters were allowed.

wikiadmin@db1080(enwiki)>select COUNT(*) from comment WHERE LENGTH(comment_text) > 255;
+----------+
| COUNT(*) |
+----------+
|    47473 |
+----------+
wikiadmin@db1093(ruwiki)>select COUNT(*) from comment WHERE LENGTH(comment_text) > 255;
+----------+
| COUNT(*) |
+----------+
|    28871 |
+----------+
wikiadmin@db1077(mlwiki)>select COUNT(*) from comment WHERE LENGTH(comment_text) > 255;
+----------+
| COUNT(*) |
+----------+
|     3898 |
+----------+
wikiadmin@db1079(eswiki)>select COUNT(*) from comment WHERE LENGTH(comment_text) > 255;
+----------+
| COUNT(*) |
+----------+
|    11096 |
+----------+
wikiadmin@db1082(dewiki)>select COUNT(*) from comment WHERE LENGTH(comment_text) > 255;
+----------+
| COUNT(*) |
+----------+
|    15595 |
+----------+
wikiadmin@db1094(hewiki)>select COUNT(*) from comment WHERE LENGTH(comment_text) > 255;
+----------+
| COUNT(*) |
+----------+
|     8716 |
+----------+
wikiadmin@db1079(arwiki)>select COUNT(*) from comment WHERE LENGTH(comment_text) > 255;
+----------+
| COUNT(*) |
+----------+
|    16312 |
+----------+
wikiadmin@db1078(hiwiki)>select COUNT(*) from comment WHERE LENGTH(comment_text) > 255;
+----------+
| COUNT(*) |
+----------+
|     4052 |
+----------+

Thanks stats on enwiki since March:

wikiadmin@db1089(enwiki)>select count(*) as times, substring(log_timestamp, 1, 8) as date from logging where log_type='thanks' and substring(log_timestamp, 1, 8) >= '20180301' group by substring(log_timestamp, 1, 8);
+-------+----------+
| times | date     |
+-------+----------+
|  1069 | 20180301 |
|   904 | 20180302 |
|   967 | 20180303 |
|   993 | 20180304 |
|  1015 | 20180305 |
|  1082 | 20180306 |
|  1081 | 20180307 |
|  1085 | 20180308 |
|   973 | 20180309 |
|   852 | 20180310 |
|   949 | 20180311 |
|  1136 | 20180312 |
|  1051 | 20180313 |
|  1007 | 20180314 |
|  1028 | 20180315 |
|  1006 | 20180316 |
|   799 | 20180317 |
|   903 | 20180318 |
|   987 | 20180319 |
|  1038 | 20180320 |
|  1074 | 20180321 |
|   957 | 20180322 |
|   966 | 20180323 |
|   961 | 20180324 |
|   767 | 20180325 |
|   941 | 20180326 |
|  1073 | 20180327 |
|  1004 | 20180328 |
|   967 | 20180329 |
|   887 | 20180330 |
|   916 | 20180331 |
|   946 | 20180401 |
|  1024 | 20180402 |
|  1109 | 20180403 |
|   989 | 20180404 |
|   962 | 20180405 |
|  1019 | 20180406 |
|   894 | 20180407 |
|   987 | 20180408 |
|  1071 | 20180409 |
|  1070 | 20180410 |
|  1144 | 20180411 |
|  1031 | 20180412 |
|  1002 | 20180413 |
|   874 | 20180414 |
|   967 | 20180415 |
|  1026 | 20180416 |
|  1042 | 20180417 |
|   980 | 20180418 |
|  1063 | 20180419 |
|  1081 | 20180420 |
|  1081 | 20180421 |
|   807 | 20180422 |
|   993 | 20180423 |
|  1112 | 20180424 |
|  1040 | 20180425 |
|   950 | 20180426 |
+-------+----------+

It got deployed on April 5.

Edit summary pings.

wikiadmin@db1085(frwiki)>select count(*) from revision where rev_comment like '%[[Utilisateur:%';
+----------+
| count(*) |
+----------+
|  1009165 |
+----------+
wikiadmin@db1085(frwiki)>select count(*) from revision where rev_comment like '%[[Utilisateur:%' and substring(rev_timestamp, 1, 8) > 20180315;
+----------+
| count(*) |
+----------+
|    32596 |
+----------+
wikiadmin@db1094(eswiki)>select count(*) from revision where rev_comment like '%[[Usuario:%';
+----------+
| count(*) |
+----------+
|  1094848 |
+----------+
1 row in set (43.30 sec)

wikiadmin@db1094(eswiki)>select count(*) from revision where rev_comment like '%[[Usuario:%' and substring(rev_timestamp, 1, 8) > 20180315;
+----------+
| count(*) |
+----------+
|     5602 |
+----------+
wikiadmin@db1110(dewiki)>select count(*) from revision where rev_comment like '%[[Benutzer:%';
+----------+
| count(*) |
+----------+
|  3990704 |
+----------+
1 row in set (46.07 sec)

wikiadmin@db1110(dewiki)>select count(*) from revision where rev_comment like '%[[Benutzer:%' and substring(rev_timestamp, 1, 8) > 20180315;
+----------+
| count(*) |
+----------+
|    31432 |
+----------+
1 row in set (47.18 sec)
wikiadmin@db1094(hewiki)>select count(*) from revision where rev_comment like '%[[משתמש:%';
+----------+
| count(*) |
+----------+
|   150927 |
+----------+
1 row in set (8.24 sec)

wikiadmin@db1094(hewiki)>select count(*) from revision where rev_comment like '%[[משתמש:%' and substring(rev_timestamp, 1, 8) > 20180315;
+----------+
| count(*) |
+----------+
|      880 |
+----------+
1 row in set (8.12 sec)

wikiadmin@db1094(hewiki)>select count(*) from revision where rev_comment like '%[[User:%';
+----------+
| count(*) |
+----------+
|   347734 |
+----------+
1 row in set (7.67 sec)

wikiadmin@db1094(hewiki)>select count(*) from revision where rev_comment like '%[[User:%' and substring(rev_timestamp, 1, 8) > 20180315;
+----------+
| count(*) |
+----------+
|        6 |
+----------+
1 row in set (9.11 sec)
wikiadmin@db1089(enwiki)>select count(*) from revision where rev_comment like '%[[User:%' and substring(rev_timestamp, 1, 8) > 20180315;
+----------+
| count(*) |
+----------+
|   554453 |
+----------+
1 row in set (5 min 53.76 sec)

@Niharika Did you excluded undos and rollbacks from the stats? The numbers look tad high to me.

@MarcoAurelio Yeah. This number includes bot pings, script pings, rollbacks etc. We don't need very precise data for this so I'm doing a quick job of it. :)

Count of users who have a user property for language set i.e. number of people who have an interface language set which is other than the local language for the wiki:

wikiadmin@db1089(enwiki)>select count(*) from user_properties where up_property='language';
+----------+
| count(*) |
+----------+
|   569822 |
+----------+
wikiadmin@db1110(dewiki)>select count(*) from user_properties where up_property='language';
+----------+
| count(*) |
+----------+
|    31818 |
+----------+
wikiadmin@db1079(eswiki)>select count(*) from user_properties where up_property='language';
+----------+
| count(*) |
+----------+
|    38920 |
+----------+
wikiadmin@db1078(hiwiki)>select count(*) from user_properties where up_property='language';
+----------+
| count(*) |
+----------+
|    17512 |
+----------+
wikiadmin@db1088(frwiki)>select count(*) from user_properties where up_property='language';
+----------+
| count(*) |
+----------+
|    38855 |
+----------+
wikiadmin@db1079(arwiki)>select count(*) from user_properties where up_property='language';
+----------+
| count(*) |
+----------+
|    26485 |
+----------+
wikiadmin@db1076(zhwiki)>select count(*) from user_properties where up_property='language';
+----------+
| count(*) |
+----------+
|  1194026 |. --------WHAT?
+----------+

I decided to drill down in that data anomaly there. Fun!

wikiadmin@db1076(zhwiki)>select count(*) as cnt, up_value from user_properties where up_property='language' group by up_value;
+--------+--------------+
| cnt    | up_value     |
+--------+--------------+
|      1 |              |
|     60 | aa           |
|      8 | ab           |
|      5 | af           |
|      1 | aln          |
|      3 | als          |
|      2 | am           |
|      1 | an           |
|      1 | ang          |
|     47 | ar           |
|      1 | ary          |
|      2 | arz          |
|      3 | ase          |
|      3 | ast          |
|      1 | az           |
|      1 | be           |
|      8 | bg           |
|      5 | bn           |
|     22 | bo           |
|      1 | brokedata    |
|      3 | bs           |
|     11 | ca           |
|      1 | cbk-zam      |
|      1 | cdo          |
|      1 | ceb          |
|      1 | chr          |
|      1 | crh          |
|     39 | cs           |
|      1 | cv           |
|      1 | cy           |
|     16 | da           |
|    846 | de           |
|     14 | de-at        |
|      2 | de-ch        |
|     35 | de-formal    |
|      1 | diq          |
|      1 | dk           |
|      4 | egl          |
|      9 | el           |
|  29380 | en           |
|     70 | en-ca        |
|    671 | en-gb        |
|      1 | enquery=     |
|     11 | eo           |
|    354 | es           |
|      4 | et           |
|     18 | fa           |
|      1 | ff           |
|     28 | fi           |
|      2 | fo           |
|    716 | fr           |
|      5 | frc          |
|      9 | frp          |
|      6 | fur          |
|      2 | fy           |
|      2 | ga           |
|      4 | gan          |
|     11 | gan-hans     |
|     11 | gan-hant     |
|      1 | gd           |
|      7 | gl           |
|      8 | glk          |
|      1 | gn           |
|      4 | got          |
|      4 | grc          |
|      3 | gsw          |
|      1 | gu           |
|      1 | gv           |
|      2 | ha           |
|      3 | hak          |
|      9 | he           |
|      8 | hi           |
|      1 | hif          |
|      1 | hif-latn     |
|      2 | hil          |
|      1 | ho           |
|      4 | hr           |
|     20 | hu           |
|      7 | hy           |
|      1 | ia           |
|     42 | id           |
|      2 | ii           |
|    242 | it           |
|   2226 | ja           |
|      1 | ka           |
|      1 | kg           |
|      3 | kk           |
|      4 | kk-arab      |
|      9 | kk-cyrl      |
|      2 | kk-kz        |
|      1 | kk-latn      |
|      8 | km           |
|    547 | ko           |
|      8 | ko-kp        |
|      3 | la           |
|      1 | lad          |
|      3 | lb           |
|      2 | lfn          |
|      2 | li           |
|      1 | lo           |
|      1 | lt           |
|      1 | lv           |
|     24 | lzh          |
|      2 | mg           |
|      2 | mk           |
|      5 | ml           |
|     12 | mn           |
|      1 | mr           |
|    117 | ms           |
|      9 | my           |
|      1 | mzn          |
|      3 | nan          |
|      1 | nds          |
|      1 | nds-nl       |
|     58 | nl           |
|      3 | nl-informal  |
|      5 | nn           |
|     17 | no           |
|      1 | nov          |
|      1 | oc           |
|      1 | pdc          |
|     99 | pl           |
|     71 | pt           |
|     47 | pt-br        |
|      1 | qug          |
|      7 | ro           |
|      1 | roa-tara     |
|    358 | ru           |
|      1 | sco          |
|      2 | si           |
|     34 | simple       |
|      8 | sk           |
|      5 | sl           |
|      1 | so           |
|      3 | sq           |
|     10 | sr           |
|      1 | sr-ec        |
|      1 | stq          |
|     35 | sv           |
|      1 | sw           |
|      1 | te           |
|      1 | tg-latn      |
|     81 | th           |
|     18 | tr           |
|      1 | tt           |
|      5 | tw           |
|      1 | udm          |
|     15 | ug           |
|     21 | ug-arab      |
|      4 | ug-latn      |
|     28 | uk           |
|      1 | ur           |
|      1 | uz           |
|      2 | vec          |
|    102 | vi           |
|      1 | vmf          |
|      1 | vro          |
|      2 | wa           |
|      1 | war          |
|     66 | wuu          |
|      5 | xal          |
|      1 | xmf          |
|      3 | yi           |
|    561 | yue          |
|      2 | za           |
|      1 | zea          |
|    384 | zh           |
|      1 | zh-          |
|     35 | zh-ch        |
|    129 | zh-classical |
| 481332 | zh-cn        |
|     17 | zh-ha        |
|  94450 | zh-hans      |
|  53359 | zh-hant      |
|  79651 | zh-hk        |
|     11 | zh-min-nan   |
|    514 | zh-mo        |
|    172 | zh-my        |
|   1672 | zh-sg        |
| 444319 | zh-tw        |
|    406 | zh-yue       |
|     29 | zu           |
+--------+--------------+
182 rows in set (25.16 sec)
TBolliger moved this task from Ready to Q1 2018-19 on the Community-Tech-Sprint board.

Done! Thank you!

Vvjjkkii renamed this task from Compute metrics required for the Q3 QCI to 67daaaaaaa.Jul 1 2018, 1:13 AM
Vvjjkkii reopened this task as Open.
Vvjjkkii removed Niharika as the assignee of this task.
Vvjjkkii triaged this task as High priority.
Vvjjkkii updated the task description. (Show Details)
Vvjjkkii removed subscribers: MarcoAurelio, Aklapper.
1339861mzb renamed this task from 67daaaaaaa to Compute metrics required for the Q3 QCI .Jul 1 2018, 10:29 AM
1339861mzb updated the task description. (Show Details)
1339861mzb updated the task description. (Show Details)