If this is of interest I suggest taking a look at what Robin is doing at https://kaveland.no/eugene/

TLDR; Eugene helps you write zero downtime schema migration scripts for PostgreSQL databases by giving you a friendly report warning you about any anti patterns or potential problems.