[no subject]

[Devendra Yadav <devendra.857@xxxxxxxxx>]

Hello,

Hope everything is well with you. 

We are running on PostgreSQL v 12.1 , Redhat 7.8.

We are running a query  - ALTER TABLE mytable ADD COLUMN deposited DOUBLE PRECISION;

This query is blocked by pid 0. It's not a postgres PID and won't allow to terminate from postgres. 

What would  be the way forward to troubleshoot this?

Thanks and Regards,

Devendra Yadav