Postgres Pro
Downloads
Home   >   mailing lists

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

From Zhihong Yu
Subject adding status for COPY progress report
Date
Msg-id CALNJ-vRFwgamZAXcDgdvVY5sExD1QPPpEpqP-tYrU6a-9O0zKg@mail.gmail.com
Whole thread Raw
Responses Re: adding status for COPY progress report  (Zhihong Yu <zyu@yugabyte.com>)
Re: adding status for COPY progress report  (Matthias van de Meent <boekewurm+postgres@gmail.com>)
List pgsql-hackers
Tree view
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: Nathan Bossart
Date:
Subject: Re: Add --{no-,}bypassrls flags to createuser
Next
From: Nathan Bossart
Date:
Subject: Re: allow building trusted languages without the untrusted versions