Page MenuHomePhabricator
Paste P7988

arwiki graph stats
ActivePublic

Authored by akosiaris on Jan 15 2019, 9:58 AM.
mysql --defaults-file=$HOME/replica.my.cnf -h arwiki.analytics.db.svc.eqiad.wmflabs arwiki_p
mysql> SELECT page_namespace,count(*) as count from page JOIN page_props on page.page_id=page_props.pp_page WHERE pp_propname="graph_specs" group by(page_namespace) order by count desc;
+----------------+--------+
| page_namespace | count |
+----------------+--------+
| 1 | 431475 |
| 15 | 114376 |
| 7 | 17326 |
| 11 | 5856 |
| 5 | 174 |
| 4 | 42 |
| 10 | 34 |
| 101 | 32 |
| 3 | 24 |
| 2 | 17 |
| 0 | 16 |
| 9 | 13 |
| 13 | 12 |
| 829 | 1 |
+----------------+--------+
So indeed it seems like most graphs in that project are either in Talk pages, Category/File/Template Talk pages.

Event Timeline

akosiaris created this paste.Jan 15 2019, 9:58 AM
akosiaris edited the content of this paste. (Show Details)
Tgr added a subscriber: Tgr.Jan 17 2019, 2:01 AM

Apparently they have a template on every talk pages which is supposed to query the pageviews API and show a pageview graph. Ugh. It seems to be broken on most pages (example).

Tgr added a comment.Jan 17 2019, 2:03 AM

Maybe the low request count is because failed requests are not counted?
Or I might just be overestimating how many people look at talk pages.