lock_timeout parameter

Hi,

Could you try setting lock_timeout at the database level?

alter database postgres set lock_timeout = '30s';

Hi, I believe that setting of deadlock_timeout in your parameter group witll produce what you expect: timeout if a transaction in stuck on a lock for too long.

See https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.PostgreSQL.CommonDBATasks.Parameters.html