Page MenuHomePhabricator
Paste P16253

(An Untitled Masterwork)
ActivePublic

Authored by Tgr on Jun 2 2021, 5:18 PM.
Tags
None
Referenced Files
F34478611: raw-paste-data.txt
Jun 2 2021, 5:18 PM
Subscribers
None
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 | |
+------+-------------+-----------------+--------+---------------------+-------------+---------+--------------------------------+-------+------------------------------------+

Event Timeline