MIME-Version: 1.0
References: <CA+ONtZ4q9OkEHx0pCf87Z876=_vM7=+Ko18HF8+WHrENQ8mxLg@mail.gmail.com>
 <CANzqJaB4Qz2iqvaprSHH18=A3neAMBugJ4OLoZr2UZ3rQiUF2A@mail.gmail.com> <CA+ONtZ6q4+wcNH9dPZm2tugLaU98xrf7iU8UA6JC2NVYtW_JRw@mail.gmail.com>
In-Reply-To: <CA+ONtZ6q4+wcNH9dPZm2tugLaU98xrf7iU8UA6JC2NVYtW_JRw@mail.gmail.com>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Fri, 7 Mar 2025 22:34:22 -0500
Message-ID: <CAKAnmmK14+Wf_cM9bkySgBDu+i3t_iyhwZGQ6kYK5bHiUBiqmg@mail.gmail.com>
Subject: Re: No. Of wal files generated
To: Atul Kumar <akumar14871@gmail.com>
Cc: Ron Johnson <ronljohnsonjr@gmail.com>, 
	pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000074a5fa062fcc6c4e"
Archived-At: <https://www.postgresql.org/message-id/CAKAnmmK14%2BWf_cM9bkySgBDu%2Bi3t_iyhwZGQ6kYK5bHiUBiqmg%40mail.gmail.com>
Precedence: bulk

--00000000000074a5fa062fcc6c4e
Content-Type: text/plain; charset="UTF-8"

Take a look at the pg_stat_archiver view, if you have not already:

https://www.postgresql.org/docs/current/monitoring-stats.html#MONITORING-PG-STAT-ARCHIVER-VIEW

So I want to check how many wal file got created in x minutes and how many
> .ready files got created in those x minutes.
>

It's not clear why you would want to track .ready files, they should be
quite transient, and not a concern unless you are rolling your own
archiving system (which you should not be). But Ron's suggestion of
inotifywait is a good one for this. Probably listed as inotify or
inotify-tools in your packaging system. Basic usage would be something like
this, from the data directory:

timeout 10m inotifywait pg_wal/ -r -m -e close_write -o walinfo.log

Cheers,
Greg

--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support

--00000000000074a5fa062fcc6c4e
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">Take a look at the pg_stat_archiver view,=
 if you have not already:<div><br></div><div><a href=3D"https://www.postgre=
sql.org/docs/current/monitoring-stats.html#MONITORING-PG-STAT-ARCHIVER-VIEW=
">https://www.postgresql.org/docs/current/monitoring-stats.html#MONITORING-=
PG-STAT-ARCHIVER-VIEW</a></div><div><br></div></div><div class=3D"gmail_quo=
te gmail_quote_container"><blockquote class=3D"gmail_quote" style=3D"margin=
:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"=
><div dir=3D"auto"><div dir=3D"auto">So I want to check how many wal file g=
ot created in x minutes and how many .ready files got created in those x mi=
nutes.=C2=A0</div></div></blockquote><div><br></div><div>It&#39;s not clear=
 why you would want to track .ready files, they should be quite transient, =
and not a concern unless you are rolling your own archiving=C2=A0system (wh=
ich you should not be). But Ron&#39;s suggestion of inotifywait is a good o=
ne for this. Probably listed as inotify or inotify-tools in your packaging =
system. Basic usage would be something like this, from the data directory:<=
/div><div><br></div><div>timeout 10m inotifywait pg_wal/ -r -m -e close_wri=
te -o walinfo.log</div><div>=C2=A0</div></div><div dir=3D"ltr" class=3D"gma=
il_signature"><div dir=3D"ltr"><div>Cheers,</div><div>Greg</div><div><br></=
div><div>--</div><div>Crunchy Data - <a href=3D"https://www.crunchydata.com=
" target=3D"_blank">https://www.crunchydata.com</a></div><div>Enterprise Po=
stgres Software Products &amp; Tech Support</div><div><br></div></div></div=
></div>

--00000000000074a5fa062fcc6c4e--