eu_entity_id query issue
ActivePublic
Actions

Authored by jcrespo on Oct 23 2015, 5:38 PM.

Tags

None

Referenced Files

	F2760450: eu_entity_id query issue
	Oct 23 2015, 5:38 PM

Subscribers

None

	db1060.eqiad.wmnet

	mysql> EXPLAIN SELECT DISTINCT eu_entity_id FROM `wbc_entity_usage` WHERE eu_entity_id IN ('Q1005059','Q10865115','Q10885463','Q10924077','Q10930884','Q10938107','Q11181347','Q14582744','Q14583061','Q14583132','Q14583192','Q148','Q391942','Q42200')\G
	************************* 1. row *************************
	id: 1
	select_type: SIMPLE
	table: wbc_entity_usage
	type: range
	possible_keys: eu_entity_id
	key: eu_entity_id
	key_len: 257
	ref: NULL
	rows: 2567685
	Extra: Using where; Using index for group-by
	1 row in set (0.00 sec)

	db1054.eqiad.wmnet

	mysql> EXPLAIN SELECT DISTINCT eu_entity_id FROM `wbc_entity_usage` WHERE eu_entity_id IN ('Q1005059','Q10865115','Q10885463','Q10924077','Q10930884','Q10938107','Q11181347','Q14582744','Q14583061','Q14583132','Q14583192','Q148','Q391942','Q42200')\G
	************************* 1. row *************************
	id: 1
	select_type: SIMPLE
	table: wbc_entity_usage
	type: range
	possible_keys: eu_entity_id
	key: eu_entity_id
	key_len: 257
	ref: NULL
	rows: 17973791
	Extra: Using where; Using index
	1 row in set (0.00 sec)

jcrespo changed the title of this paste from untitled to eu_entity_id query issue.

jcrespo updated the paste's language from autodetect to autodetect.

eu_entity_id query issueActivePublicActions