Start by checking the RDS instance configuration for connection limits and transaction isolation levels, then review your Django application for any long-running processes or loops that might be causing the transaction to hang.

Have you recently changed any database settings or application code that might affect transaction handling, and can you confirm if this issue occurs consistently or only under certain conditions?

What is the current transaction isolation level set for your database?