Commons article recount query
ActivePublic
Actions

Authored by • demon on Jul 5 2017, 11:12 PM.

Tags

None

Referenced Files

	F8626648: Commons article recount query
	Jul 5 2017, 11:12 PM

	F8626646: Commons article recount query
	Jul 5 2017, 11:12 PM

Subscribers

None

	mysql:wikiadmin@db1084 [commonswiki]> explain select count(distinct page_id) from page, pagelinks WHERE page_namespace IN (0, 6) and page_is_redirect = 0 and pl_from=page_id \G
	************************* 1. row *************************
	id: 1
	select_type: SIMPLE
	table: page
	type: range
	possible_keys: PRIMARY,name_title,page_redirect_namespace_len
	key: page_redirect_namespace_len
	key_len: 5
	ref: NULL
	rows: 27002004
	Extra: Using where; Using index
	************************* 2. row *************************
	id: 1
	select_type: SIMPLE
	table: pagelinks
	type: ref
	possible_keys: PRIMARY,pl_from
	key: PRIMARY
	key_len: 4
	ref: commonswiki.page.page_id
	rows: 3
	Extra: Using index
	2 rows in set (0.00 sec)

• demon edited the content of this paste. (Show Details)

Commons article recount queryActivePublicActions