arwiki graph stats
ActivePublic
Actions

Authored by akosiaris on Jan 15 2019, 9:58 AM.

Tags

None

Referenced Files

	F27896442: arwiki graph stats
	Jan 15 2019, 9:59 AM

	F27896426: arwiki graph stats
	Jan 15 2019, 9:58 AM

Subscribers

Tgr

	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)

akosiaris mentioned this in T211881: graphoid: Code stewardship request.

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).

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.

	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.

arwiki graph statsActivePublicActions

Event Timeline

arwiki graph stats
ActivePublic
Actions