gistfile1.txt

mysql:[email protected] [enwiki]> explain SELECT
    ->     DATABASE() AS wiki,
    ->     user_id,
    ->     revision.rev_id,
    ->     page_namespace,
    ->     CAST(revision.rev_len AS INT) -
    ->         CAST(IFNULL(parent.rev_len, 0) AS INT) AS bytes_changed,
    ->     IFNULL(parent.rev_len, 0) AS previous_bytes
    -> FROM staging.tr_experimental_user
    -> INNER JOIN revision FORCE INDEX (user_timestamp) ON 
    ->     user_id = rev_user AND
    ->     revision.rev_timestamp BETWEEN
    ->         user_registration AND
    ->         DATE_FORMAT(DATE_ADD(user_registration, INTERVAL 7 DAY), "%Y%m%d%H%i%S")
    -> LEFT JOIN revision parent ON
    ->     parent.rev_id = revision.rev_parent_id
    -> INNER JOIN page ON
    ->     revision.rev_page = page_id
    -> WHERE wiki = DATABASE();
+------+-------------+----------------------+--------+----------------+---------+---------+--------------------------------+-----------+------------------------------------+
| id   | select_type | table                | type   | possible_keys  | key     | key_len | ref                            | rows      | Extra                              |
+------+-------------+----------------------+--------+----------------+---------+---------+--------------------------------+-----------+------------------------------------+
|    1 | SIMPLE      | revision             | ALL    | user_timestamp | NULL    | NULL    | NULL                           | 578174608 |                                    |
|    1 | SIMPLE      | page                 | eq_ref | PRIMARY        | PRIMARY | 4       | enwiki.revision.rev_page       |         1 |                                    |
|    1 | SIMPLE      | tr_experimental_user | eq_ref | PRIMARY        | PRIMARY | 56      | const,enwiki.revision.rev_user |         1 | Using index condition; Using where |
|    1 | SIMPLE      | parent               | eq_ref | rev_id         | rev_id  | 4       | enwiki.revision.rev_parent_id  |         1 | Using where                        |
+------+-------------+----------------------+--------+----------------+---------+---------+--------------------------------+-----------+------------------------------------+
4 rows in set (0.00 sec)