Atler Table Alter Column Set Default FALSE: Why my alter table took 10 minutes to finish?
There must have been a concurrent long running transaction that used (perhaps read from) the table. Check pg_stat_activity for sessions with a state other than idle.