adding status for COPY progress report

From: Zhihong Yu <zyu(at)yugabyte(dot)com>
To: PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: adding status for COPY progress report
Date: 2022-05-24 17:18:49
Message-ID: CALNJ-vRFwgamZAXcDgdvVY5sExD1QPPpEpqP-tYrU6a-9O0zKg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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 Content-Type Size
copy-progress-status.patch application/octet-stream 4.1 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Nathan Bossart 2022-05-24 17:28:51 Re: allow building trusted languages without the untrusted versions
Previous Message Nathan Bossart 2022-05-24 17:09:10 Re: Add --{no-,}bypassrls flags to createuser