Re: Link WAL record to session

[kaido vaikla <kaido.vaikla@xxxxxxxxx>]

Hi

Take a look at parameter 

log_line_prefix

br

Kaido

On Tue, 24 Jan 2023, 20:36 Sergey Burladyan, <eshkinkot@xxxxxxxxx> wrote:

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