Some after-fork stats:
* latest block as of now
abe=> select block_height from chain_summary order by block_height desc limit 1;
block_height
--------------
429967
(1 row)
* number of orphaned blocks before the hard-fork
abe=> select count(*) from chain_summary where block_height<=420000 and in_longest=0;
count
-------
11345
(1 row)
* number of orphaned blocks after the hard-fork
abe=> select count(*) from chain_summary where block_height>=420000 and in_longest=0;
count
-------
335
(1 row)
* number of orphans in the last 10000 blocks before hard-fork - for comarison with the previous figure (off-by-one, i know
)
abe=> select count(*) from chain_summary where block_height<=420000 and block_height>=410000 and in_longest=0;
count
-------
389
(1 row)
* total number of orphans
abe=> select count(*) from chain_summary where in_longest=0;
count
-------
11680
(1 row)
* list of block heights where potentially unwanted forking occured since block #420000 (that is, my server saw the now orphaned block before the block that ended up in the main chain - regardless of the block's timestamp; block_id is the order of blocks as they arrived to my node - imo a much better metric than timestamps)
abe=> select a.block_height from chain_candidate as a full outer join chain_candidate as b on a.block_height=b.block_height and a.block_id!=b.block_id where a.block_id is not null and b.block_id is not null and a.block_height>=420000 and a.in_longest=1 and b.block_id
block_height
--------------
420049
420069
420080
420246
420275
420319
420375
420518
420642
420739
420794
421027
421048
421135
421175
421242
421283
421417
421448
421469
421567
421659
421865
421884
421893
421931
421985
422087
422088
422214
422300
422427
422507
422507
422861
422882
422942
423065
423066
423067
423225
423308
423352
423400
423414
423462
423480
423493
423567
423606
423664
423665
423675
423756
423766
423769
423963
424068
424148
424164
424238
424269
424305
424402
424667
424722
424886
424975
425198
425235
425241
425278
425435
425473
425507
425563
425573
425660
425724
425745
425798
425812
425919
426178
426195
426238
426267
426288
426334
426335
426336
426484
426525
426530
426540
426551
426576
426629
426794
426808
426825
426852
426856
426945
426972
427067
427076
427305
427350
427353
427432
427503
427614
427627
427673
427685
427690
427695
427696
427699
427700
427707
427712
427718
427724
427751
427767
427790
427795
427807
427816
427838
427863
427918
427929
427930
427931
427936
427939
427993
427995
428014
428049
428057
428062
428065
428069
428131
428189
428282
428373
428393
428431
428448
428467
428521
428522
428533
428538
428550
428551
428559
428684
428724
428775
428806
428817
428871
428910
428941
428944
428957
428974
428984
429064
429096
429143
429154
429155
429156
429196
429198
429199
429345
429347
429348
429387
429396
429441
429450
429457
429503
429513
429624
429641
429708
429712
429718
429719
429754
429773
429815
429835
429951
(204 rows)