On 3/7/25 17:59, Atul Kumar 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.
Do you have wal archiving enabled? If yes, then simply go to the archive dir and suit your self with
find , ls, grep, awk, sort , unic -c , etc .
Find files created in the last 10 mins :
find -cmin 10
to get statistics over time :
***CLOUD*** jboss@sma:/smadb/smadb/pgsql/pitr$ ls -lt | head -10
total 629962796
-rw------- 1 postgres postgres 16777216 Mar 10 09:32 000000010000472D00000078
-rw------- 1 postgres postgres 16777216 Mar 10 09:32 000000010000472D00000077
-rw------- 1 postgres postgres 16777216 Mar 10 09:32 000000010000472D00000076
-rw------- 1 postgres postgres 16777216 Mar 10 09:32 000000010000472D00000075
...
you may use :
ls -lt | awk '{print $6""$7"_"substr($8,1,2) }' | sort | uniq -c | less
to get the distribution over (group by) 1 hour intervals
