public inbox for [email protected]
help / color / mirror / Atom feedFrom: Achilleas Mantzios - cloud <[email protected]>
To: [email protected]
Subject: Re: No. Of wal files generated
Date: Mon, 10 Mar 2025 09:41:38 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <CA+ONtZ4q9OkEHx0pCf87Z876=_vM7=+Ko18HF8+WHrENQ8mxLg@mail.gmail.com>
References: <CA+ONtZ4q9OkEHx0pCf87Z876=_vM7=+Ko18HF8+WHrENQ8mxLg@mail.gmail.com>
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
>
>
>
> Regards,
> Atul
view thread (7+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: No. Of wal files generated
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox