Change Details

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.

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.

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.