Page MenuHomePhabricator
Paste P4366

Revisions without parent ID in enwiki DB
ActivePublic

Authored by nshahquinn-wmf on Nov 4 2016, 12:46 AM.
Tags
None
Referenced Files
F4696313: Revisions without parent ID in enwiki DB
Nov 4 2016, 5:02 PM
F4694272: Revisions without parent ID in enwiki DB
Nov 4 2016, 1:25 AM
F4694227:
Nov 4 2016, 12:46 AM
Subscribers
None
# Revisions from the revision table #
select left(rev_timestamp, 6) as month, sum(rev_parent_id is not null) as parent, sum(rev_parent_id is null) as null_parent
from revision
group by left(rev_timestamp, 6);
month parent null_parent
200101 290 0
200102 710 0
200103 1377 0
200104 956 0
200105 1980 0
200106 1144 0
200107 2079 0
200108 3610 0
200109 6536 0
200110 10794 0
200111 16319 0
200112 24359 0
200201 17323 0
200202 54459 0
200203 24360 0
200204 20833 0
200205 19589 0
200206 29695 0
200207 33755 0
200208 60618 0
200209 84259 0
200210 109699 0
200211 63053 0
200212 99518 0
200301 91860 0
200302 80528 0
200303 87394 0
200304 90416 0
200305 112903 0
200306 117947 0
200307 138356 0
200308 156565 0
200309 141200 0
200310 152986 0
200311 200201 0
200312 222870 0
200401 220096 0
200402 311759 0
200403 443554 0
200404 407359 0
200405 422680 0
200406 563403 0
200407 603247 0
200408 643990 0
200409 679980 0
200410 745842 0
200411 951860 0
200412 937469 0
200501 804220 0
200502 793649 0
200503 1030958 0
200504 1302256 0
200505 1374003 0
200506 1520570 0
200507 1845927 0
200508 1997599 0
200509 1899940 0
200510 2259880 0
200511 2383143 0
200512 3247999 0
200601 3694883 0
200602 3580880 0
200603 4135757 0
200604 4015481 0
200605 4611150 0
200606 4593695 0
200607 4802300 0
200608 5414783 0
200609 4964558 0
200610 5433227 0
200611 5569367 0
200612 5610539 0
200701 6246742 0
200702 6164138 0
200703 6784566 0
200704 6786580 0
200705 6654662 0
200706 5919730 0
200707 5901036 0
200708 5797876 0
200709 5814992 0
200710 6225260 0
200711 5836827 0
200712 5715947 0
200801 6309842 0
200802 6107843 0
200803 6758217 0
200804 6290581 0
200805 6302530 0
200806 5909891 0
200807 5859887 0
200808 5878274 0
200809 6156437 0
200810 6268886 0
200811 5724423 0
200812 5620606 0
200901 6053717 0
200902 5754538 0
200903 6411099 0
200904 5731066 0
200905 6013202 0
200906 5554090 0
200907 5334119 0
200908 5403881 0
200909 5524238 0
200910 5581902 0
200911 5340875 0
200912 5884723 0
201001 5562725 0
201002 5285098 0
201003 5755241 0
201004 5699667 0
201005 5594565 0
201006 5398298 0
201007 5046828 0
201008 5312733 0
201009 5486447 0
201010 5707449 0
201011 5405560 0
201012 5083451 0
201101 5649340 0
201102 4864619 0
201103 4921778 0
201104 4741274 0
201105 4759692 0
201106 4880732 0
201107 4936665 0
201108 4945220 0
201109 5020750 0
201110 4730769 0
201111 4657159 0
201112 4990770 0
201201 5092519 0
201202 4875774 0
201203 5008924 0
201204 4811361 0
201205 5045098 0
201206 4465488 0
201207 4752621 0
201208 4734881 0
201209 4922928 0
201210 5094260 0
201211 4667634 0
201212 4609192 0
201301 4953187 0
201302 5136408 0
201303 6342349 0
201304 4613789 0
201305 4470318 0
201306 4285120 0
201307 4063348 0
201308 4107251 0
201309 3946996 0
201310 4180885 0
201311 4026977 0
201312 4349257 0
201401 4492618 0
201402 3982932 0
201403 4318005 0
201404 4116908 0
201405 4180585 0
201406 3848756 0
201407 4037269 0
201408 4051648 0
201409 3882179 0
201410 3964416 0
201411 3907543 0
201412 4133107 0
201501 4395446 0
201502 4017684 0
201503 4890957 0
201504 5507370 0
201505 4578239 0
201506 4268719 0
201507 4396293 0
201508 4629641 0
201509 4495747 0
201510 4691696 0
201511 4559917 0
201512 4302634 0
201601 4830935 0
201602 4804377 0
201603 5128030 0
201604 4901336 0
201605 4923566 0
201606 4501828 0
201607 4555143 0
201608 4561979 0
201609 4732497 0
201610 5088072 0
201611 529047 0
# Revisions from the archive table #
select left(ar_timestamp, 6) as month, sum(ar_parent_id is not null) as parent, sum(ar_parent_id is null) as null_parent
from enwiki.archive
group by left(ar_timestamp, 6);
month parent null_parent
200101 1 33
200102 10 87
200103 11 106
200104 2 32
200105 6 106
200106 10 79
200107 19 100
200108 17 180
200109 35 417
200110 41 616
200111 77 954
200112 155 1412
200201 73 315
200202 230 1957
200203 163 801
200204 85 603
200205 86 641
200206 84 667
200207 78 1131
200208 102 3399
200209 191 3033
200210 182 3048
200211 170 2739
200212 148 2721
200301 257 4177
200302 207 4773
200303 635 5313
200304 303 5315
200305 406 7105
200306 473 7803
200307 600 10292
200308 659 8170
200309 595 8077
200310 565 7741
200311 841 10414
200312 785 11729
200401 973 12754
200402 1282 24416
200403 2073 31851
200404 2553 28666
200405 2221 32107
200406 3606 67193
200407 3208 55010
200408 4162 62212
200409 4814 78945
200410 4984 81704
200411 5380 99724
200412 6342 131834
200501 5993 107236
200502 5783 101143
200503 7213 125234
200504 8965 146560
200505 10024 171978
200506 11229 189702
200507 13093 218022
200508 15745 255766
200509 13917 231661
200510 16122 302129
200511 20217 318215
200512 24011 406559
200601 27699 443033
200602 26985 462652
200603 32704 540060
200604 31744 526957
200605 34291 611166
200606 38240 601675
200607 40628 635614
200608 48994 706531
200609 41467 635854
200610 47116 674235
200611 47853 704332
200612 49502 697902
200701 52964 775826
200702 53443 760967
200703 56791 811204
200704 75939 1033523
200705 78723 924549
200706 59700 748238
200707 61977 711900
200708 58489 657514
200709 54598 611791
200710 58105 667286
200711 57892 624881
200712 59005 545328
200801 60780 574516
200802 55895 550407
200803 62559 564134
200804 68473 534581
200805 62298 539571
200806 63858 471136
200807 64669 415453
200808 61062 383205
200809 60650 379573
200810 67973 416964
200811 65391 357236
200812 63373 368690
200901 72081 370686
200902 77353 396765
200903 88575 423466
200904 68893 339270
200905 75235 332612
200906 72820 322030
200907 73146 330589
200908 71266 306273
200909 93194 351973
200910 73694 300116
200911 66727 277773
200912 71056 284218
201001 68725 302766
201002 67244 298791
201003 107880 326109
201004 75588 278561
201005 80311 266723
201006 79540 273934
201007 76382 247552
201008 83941 243881
201009 89948 227461
201010 88699 228622
201011 81141 221754
201012 81948 223113
201101 94189 241669
201102 86062 197713
201103 93205 202773
201104 92494 192519
201105 104466 195554
201106 98860 203487
201107 109753 200791
201108 136267 194873
201109 215687 251886
201110 128870 172766
201111 136512 164001
201112 242365 195001
201201 160713 156448
201202 232941 106859
201203 309845 0
201204 264379 0
201205 259117 0
201206 237744 0
201207 288698 0
201208 251621 0
201209 241862 0
201210 296669 0
201211 232980 0
201212 238644 0
201301 249987 0
201302 225995 0
201303 262100 0
201304 245291 0
201305 237154 0
201306 239042 0
201307 238711 0
201308 229396 0
201309 222197 0
201310 212230 0
201311 218885 0
201312 228428 0
201401 236144 0
201402 206745 0
201403 229809 0
201404 203521 0
201405 224732 0
201406 202456 0
201407 207778 0
201408 195934 0
201409 183763 0
201410 195169 0
201411 190964 0
201412 197719 0
201501 205336 0
201502 205543 0
201503 210920 0
201504 197921 0
201505 194026 0
201506 189261 0
201507 192063 0
201508 200083 0
201509 199015 0
201510 193314 0
201511 179937 0
201512 167617 0
201601 174029 0
201602 169088 0
201603 175225 0
201604 156081 0
201605 167086 0
201606 144498 0
201607 135081 0
201608 137951 0
201609 122194 0
201610 113852 0
201611 6168 0