Re: Identify transactions causing highest wal generation

2024-03-08 Thread Bharath Rupireddy
On Fri, Mar 8, 2024 at 9:10 PM Tomas Vondra wrote: > > On 3/8/24 15:50, Gayatri Singh wrote: > > Hello Team, > > > > Can you help me with steps to identify transactions which caused wal > > generation to surge ? > > > > You should probably take a look at pg_waldump, which prints information > abou

Re: Identify transactions causing highest wal generation

2024-03-08 Thread Euler Taveira
On Fri, Mar 8, 2024, at 12:40 PM, Tomas Vondra wrote: > On 3/8/24 15:50, Gayatri Singh wrote: > > Hello Team, > > > > Can you help me with steps to identify transactions which caused wal > > generation to surge ? > > > > You should probably take a look at pg_waldump, which prints information > a

Re: Identify transactions causing highest wal generation

2024-03-08 Thread Tomas Vondra
On 3/8/24 15:50, Gayatri Singh wrote: > Hello Team, > > Can you help me with steps to identify transactions which caused wal > generation to surge ? > You should probably take a look at pg_waldump, which prints information about WAL contents, including which XID generated each record. I don't k

Identify transactions causing highest wal generation

2024-03-08 Thread Gayatri Singh
Hello Team, Can you help me with steps to identify transactions which caused wal generation to surge ? Regards, Gayatri.