Re: Help with Explain Plan

[Corey Samuels]

Maybe I can whittle down what I believe is the issue:

A LEFT JOIN on a large (>15 million rows) table ON an indexed primary key column (profile_id) gives this in the EXPLAIN:

+----+-------------+------------+--------+---------------------------------+---------------------+---------+----------------------------+------+----------------------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+------------+--------+---------------------------------+---------------------+---------+----------------------------+------+----------------------------------------------+
| 1 | PRIMARY | tr | ref | profile_id,post_id | profile_id | 9 | ejmr.to_profile_id | 19 | |

This is taking a long, long time (~8 mins) even though the key is correct the rows column says "19". Is there anything you can see in the EXPLAIN that points to the cause?

Any help is appreciated.

Thanks,
Corey