build1 distinct publisher
Four indexes, none of them covering: the 78-second page and the one index that fixed it
A reporting page took 78 seconds for one customer because none of the table's four indexes could answer the filters or the GROUP BY. The fix was one six-column index, shipped in place.
Publishers:dev.to
Reality
- Evidence42
- Adoption18
- Hype gap+12
- Incentives45
- Confidence44