Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vJ6IM-00Afkl-1Z for pgsql-admin@arkaria.postgresql.org; Wed, 12 Nov 2025 08:33:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vJ6IK-00AG1N-00 for pgsql-admin@arkaria.postgresql.org; Wed, 12 Nov 2025 08:33:36 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vJ6IJ-00AG1B-1z for pgsql-admin@lists.postgresql.org; Wed, 12 Nov 2025 08:33:35 +0000 Received: from mail-oa1-x2a.google.com ([2001:4860:4864:20::2a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vJ6IH-007JJM-0i for pgsql-admin@lists.postgresql.org; Wed, 12 Nov 2025 08:33:35 +0000 Received: by mail-oa1-x2a.google.com with SMTP id 586e51a60fabf-3e8372e33a2so244156fac.2 for ; Wed, 12 Nov 2025 00:33:33 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1762936406; x=1763541206; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=PRUpRGrEAPuXetdZG3IMG2Z/AnpzfVybn9hp8qfH0rQ=; b=I1mJ9TtjGn2AFP/MoyYKjg982e/7AuiTSmKAbbJ80msiKBP4AncyrWMgggyxVaCXBQ 6WXIKQWPrwNZBpCh1CThdnsh62oPUO1Ow5/LLES4LZxlMNKz3+O3NnuCzlAbjpzzDUnD Qkw5ouyrOvrX05C6aLqlj/DCLp00lQLRNth7NhBy/+9xn7Fko2SdY8WHohefbFB76Lwb SMyjIlMKK36QBH6Tn040R8XMxcsh/cJdrncfHUDySjFusHBFz+8PKmDqoucrwQ1w7sUL b6AmpNXnn8H+JfijWuGPKVkHGWazLKY7XmNQ8if6EL7qkvH8dA1nAOw/Q2FxIFOlfWOm R+iA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1762936406; x=1763541206; h=to:subject:message-id:date:from:mime-version:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=PRUpRGrEAPuXetdZG3IMG2Z/AnpzfVybn9hp8qfH0rQ=; b=Ax2nE8STei7vm5Ew6f+URbLHhM8kv0QE1tDjNx3MHwq6WM1nRBlXWvolhOCbmaVrsV 2zXdQZ4tNb79Osx5PQ8bkMgm66LXZeNeAGieAvj4ohdXiqe7VEL1YQGd9PaaFjy7xtJS od6HPULx3euL60m23yHNf0sSWtNx4yFJOknrN+7X5GaWGCPduGay22eXJuZ7PdtMU4on DQKJEdUThXfAERPGhYmXdeFRHkl+mybaZN0jgzAln9UOwnzWsUv7jwNs9AKg11mgscZm Jte5ZkB50o7g2XYJI8GWmRX+dEqr7FahoRmLfov1mclkt6r+gccNoPzKAOTTT/LD3Vba zKdw== X-Gm-Message-State: AOJu0Yw6uFiVfoQHcjRo8CRTwpR0BlJ4Q3qye1gA+xiJu6RjLbIlXfU6 3342c0Sv2a3GEHgLvT6UtO0hZ9bqy/+shOS/uHuqk/CbJ+WHHfO5zifG1b0rExJamu/b8UKK/aU bzVGvspIlz2Gz2ae4PiXTTS3YfBEX0lBpUW+cHN4= X-Gm-Gg: ASbGncsdbMgqehj4WUL7iciyTo75q3B4DzDzm68pXR/t5ts2DxihPuqRKhsiCVK8xJl l62qYlNgyiE7GU+aLO2eAPX5FF07kS7nuPcvxrQkuiU+UQ87LPCF0xOtuUzgXB3cYyIuxMyEG6I 441bK+jmhMFZlavPAFhoweIbZFqZw2S9bfK6FYPm+SVoToKywH+QdOsbJvpZ7Ixbum9KeIFTHqn 4Sx2B6ZN9jpJj94bgQfnDZzMStNFKF+zbfdRmf/qOI1Xb1uEbHtR2WW6ziJ X-Google-Smtp-Source: AGHT+IFz6QSDe28Zyr7UKrDrQIQGhuYTjIfv2XJ6+YBQb8LUgR3RVXlMRUNXnV+UsUMDc8d4CN9B3sIiribz/wkWG+E= X-Received: by 2002:a05:6870:2247:b0:3e7:deca:285f with SMTP id 586e51a60fabf-3e833f5044emr882268fac.8.1762936406382; Wed, 12 Nov 2025 00:33:26 -0800 (PST) MIME-Version: 1.0 From: Abdullah Ergin Date: Wed, 12 Nov 2025 11:33:15 +0300 X-Gm-Features: AWmQ_bna9rysYvOwPxdgm3Ts8QAhGtmTyfvd6ZhohxXMQxap3qyA3ryfLkCow5o Message-ID: Subject: Monitoring PostgreSQL Copy Operations To: pgsql-admin@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000439bbc0643619e0a" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000439bbc0643619e0a Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable To monitor Copy operations in PostgreSQL in real-time, I use the =E2=80=9C pg_stat_progress_copy =E2=80=9D view tool: Here, I specifically want to analyze the number of tuples processed by the command, which is =E2=80=9Ctuples_processed=E2=80=9D. However, since pg_sta= t_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. --000000000000439bbc0643619e0a Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

To monitor Copy o= perations in PostgreSQL in real-time, I use the =E2=80=9Cpg_stat_progress_copy=E2=80=9D = view tool:

Here, I specifically= want to analyze the number of tuples processed by the command, which is = =E2=80=9Ctuples_processed=E2=80=9D. However, since pg_stat_progress_copy is= a view tool, the information disappears once the operation is complete, an= d it does not save the result of the copy operation anywhere. How can I sav= e the result of the copy operation?

Postgresql Version: 16.10
Thank You, Regards.

--000000000000439bbc0643619e0a--