Add pg_stat_progress_rewrite view.

From: Kirill Reshke <reshkekirill(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Add pg_stat_progress_rewrite view.
Date: 2024-12-04 14:53:04
Message-ID: CALdSSPgzP6RerthQ12wrxDLVooJuuA+8h0WKQuJ3NeWoxe1Prw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi hackers!

Recently, one administrator asked me how to monitor the progress of
his ALTER TABLE... ALTER COLUMN TYPE bigint.

That leads me to believe that consumers might benefit from having an
API to track the table change process.

PFA draft patch adding number of tuples (tuples_processed) that was
read from the altered table.

Thoughts?

--
Best regards,
Kirill Reshke

Attachment Content-Type Size
v1-0001-Add-pg_stat_progress_rewrite-view.patch application/octet-stream 4.1 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Daniel Gustafsson 2024-12-04 15:01:06 Re: Replace current implementations in crypt() and gen_salt() to OpenSSL
Previous Message Joe Conway 2024-12-04 14:52:52 Re: Replace current implementations in crypt() and gen_salt() to OpenSSL