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

From Greg Sabino Mullane
Subject Re: No. Of wal files generated
Date
Msg-id CAKAnmmK14+Wf_cM9bkySgBDu+i3t_iyhwZGQ6kYK5bHiUBiqmg@mail.gmail.com
Whole thread Raw
In response to Re: No. Of wal files generated  (Atul Kumar <akumar14871@gmail.com>)
List pgsql-general
Take a look at the pg_stat_archiver view, if you have not already:


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

--
Enterprise Postgres Software Products & Tech Support

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: No. Of wal files generated
Next
From: "Rhys A.D. Stewart"
Date:
Subject: exclusion constraint question