Our Database Query Took 0.3ms in Dev. 47 Seconds in Production. The Reason: Hilarious.

I added an index. Tested locally. Query flew at 0.3 milliseconds. Deployed to production. Users started complaining. I checked the logs: 47 seconds. Same query. I was about to blame AWS, the network,

The production incident started at 2:47 PM on a Tuesday.

Our API response time went from 200ms to 48 seconds.

Users couldn’t load their dashboards.

Support tickets piling up.

CEO in Slack: “What’s happening?”

Me: “Looking into it.”

But internally: Absolute panic.