Postgres Pro
Downloads
Home   >   mailing lists

Re: No. Of wal files generated - Mailing list pgsql-general

From Ron Johnson
Subject Re: No. Of wal files generated
Date
Msg-id CANzqJaAkTrMobswbupC=6XYaex47iwC6rz4WpaK=HSbZZMpcxQ@mail.gmail.com
Whole thread Raw
In response to Re: No. Of wal files generated  (Atul Kumar <akumar14871@gmail.com>)
Responses Re: No. Of wal files generated
List pgsql-general
Tree view
inotifywait can log every file creation and deletion in a directory.

Honestly, though, I'd strongly think about using PgBackRest instead of something you wrote yourself.

On Fri, Mar 7, 2025 at 2:47 PM Atul Kumar <akumar14871@gmail.com> wrote:
I want to check and compare the speed  wal file generation process and archival process.

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. 



Regards,
Atul

On Fri, 7 Mar 2025, 22:45 Ron Johnson, <ronljohnsonjr@gmail.com> wrote:
On Fri, Mar 7, 2025 at 10:59 AM Atul Kumar <akumar14871@gmail.com> wrote:
Hi,

Please could you help me by sharing any redhat linux command through which I can count the no. of wal files and no. of ".ready" files generated in last 10 minutes. 

What problem are you trying to solve?

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


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

pgsql-general by date:

Previous
From: mark bradley
Date:
Subject: Re: Duplicate Key Values
Next
From: Adrian Klaver
Date:
Subject: Re: Duplicate Key Values