Re: adding status for COPY progress report

Hi,
Here is the updated patch.

Cheers

On Tue, May 24, 2022 at 10:18 AM Zhihong Yu <zyu(at)yugabyte(dot)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)
>
>