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?
Чтобы сделать работу с сайтом удобнее, мы используем cookie и аналитический сервис «Яндекс.Метрика». Продолжая пользоваться сайтом, вы соглашаетесь с их использованием.