Files F34478611

raw-paste-data.txt
No One
Actions

Authored By

	Tgr
	Jun 2 2021, 5:18 PM

Size

1 KB

Referenced Files

None

Subscribers

None

raw-paste-data.txt
View Options

	mysql:research@dbstore1004.eqiad.wmnet [cswiki]> EXPLAIN SELECT user_id,user_name FROM `user` JOIN `user_properties` ON ((user_id = up_user) AND up_property = 'growthexperiments-homepage-variant') WHERE up_value = 'control' AND (user_id > 1000) ORDER BY user_id ASC LIMIT 100;
	+------+-------------+-----------------+--------+---------------------+-------------+---------+--------------------------------+-------+------------------------------------+
	\| id \| select_type \| table \| type \| possible_keys \| key \| key_len \| ref \| rows \| Extra \|
	+------+-------------+-----------------+--------+---------------------+-------------+---------+--------------------------------+-------+------------------------------------+
	\| 1 \| SIMPLE \| user_properties \| range \| PRIMARY,up_property \| up_property \| 261 \| NULL \| 22914 \| Using index condition; Using where \|
	\| 1 \| SIMPLE \| user \| eq_ref \| PRIMARY \| PRIMARY \| 4 \| cswiki.user_properties.up_user \| 1 \| \|
	+------+-------------+-----------------+--------+---------------------+-------------+---------+--------------------------------+-------+------------------------------------+

File Metadata

Mime Type: text/plain; charset=utf-8
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 9088699
Default Alt Text: raw-paste-data.txt (1 KB)

Event Timeline