[tor-dev] connectivity failure for top 100 relays

[dawuud]

> And where did you scan *from*?
> (It's hard to interpret the results without the latency and quality of your
> client connection.)

It turns out I am recording circuit build latency. It is unclear to
me exactly what you'd like me to do with this information however
here's a some silly queries:

echo "select (end_time - start_time) / 1000 as duration from scan_log where duration > 50 AND duration < 60;" | sqlite3 scan1.db
55.2818120117187
51.7696379394531
59.9406301269531

echo "select (end_time - start_time) / 1000 as duration from scan_log where duration > 40 AND duration < 50;" | sqlite3 scan1.db
41.0546398925781
40.1456608886719
48.2474660644531

echo "select (end_time - start_time) / 1000 as duration from scan_log where duration > 30 AND duration < 40;" | sqlite3 scan1.db
31.6949631347656
34.8123491210938
37.0733110351563
36.2936791992188

echo "select (end_time - start_time) / 1000 as duration from scan_log where duration > 20 AND duration < 30;" | sqlite3 scan1.db
29.2628620605469
28.2720109863281

echo "select (end_time - start_time) / 1000 as duration from scan_log where duration > 10 AND duration < 20;" | sqlite3 scan1.db
13.4959392089844
14.6635520019531
19.32987109375
14.2355910644531
13.9277241210937
13.3795317382812
12.9024929199219
12.3480061035156
11.711751953125
10.2423110351563
11.0780610351562
18.3046040039062

echo "select (end_time - start_time) / 1000 as duration from scan_log where duration > 3 AND duration < 10;" | sqlite3 scan1.db
8.98835498046875
3.93438012695312
4.10946020507812
9.21181396484375
8.1195078125
6.78396508789062
5.28444775390625
3.59763989257813

echo "select (end_time - start_time) / 1000 as duration from scan_log where duration > 1 AND duration < 3;" | sqlite3 scan1.db
2.05169384765625
1.69050805664062
1.86933813476563
2.22057397460937
1.82368383789063
2.53436987304688
1.80827685546875

echo "select (end_time - start_time) / 1000 as duration from scan_log where duration < 1;" | sqlite3 scan1.db | wc -l
9837
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: not available
URL: <http://lists.torproject.org/pipermail/tor-dev/attachments/20180313/4dee4c2b/attachment.sig>