Before vs After — Adding an index — myflames

Before vs After — generated by myflames

13.68 ms
Before
8.25 ms
After
↓-39.7%
Change
2 / 3
Operators (before / after)

What changed

Operator comparison

Matches use operator and tree structure. Changed labels show before → after. Single-run timings are observations, not proof of a sustained improvement.

Operator Self-time (before) Self-time (after) Rows (before) Rows (after) Loops (before) Loops (after) Delta
Filter: ((joinit.i > 50)) REMOVED2.62 msn/a16.35K-1-
Index range scan [joinit.PRIMARY] REMOVED11.06 msn/a16.35K-1-
Inner hash join (orders.user_id = users.id) NEWn/a1.90 ms-12.00K-1
Table scan [users] NEWn/a2.54 ms-3.00K-1
Table scan [orders] NEWn/a3.81 ms-12.00K-1