The query returns in 3.8 seconds. It should return in 0.4. Every user after that waits longer, and the logs show the same culprit: database access.
Database access pain points slow down products, raise costs, and block scaling. They cause timeouts, connection pool exhaustion, inconsistent data states, and