Service degradation under high load from GetOrGenerateKeys locking
If Hydra's response times balloon under high login volume (reporters saw up to ~20s at ~3k session requests in 10s), the cause is locking in GetOrGenerateKeys. The fix the maintainer approved is the SELECT / INSERT ON CONFLICT approach (ory/hydra commit 5b0481b2a214a0c0471038c5b8480db018571e9c), which held response times under 100ms. Upgrade to a Hydra build that includes that fix.
_Source: gh:ory/hydra#3863 (Ory)_