CONCAT(year,'-',LPAD(month, 2, '0'),'-',LPAD(day, 2, '0')) AS _date,
CASE WHEN is_redirect_to_pageview THEN 'mobile_redirect' ELSE 'mobile_pageview' END AS _bucket,
COUNT(*) AS _count
FROM wmf.pageview_actor
WHERE year=2025 AND month=9
AND agent_type='user'
AND referer_class!='internal'
AND uri_host RLIKE '(^www\.mediawiki\.org|^(ca|he|it|fa)\.wikipedia\.org|^meta\.wikimedia\.org|\.(wikinews|wikibooks|wikiquote|wikivoyage|wikiversity)\.org)$'
-- From puppet/varnish/text-frontend.vcl@cluster_fe_recv_pre_purge
AND uri_host NOT RLIKE '(?i)^([a-z0-9-]+\\.)?m\\.'
AND uri_path NOT LIKE '/wiki/Special:CentralAutoLogin%'
AND ((is_redirect_to_pageview AND user_agent RLIKE '(?i)(android|mobi)') OR (is_pageview AND access_method='mobile web'))
GROUP BY year,month,day,is_pageview,is_redirect_to_pageview
ORDER BY _date ASC, _bucket ASC;
_date _bucket _count
2025-09-01 mobile_redirect 9173124
2025-09-02 mobile_redirect 9139723
2025-09-03 mobile_redirect 8591564
2025-09-04 mobile_redirect 9007455
2025-09-05 mobile_pageview 20249
2025-09-05 mobile_redirect 9236422
2025-09-06 mobile_pageview 58671
2025-09-06 mobile_redirect 9956883
2025-09-07 mobile_pageview 60916
2025-09-07 mobile_redirect 10808248
2025-09-08 mobile_pageview 52414
2025-09-08 mobile_redirect 8637792
2025-09-09 mobile_pageview 39944
2025-09-09 mobile_redirect 9013440
2025-09-10 mobile_pageview 42360
2025-09-10 mobile_redirect 9264013
2025-09-11 mobile_pageview 44976
2025-09-11 mobile_redirect 8463800
2025-09-12 mobile_pageview 51543
2025-09-12 mobile_redirect 8813351
2025-09-13 mobile_pageview 36480
2025-09-13 mobile_redirect 9018222
2025-09-14 mobile_pageview 41452
2025-09-14 mobile_redirect 9851504
2025-09-15 mobile_pageview 35700
2025-09-15 mobile_redirect 8299137
2025-09-16 mobile_pageview 29582
2025-09-16 mobile_redirect 8415992
2025-09-17 mobile_pageview 2594172
2025-09-17 mobile_redirect 5755458
2025-09-18 mobile_pageview 6950199
2025-09-18 mobile_redirect 1973708
2025-09-19 mobile_pageview 8992180
2025-09-19 mobile_redirect 302325
2025-09-20 mobile_pageview 9654453
2025-09-20 mobile_redirect 517064
2025-09-21 mobile_pageview 10353964
2025-09-21 mobile_redirect 498543
2025-09-22 mobile_pageview 8782507
2025-09-22 mobile_redirect 436490
2025-09-23 mobile_pageview 8892142
2025-09-23 mobile_redirect 454979
2025-09-24 mobile_pageview 9405849
2025-09-24 mobile_redirect 199306
2025-09-25 mobile_pageview 9181829
2025-09-25 mobile_redirect 104708
2025-09-26 mobile_pageview 9384746
2025-09-26 mobile_redirect 126200
# 2025-09-27: All wikis
SELECT
CONCAT(year,'-',LPAD(month, 2, '0'),'-',LPAD(day, 2, '0')) AS _date,
CASE WHEN is_redirect_to_pageview THEN 'mobile_redirect' ELSE 'mobile_pageview' END AS _bucket,
COUNT(*) AS _count
FROM wmf.pageview_actor
WHERE year=2025 AND month=9
AND agent_type='user'
AND referer_class!='internal'
-- From puppet/varnish/text-frontend.vcl@cluster_fe_recv_pre_purge
AND uri_host NOT RLIKE '(?i)^([a-z0-9-]+\\.)?m\\.'
AND uri_path NOT LIKE '/wiki/Special:CentralAutoLogin%'
AND ((is_redirect_to_pageview AND user_agent RLIKE '(?i)(android|mobi)') OR (is_pageview AND access_method='mobile web'))
GROUP BY year,month,day,is_pageview,is_redirect_to_pageview
ORDER BY _date ASC, _bucket ASC;
_date _bucket _count
2025-09-01 mobile_redirect 142201266
2025-09-02 mobile_redirect 138331858
2025-09-03 mobile_pageview 592
2025-09-03 mobile_redirect 135349366
2025-09-04 mobile_pageview 2099
2025-09-04 mobile_redirect 136241581
2025-09-05 mobile_pageview 28675
2025-09-05 mobile_redirect 142230435
2025-09-06 mobile_pageview 74057
2025-09-06 mobile_redirect 156415641
2025-09-07 mobile_pageview 63517
2025-09-07 mobile_redirect 166823456
2025-09-08 mobile_pageview 55108
2025-09-08 mobile_redirect 140957942
2025-09-09 mobile_pageview 48609
2025-09-09 mobile_redirect 140381094
2025-09-10 mobile_pageview 53205
2025-09-10 mobile_redirect 149529379
2025-09-11 mobile_pageview 48522
2025-09-11 mobile_redirect 140852499
2025-09-12 mobile_pageview 62666
2025-09-12 mobile_redirect 140701802
2025-09-13 mobile_pageview 38824
2025-09-13 mobile_redirect 152986136
2025-09-14 mobile_pageview 53612
2025-09-14 mobile_redirect 168662255
2025-09-15 mobile_pageview 45451
2025-09-15 mobile_redirect 142692572
2025-09-16 mobile_pageview 35286
2025-09-16 mobile_redirect 141959762
2025-09-17 mobile_pageview 2598732
2025-09-17 mobile_redirect 135176660
2025-09-18 mobile_pageview 6953730
2025-09-18 mobile_redirect 128125946
2025-09-19 mobile_pageview 8996338
2025-09-19 mobile_redirect 127717003
2025-09-20 mobile_pageview 9659733
2025-09-20 mobile_redirect 143640675
2025-09-21 mobile_pageview 10358343
2025-09-21 mobile_redirect 153239971
2025-09-22 mobile_pageview 8786518
2025-09-22 mobile_redirect 131176161
2025-09-23 mobile_pageview 8898484
2025-09-23 mobile_redirect 130905838
2025-09-24 mobile_pageview 9412157
2025-09-24 mobile_redirect 127066627
2025-09-25 mobile_pageview 9186344
2025-09-25 mobile_redirect 125437159
2025-09-26 mobile_pageview 9388601
2025-09-26 mobile_redirect 127979199
# 2025-10-05: Peek at 1% gap
SELECT
CONCAT(year,'-',LPAD(month, 2, '0'),'-',LPAD(day, 2, '0')) AS _date,
http_status,
uri_path,
uri_query,
COUNT(*) AS _count
FROM wmf.pageview_actor
WHERE year=2025 AND month=10 AND day=3 AND hour=13
AND agent_type='user'
AND referer_class!='internal'
AND (uri_host NOT RLIKE '\.wikipedia\.org$' OR uri_host RLIKE '^(test|ca|he|it|fa|id|fr|de|es|ru|ja)\.wikipedia\.org$')
-- From puppet/varnish/text-frontend.vcl@cluster_fe_recv_pre_purge
AND uri_host NOT RLIKE '(?i)^([a-z0-9-]+\\.)?m\\.'
AND uri_path NOT LIKE '/wiki/Special:CentralAutoLogin%'
AND ((is_redirect_to_pageview AND user_agent RLIKE '(?i)(android|mobi)'))
GROUP BY year,month,day,http_status,uri_path,uri_query