pg_stat_progress_copy not working as intended

From: asalias mark <postgres(dot)rocks(at)gmail(dot)com>
To: pgsql-sql(at)lists(dot)postgresql(dot)org
Subject: pg_stat_progress_copy not working as intended
Date: 2022-03-01 17:55:36
Message-ID: CAJA4AWTdANknr0sZUm1FyiYWNxw4oLYY3s-4TLw_V3gbmuXdhQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

*tutorial*: https://paquier.xyz/postgresql-2/postgres-14-monitoring-copy/
*screenshot*: https://prnt.sc/PROhSi8YOfc0

postgres=# CREATE TABLE copy_tab (a int, b text);
CREATE TABLE
postgres=# NSERT INTO copy_tab SELECT generate_series(1, 10) AS a,
postgres-# 'a' || generate_series(1, 10) AS b;
ERROR: syntax error at or near "NSERT"
LINE 1: NSERT INTO copy_tab SELECT generate_series(1, 10) AS a,
^
postgres=# INSERT INTO copy_tab SELECT generate_series(1, 10) AS a,
generate_series(1, 10) ASpostgres-# 'a' || generate_series(1, 10) AS b;
INSERT 0 10
postgres=# COPY copy_tab TO '/tmp/copy_tab_data.txt';
COPY 10
postgres=# SELECT relid::regclass, command, type, bytes_processed,
tuples_processed
postgres-# FROM pg_stat_progress_copy;
relid | command | type | bytes_processed | tuples_processed
-------+---------+------+-----------------+------------------
(0 rows)

postgres=# select version();
version
----------------------------------------------------------------------------------------------------------------------------------
PostgreSQL 14.2 (Ubuntu 14.2-1.pgdg20.04+1) on x86_64-pc-linux-gnu,
compiled by gcc (Ubuntu 9.3.0-17ubuntu1~20.04) 9.3.0, 64-bit
(1 row)

*But I should get: *

SELECT relid::regclass, command, type, bytes_processed, tuples_processed
FROM pg_stat_progress_copy;
relid | command | type | bytes_processed | tuples_processed
----------+---------+------+-----------------+------------------
copy_tab | COPY TO | FILE | 52 | 10
(1 row)

Why are things not working as intended?

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Ian Lawrence Barwick 2022-03-02 00:17:35 Re: pg_stat_progress_copy not working as intended
Previous Message Tom Lane 2022-03-01 15:02:26 Re: Global setting for ORDER BY ... NULLS FIRST / LAST