AWS RDS Postgresql query locked in Lock:Relation when not using super user

Hi! I run migrations (add columns, add tables, change restrictions) using prisma migrations in my CI/CD flow. I used to run using a superUser and everything were working well. Due to security reasons we changed to a non super user to handle this migrations. Since this change, sometimes when we run migrations and the DB is being used by services, the migration query never finishes and the db stops working, and the performance insights says that there is a Lock:Relation happening. We never experienced this before, so I am 99% sure that this is happening because of the user change.

Anyone has any idea why this is happening and How to resolve?

One of the failed queries:

ALTER TABLE "Crawlers" 
ADD COLUMN "clusterOptions" JSONB;