The planner · plan reading
Somebody's report got slow
This ran in a nightly report that used to finish in seconds. Nobody has changed the query. Read the plan and say which node is costing you, and what you would do about it.
The plan
plan
| node | est | actual | loops | pages | share |
|---|---|---|---|---|---|
| SortSort Key: idSort Method: quicksort Memory: 2kB | 40 | 20 | 1 | 0 | |
| → Seq Scan on eventsFilter: (lower(email) = '[email protected]')Rows Removed by Filter: 7,980 | 40 | 20 | 1 | 91 |