Re: adding status for COPY progress report - Mailing list pgsql-hackers

From Zhihong Yu
Subject Re: adding status for COPY progress report
Date
Msg-id CALNJ-vQmyG0KLfp2ZA0dLwfpLdfsvSa8YGpLU570Qy5NJh=xZA@mail.gmail.com
Whole thread Raw
In response to adding status for COPY progress report  (Zhihong Yu <zyu@yugabyte.com>)
List pgsql-hackers
Hi,
Here is the updated patch.

Cheers

On Tue, May 24, 2022 at 10:18 AM Zhihong Yu <zyu@yugabyte.com> wrote:
Hi,
Please see attached for enhancement to COPY command progress.

The added status column would allow users to get the status of the most recent COPY command.

Below is sample output.

Thanks

yugabyte=# SELECT relid::regclass, command, status,
yugabyte-#           type, bytes_processed, bytes_total,
yugabyte-#           tuples_processed, tuples_excluded FROM pg_stat_progress_copy;  relid   |  command  | status | type | bytes_processed | bytes_total | tuples_processed | tuples_excluded
----------+-----------+--------+------+-----------------+-------------+------------------+----------------- copy_tab | COPY FROM | PASS   | FILE |             152 |         152 |               12 |               0
(1 row)
Attachment

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: allow building trusted languages without the untrusted versions
Next
From: Nathan Bossart
Date:
Subject: Re: Assert name/short_desc to prevent SHOW ALL segfault