connection pool

The classic gap between what the backend measures and what the user experiences. A 504 is emitted by something in front of the backend, which is exactly the part your service dashboards do not cover.

An idle database with a starved application is the tell. The connections are held, not used. More database capacity does not release leaked connections.