There are no open transactions as the table is not blocked by any pid. However when i check pg_locks it say granted=false but nothing blocking it. Bit strange!!
On Mon, 2021-03-29 at 22:38 +0530, Devendra Yadav wrote: > I am running a query on a table - ALTER TABLE mytable ADD COLUMN deposited DOUBLE PRECISION DEFAULT 0.0; > > this query just runs forever.
Then either you are using a PostgreSQL version older than v11, or there is an open transaction that used the table and blocks you.