Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

PostgreSQL 14 – Report progress of COPY commands #277

Open
xluffy opened this issue Oct 24, 2024 · 0 comments
Open

PostgreSQL 14 – Report progress of COPY commands #277

xluffy opened this issue Oct 24, 2024 · 0 comments

Comments

@xluffy
Copy link
Owner

xluffy commented Oct 24, 2024 

\COPY gh_audit_logs FROM '/data/backups/1B.csv' CSV HEADER;

SELECT (bytes_processed::float/bytes_total::float) * 100 AS percent FROM pg_stat_progress_copy \watch 60

      percent
-------------------
 55.27937797061736
(1 row)

Time: 0.409 ms

https://www.depesz.com/2021/01/12/waiting-for-postgresql-14-report-progress-of-copy-commands/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@xluffy