Progress of ALTER TABLE on inheritance-partitioned table?

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Progress of ALTER TABLE on inheritance-partitioned table?
Date: 2023-10-27 13:34:15
Message-ID: 400b499f-7db5-4e00-ac1c-0b20e855dc88@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Pg 9.6.24 (Yes, I know; it's out of my control.)

I'm ALTERing that table to change a column from INTEGER to BIGINT. Of
course, all of the partitions are pretty big.

Even though it's one giant transaction, is there any way for me to monitor
it's progress?

--
Born in Arizona, moved to Babylonia.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Michael Guissine 2023-10-27 13:41:20 Re: Progress of ALTER TABLE on inheritance-partitioned table?
Previous Message B Liu 2023-10-27 13:33:00 Re: pgagent for windows download link missing