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 |
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 |