We Added the Index. The Query Was Still Slow. Here's Why

It's a familiar shape of incident, and versions of it show up constantly in backend post-mortems: everything runs fine in staging against a few thousand rows, ships to production, and then real traffi