[Author Prev][Author Next][Thread Prev][Thread Next][Author Index][Thread Index]
Re: [tor-bugs] #22346 [Metrics/Metrics website]: tor browser update URL change and the update ping metrics
#22346: tor browser update URL change and the update ping metrics
-------------------------------------+------------------------------
Reporter: cypherpunks | Owner: metrics-team
Type: defect | Status: new
Priority: Medium | Milestone:
Component: Metrics/Metrics website | Version:
Severity: Normal | Resolution:
Keywords: | Actual Points:
Parent ID: | Points:
Reviewer: | Sponsor:
-------------------------------------+------------------------------
Comment (by karsten):
Fine question. Looks like we're missing some other resource string used
for update pings, but I don't know which. Here's the requests we're
including, by month, site, and resource_part up to `update_[23]`/`:
{{{
webstats=> SELECT '2017-0' || date_part('month', log_date) AS month, site,
webstats-> substr(resource_string, 1,
webstats(> strpos(resource_string, 'update_') + 8) AS resource_part,
webstats-> SUM(count) AS count
webstats-> FROM files NATURAL JOIN requests NATURAL JOIN resources
webstats-> WHERE resource_string LIKE '%/torbrowser/update\__/%'
webstats-> AND resource_string NOT LIKE '%.xml'
webstats-> AND response_code = 200
webstats-> AND method = 'GET'
webstats-> AND log_date >= '2017-01-01'
webstats-> GROUP BY month, site, resource_part
webstats-> ORDER BY month, count DESC;
month | site | resource_part
| count
---------+------------------------+--------------------------------------------------+----------
2017-01 | dist.torproject.org | /torbrowser/update_2/
| 48888500
2017-01 | aus1.torproject.org | /torbrowser/update_2/
| 3576134
2017-01 | archive.torproject.org | /tor-package-
archive/torbrowser/update_2/ | 119
2017-01 | dist.torproject.org |
https://dist.torproject.org/torbrowser/update_2/ | 2
2017-02 | aus1.torproject.org | /torbrowser/update_2/
| 17695061
2017-02 | dist.torproject.org | /torbrowser/update_2/
| 2827113
2017-02 | archive.torproject.org | /tor-package-
archive/torbrowser/update_2/ | 536
2017-03 | aus1.torproject.org | /torbrowser/update_2/
| 19250809
2017-03 | dist.torproject.org | /torbrowser/update_2/
| 1977765
2017-03 | archive.torproject.org | /tor-package-
archive/torbrowser/update_2/ | 616
2017-04 | aus1.torproject.org | /torbrowser/update_2/
| 31079925
2017-04 | aus1.torproject.org | /torbrowser/update_3/
| 16694038
2017-04 | dist.torproject.org | /torbrowser/update_2/
| 1469608
2017-04 | archive.torproject.org | /tor-package-
archive/torbrowser/update_2/ | 386
2017-05 | aus1.torproject.org | /torbrowser/update_3/
| 39459138
2017-05 | aus1.torproject.org | /torbrowser/update_2/
| 991946
2017-05 | dist.torproject.org | /torbrowser/update_2/
| 982639
2017-05 | archive.torproject.org | /tor-package-
archive/torbrowser/update_2/ | 529
(18 rows)
}}}
boklm, any ideas which other resource string we should be including?
--
Ticket URL: <https://trac.torproject.org/projects/tor/ticket/22346#comment:2>
Tor Bug Tracker & Wiki <https://trac.torproject.org/>
The Tor Project: anonymity online
_______________________________________________
tor-bugs mailing list
tor-bugs@xxxxxxxxxxxxxxxxxxxx
https://lists.torproject.org/cgi-bin/mailman/listinfo/tor-bugs