Firstly, change the "add column" part to just "add".

Secondly, this kind of process will definitely take exclusive locks on the table which will block other processes.

I suggest that you run this process during a very quiet time or during a downtime period.

Regards