SIze 0 in pg_stat_file, pg_stat_progress_copy

From: Marc Millas <marc(dot)millas(at)mokadb(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: SIze 0 in pg_stat_file, pg_stat_progress_copy
Date: 2023-04-14 14:26:11
Message-ID: CADX_1abK4jqmP0xCEmZXKLbZf+WKgXukOosdM3SBchRx4kFuvg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

on a debian machine, with a postgres 14,2 server

logs in a dedicated directory (not log)
when logged as superuser, I get:
--pg_stat_file for the current logfile says size 0,
--pg_ls_logdir answers 0 files,
--pg_ls_dir, for the log directory provides postgres.csv, postgres.json,...
list of files
--and when running a copy from the current logfile with a where clause to
choose only the current day logs, the bytes total column is 0

what can provides such a behaviour ?

thanks,

Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2023-04-14 15:11:06 Re: cursor with hold must be save to disk?
Previous Message 黄宁 2023-04-14 11:04:16 cursor with hold must be save to disk?