Skip to content

Instantly share code, notes, and snippets.

@wy
Created August 26, 2018 09:28
Show Gist options
  • Save wy/393289ca21286a1ae9b17c4e3db80fe5 to your computer and use it in GitHub Desktop.
Save wy/393289ca21286a1ae9b17c4e3db80fe5 to your computer and use it in GitHub Desktop.
Old Data from 14th:
SELECT connection_id, blockheight
FROM public.blockheight_history
where ts > '2018-08-14 00:00:00'
and ts < '2018-08-14 07:00:00'
and blockheight >= 2616259
[(457, 873), (439, 822), (464, 820), (444, 820), (443, 804), (445, 803), (438, 800), (27, 799), (4, 756), (486, 754)]
unique 953
75 nodes total
754/953 = 79%
Pain Data from 24th:
SELECT connection_id, blockheight
FROM public.blockheight_history
where ts > '2018-08-24 00:00:00'
and ts < '2018-08-24 07:00:00'
and blockheight >= 2653983
[(571, 807), (19, 797), (20, 778), (22, 776), (461, 705), (13, 691), (444, 679), (464, 668), (548, 646), (551, 640)]
unique 1123
640/1123 = 57%
97 nodes total
New Data from 26th post change:
SELECT connection_id, blockheight
FROM public.blockheight_history
where ts > '2018-08-26 00:00:00'
and ts < '2018-08-26 07:00:00'
and blockheight >= 2659135
[(489, 1107), (532, 1107), (39, 1107), (478, 1107), (13, 1107), (470, 1106), (25, 1106), (533, 1106), (582, 1106), (571, 1106)]
unique 1108
1106/1108 = 99.8%
96 nodes
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment