ALTER TABLE … ADD COLUMN on a small table takes forever, pg_stat_activity doesn't show any queries on this table

All we need is an easy explanation of the problem, so here it is. So this is the query that hangs forever: ALTER TABLE tasks ADD COLUMN in_progress BOOLEAN NOT…

Continue ReadingALTER TABLE … ADD COLUMN on a small table takes forever, pg_stat_activity doesn't show any queries on this table