[metrics-bugs] #22346 [Metrics/Metrics website]: tor browser update URL change and the update ping metrics

[Tor Bug Tracker & Wiki]

#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