Re: No. Of wal files generated

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(at)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

>
>
>
> Regards,
> Atul