Explain Query (mysql)
EXPLAIN SELECT
dgf.feedback_id,
dgf.edit_en_feedback,
dgf.edit_fr_feedback,
dgf.mask_dg_identity,
CONCAT(UPPER(LEFT(u.first_name, 1)), '.', ' ', UPPER(LEFT(u.last_name, 1)), '.') as submitted_by_initials,
u.family_size as family_size,
dgf.created_at,
u.city_name as city
FROM `direct_giving_feedback` dgf
LEFT JOIN users u on u.user_id = dgf.user_id
LEFT JOIN users u2 on u2.user_id = dgf.last_edit_user_id
WHERE dgf.status = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | dgf | ALL | 113 | 10.00 | Using where | |||||
| 1 | SIMPLE | u | eq_ref | PRIMARY | PRIMARY | 4 | securelufacom.dgf.user_id | 1 | 100.00 | ||
| 1 | SIMPLE | u2 | eq_ref | PRIMARY | PRIMARY | 4 | securelufacom.dgf.last_edit_user_id | 1 | 100.00 | Using index |