Обсуждение: Monitoring PostgreSQL Copy Operations

Поиск
Список
Период
Сортировка

Monitoring PostgreSQL Copy Operations

От
Abdullah Ergin
Дата:

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.

Re: Monitoring PostgreSQL Copy Operations

От
Ron Johnson
Дата:
On Wed, Nov 12, 2025 at 3:33 AM Abdullah Ergin <abdullaherginwork@gmail.com> wrote:

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?

Pipe the query output to "tee -a blarge.log" 

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!