We have been experiencing super high latency to PostgreSQL/RDS ever since migrating to v2 (
Every few minutes, the connection from our Rails app on Fly.io to RDS would go so bad that it takes seconds (!) to do even a SELECT. For example, a simple
SELECT "subscriptions".* FROM "subscriptions" WHERE "subscriptions"."merchant_id" = $1 AND "subscriptions"."plan_id" = $2 took about 10 seconds, according to Sentry.
There was no issue in this regard before migration to v2 (migrating off Nomad). And the RDS monitoring shows no error whatsoever.
What could be wrong?