Re: No. Of wal files generated

From: Greg Sabino Mullane <htamfids(at)gmail(dot)com>
To: Atul Kumar <akumar14871(at)gmail(dot)com>
Cc: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: No. Of wal files generated
Date: 2025-03-08 03:34:22
Message-ID: CAKAnmmK14+Wf_cM9bkySgBDu+i3t_iyhwZGQ6kYK5bHiUBiqmg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ayush Vatsa 2025-03-08 15:04:40 Re: Clarification on Role Access Rights to Table Indexes
Previous Message Ron Johnson 2025-03-08 01:22:37 Re: No. Of wal files generated