Skip to content

Instantly share code, notes, and snippets.

@Krinkle
Last active October 19, 2018 04:25
Show Gist options
  • Save Krinkle/20b0f1cb4800aaa446f2ec0a213c2ccd to your computer and use it in GitHub Desktop.
Save Krinkle/20b0f1cb4800aaa446f2ec0a213c2ccd to your computer and use it in GitHub Desktop.
Aggregated data from the access logs of the GUC tool at Wikimedia Toolforge.
03/Feb/2018 1007
04/Feb/2018 1053
05/Feb/2018 1102
06/Feb/2018 1231
07/Feb/2018 1198
08/Feb/2018 1174
09/Feb/2018 1115
10/Feb/2018 1030
11/Feb/2018 1266
12/Feb/2018 1065
13/Feb/2018 1095
14/Feb/2018 1144
15/Feb/2018 1400
16/Feb/2018 1260
17/Feb/2018 1060
18/Feb/2018 1268
19/Feb/2018 1192
20/Feb/2018 1167
21/Feb/2018 1410
22/Feb/2018 1338
23/Feb/2018 1233
24/Feb/2018 1464
25/Feb/2018 1255
26/Feb/2018 1359
27/Feb/2018 1308
28/Feb/2018 1268
01/Mar/2018 1056
02/Mar/2018 1049
03/Mar/2018 1182
04/Mar/2018 1051
05/Mar/2018 1194
06/Mar/2018 1197
07/Mar/2018 906
08/Mar/2018 1024
09/Mar/2018 1159
10/Mar/2018 1153
11/Mar/2018 1057
12/Mar/2018 1200
13/Mar/2018 1157
14/Mar/2018 1267
15/Mar/2018 961
16/Mar/2018 993
17/Mar/2018 986
18/Mar/2018 1049
19/Mar/2018 1026
20/Mar/2018 999
21/Mar/2018 1075
22/Mar/2018 990
23/Mar/2018 1100
24/Mar/2018 998
25/Mar/2018 1126
26/Mar/2018 1124
27/Mar/2018 1375
28/Mar/2018 1029
29/Mar/2018 955
30/Mar/2018 1299
31/Mar/2018 1049
01/Apr/2018 845
02/Apr/2018 916
03/Apr/2018 1031
04/Apr/2018 1145
05/Apr/2018 1029
06/Apr/2018 985
07/Apr/2018 844
08/Apr/2018 943
09/Apr/2018 1125
10/Apr/2018 974
11/Apr/2018 931
12/Apr/2018 894
13/Apr/2018 560
07/Jun/2018 666
08/Jun/2018 681
09/Jun/2018 525
10/Jun/2018 610
11/Jun/2018 597
12/Jun/2018 586
13/Jun/2018 712
14/Jun/2018 665
15/Jun/2018 642
16/Jun/2018 608
17/Jun/2018 671
18/Jun/2018 679
19/Jun/2018 611
20/Jun/2018 672
21/Jun/2018 561
22/Jun/2018 593
23/Jun/2018 615
24/Jun/2018 553
25/Jun/2018 591
26/Jun/2018 635
27/Jun/2018 551
28/Jun/2018 550
29/Jun/2018 504
30/Jun/2018 498
01/Jul/2018 580
02/Jul/2018 618
03/Jul/2018 610
04/Jul/2018 624
05/Jul/2018 543
06/Jul/2018 526
07/Jul/2018 450
08/Jul/2018 521
09/Jul/2018 548
10/Jul/2018 594
11/Jul/2018 552
12/Jul/2018 538
13/Jul/2018 525
14/Jul/2018 540
15/Jul/2018 597
16/Jul/2018 577
17/Jul/2018 571
18/Jul/2018 538
19/Jul/2018 566
20/Jul/2018 531
21/Jul/2018 524
22/Jul/2018 442
23/Jul/2018 524
24/Jul/2018 500
25/Jul/2018 581
26/Jul/2018 544
27/Jul/2018 458
28/Jul/2018 430
29/Jul/2018 507
30/Jul/2018 594
31/Jul/2018 640
01/Aug/2018 549
02/Aug/2018 443
03/Aug/2018 455
04/Aug/2018 488
05/Aug/2018 494
06/Aug/2018 501
07/Aug/2018 546
08/Aug/2018 537
09/Aug/2018 552
10/Aug/2018 463
11/Aug/2018 453
12/Aug/2018 505
13/Aug/2018 527
14/Aug/2018 570
15/Aug/2018 572
16/Aug/2018 487
17/Aug/2018 537
18/Aug/2018 457
19/Aug/2018 539
20/Aug/2018 558
21/Aug/2018 525
22/Aug/2018 508
23/Aug/2018 577
24/Aug/2018 495
25/Aug/2018 483
26/Aug/2018 571
27/Aug/2018 537
28/Aug/2018 517
29/Aug/2018 517
30/Aug/2018 556
31/Aug/2018 521
01/Sep/2018 414
02/Sep/2018 496
03/Sep/2018 455
04/Sep/2018 484
05/Sep/2018 439
06/Sep/2018 412
07/Sep/2018 460
08/Sep/2018 502
09/Sep/2018 432
10/Sep/2018 510
11/Sep/2018 457
12/Sep/2018 391
13/Sep/2018 501
14/Sep/2018 471
15/Sep/2018 499
16/Sep/2018 506
17/Sep/2018 352
03/Feb/2018 4652
04/Feb/2018 4680
05/Feb/2018 5914
06/Feb/2018 5613
07/Feb/2018 6324
08/Feb/2018 5243
09/Feb/2018 4425
10/Feb/2018 5140
11/Feb/2018 5020
12/Feb/2018 5025
13/Feb/2018 5219
14/Feb/2018 5952
15/Feb/2018 6213
16/Feb/2018 6263
17/Feb/2018 7988
18/Feb/2018 7353
19/Feb/2018 9412
20/Feb/2018 9294
21/Feb/2018 7900
22/Feb/2018 7419
23/Feb/2018 7375
24/Feb/2018 8294
25/Feb/2018 7504
26/Feb/2018 6327
27/Feb/2018 6061
28/Feb/2018 5698
01/Mar/2018 4850
02/Mar/2018 4793
03/Mar/2018 5222
04/Mar/2018 6984
05/Mar/2018 5245
06/Mar/2018 5643
07/Mar/2018 4426
08/Mar/2018 4917
09/Mar/2018 5266
10/Mar/2018 5336
11/Mar/2018 6383
12/Mar/2018 10789
13/Mar/2018 11351
14/Mar/2018 17666
15/Mar/2018 27175
16/Mar/2018 19555
17/Mar/2018 7333
18/Mar/2018 7769
19/Mar/2018 7324
20/Mar/2018 5887
21/Mar/2018 6186
22/Mar/2018 5908
23/Mar/2018 6915
24/Mar/2018 6531
25/Mar/2018 5513
26/Mar/2018 5384
27/Mar/2018 6487
28/Mar/2018 5042
29/Mar/2018 5120
30/Mar/2018 5400
31/Mar/2018 4916
01/Apr/2018 4700
02/Apr/2018 5512
03/Apr/2018 5201
04/Apr/2018 5819
05/Apr/2018 8085
06/Apr/2018 9702
07/Apr/2018 14037
08/Apr/2018 14997
09/Apr/2018 34809
10/Apr/2018 7831
11/Apr/2018 5867
12/Apr/2018 4775
13/Apr/2018 2747
07/Jun/2018 3912
08/Jun/2018 3998
09/Jun/2018 3833
10/Jun/2018 4004
11/Jun/2018 3574
12/Jun/2018 3937
13/Jun/2018 4421
14/Jun/2018 4474
15/Jun/2018 3656
16/Jun/2018 4627
17/Jun/2018 6024
18/Jun/2018 6413
19/Jun/2018 5113
20/Jun/2018 5406
21/Jun/2018 4730
22/Jun/2018 4992
23/Jun/2018 4961
24/Jun/2018 4872
25/Jun/2018 4724
26/Jun/2018 3648
27/Jun/2018 3487
28/Jun/2018 3295
29/Jun/2018 3677
30/Jun/2018 3514
01/Jul/2018 4137
02/Jul/2018 3855
03/Jul/2018 4676
04/Jul/2018 3820
05/Jul/2018 4062
06/Jul/2018 3749
07/Jul/2018 4078
08/Jul/2018 4142
09/Jul/2018 4726
10/Jul/2018 6779
11/Jul/2018 3913
12/Jul/2018 3586
13/Jul/2018 3698
14/Jul/2018 4114
15/Jul/2018 3816
16/Jul/2018 4085
17/Jul/2018 4055
18/Jul/2018 3650
19/Jul/2018 4801
20/Jul/2018 4251
21/Jul/2018 4479
22/Jul/2018 3953
23/Jul/2018 5347
24/Jul/2018 5557
25/Jul/2018 4114
26/Jul/2018 3096
27/Jul/2018 2904
28/Jul/2018 4072
29/Jul/2018 4026
30/Jul/2018 6518
31/Jul/2018 5484
01/Aug/2018 5075
02/Aug/2018 5246
03/Aug/2018 4921
04/Aug/2018 23463
05/Aug/2018 6002
06/Aug/2018 17038
07/Aug/2018 3579
08/Aug/2018 10284
09/Aug/2018 13383
10/Aug/2018 5777
11/Aug/2018 3079
12/Aug/2018 2799
13/Aug/2018 3249
14/Aug/2018 4685
15/Aug/2018 3770
16/Aug/2018 3181
17/Aug/2018 3444
18/Aug/2018 3646
19/Aug/2018 3243
20/Aug/2018 3399
21/Aug/2018 3122
22/Aug/2018 3316
23/Aug/2018 3170
24/Aug/2018 3818
25/Aug/2018 4089
26/Aug/2018 5144
27/Aug/2018 4488
28/Aug/2018 6363
29/Aug/2018 8619
30/Aug/2018 10103
31/Aug/2018 4628
01/Sep/2018 3864
02/Sep/2018 3631
03/Sep/2018 3489
04/Sep/2018 2899
05/Sep/2018 2898
06/Sep/2018 3019
07/Sep/2018 4244
08/Sep/2018 4022
09/Sep/2018 4153
10/Sep/2018 4841
11/Sep/2018 4140
12/Sep/2018 3754
13/Sep/2018 3626
14/Sep/2018 3186
15/Sep/2018 4171
16/Sep/2018 3723
17/Sep/2018 2020

All

$ cat access.log | sed 's/[^\[]*\[//; s/\:.*$//' | uniq -c

Post

$ cat access.log | grep -F ' "POST /guc' | sed 's/[^\[]*\[//; s/\:.*$//' | uniq -c

Replacement

Find:     ^\s+(\d+) (.+)$
Replace:  $2\t$1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment