To monitor Copy operations in PostgreSQL in real-time, I use the “pg_stat_progress_copy” view tool:
Here, I specifically want to analyze the number of tuples processed by the command, which is “tuples_processed”. However, since pg_stat_progress_copy is a view tool, the information disappears once the operation is complete, and it does not save the result of the copy operation anywhere. How can I save the result of the copy operation?
Postgresql Version: 16.10
Thank You, Regards.