[Author Prev][Author Next][Thread Prev][Thread Next][Author Index][Thread Index]
[tor-commits] [metrics-web/release] Include op-ab in OnionPerf graphs.
commit 82aa20a17cb8ff827873e6d0a776b9e2967197bb
Author: Karsten Loesing <karsten.loesing@xxxxxxx>
Date: Thu Jan 24 12:10:03 2019 +0100
Include op-ab in OnionPerf graphs.
Turns out that op-ab's domain name matches our '%.onion%' regex, that
we're using to distinguish public from onion server requests. Trying a
bit harder to distinguish the two.
Related to #29107.
---
src/main/sql/onionperf/init-onionperf.sql | 8 ++++----
1 file changed, 4 insertions(+), 4 deletions(-)
diff --git a/src/main/sql/onionperf/init-onionperf.sql b/src/main/sql/onionperf/init-onionperf.sql
index 49eff4a..e9af3b1 100644
--- a/src/main/sql/onionperf/init-onionperf.sql
+++ b/src/main/sql/onionperf/init-onionperf.sql
@@ -68,7 +68,7 @@ FROM (
SELECT DATE(start) AS date,
filesize,
source,
- CASE WHEN endpointremote LIKE '%.onion%' THEN 'onion'
+ CASE WHEN endpointremote LIKE '%.onion:%' THEN 'onion'
ELSE 'public' END AS server,
CASE WHEN COUNT(*) > 0 THEN
PERCENTILE_CONT(ARRAY[0.25,0.5,0.75]) WITHIN GROUP(ORDER BY datacomplete)
@@ -85,7 +85,7 @@ UNION
SELECT DATE(start) AS date,
filesize,
'' AS source,
- CASE WHEN endpointremote LIKE '%.onion%' THEN 'onion'
+ CASE WHEN endpointremote LIKE '%.onion:%' THEN 'onion'
ELSE 'public' END AS server,
CASE WHEN COUNT(*) > 0 THEN
PERCENTILE_CONT(ARRAY[0.25,0.5,0.75]) WITHIN GROUP(ORDER BY datacomplete)
@@ -137,7 +137,7 @@ SELECT date,
FROM (
SELECT DATE(start) AS date,
source,
- CASE WHEN endpointremote LIKE '%.onion%' THEN 'onion'
+ CASE WHEN endpointremote LIKE '%.onion:%' THEN 'onion'
ELSE 'public' END AS server,
PERCENTILE_CONT(ARRAY[0.25,0.5,0.75])
WITHIN GROUP(ORDER BY dataresponse - datarequest) AS q
@@ -149,7 +149,7 @@ GROUP BY date, source, server
UNION
SELECT DATE(start) AS date,
'' AS source,
- CASE WHEN endpointremote LIKE '%.onion%' THEN 'onion'
+ CASE WHEN endpointremote LIKE '%.onion:%' THEN 'onion'
ELSE 'public' END AS server,
PERCENTILE_CONT(ARRAY[0.25,0.5,0.75])
WITHIN GROUP(ORDER BY dataresponse - datarequest) AS q
_______________________________________________
tor-commits mailing list
tor-commits@xxxxxxxxxxxxxxxxxxxx
https://lists.torproject.org/cgi-bin/mailman/listinfo/tor-commits