Link WAL record to session

From: Sergey Burladyan <eshkinkot(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Link WAL record to session
Date: 2023-01-24 18:35:55
Message-ID: 87ilgv7pbo.fsf@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi, All!

Is it possible to associate a WAL record with it session/process id?

For example, if I have this record in WAL:
rmgr: Standby len (rec/tot): 42/ 42, tx: 1142213518, lsn: 36174/FDC19050, prev 36174/FDC19020, desc: LOCK xid 1142213518 db 13091 rel 733108033

Can I find session that writes it?

--
Sergey Burladyan

Responses

Browse pgsql-general by date

  From Date Subject
Next Message kaido vaikla 2023-01-24 19:30:07 Re: Link WAL record to session
Previous Message Zwettler Markus (OIZ) 2023-01-24 16:07:46 AW: [Extern] Re: Is a logical replication crash recovery safe?