re: Link WAL record to session

xid in wal should be transaction id. It is one option (with pid) for log line prefix br Kaido On Tue, 24 Jan 2023, 21:37 David G. Johnston, wrote: > On Tue, Jan 24, 2023 at 12:30 PM kaido vaikla > wrote: > >> Hi >> Take a look at parameter >> log_line_prefix >> >>> >>> > Really? Care to explai

Re: Link WAL record to session

On Tue, Jan 24, 2023 at 12:30 PM kaido vaikla wrote: > Hi > Take a look at parameter > log_line_prefix > >> >> Really? Care to explain in more detail. I wouldn't expect that setting to have anything to do with WAL. David J.

Re: Link WAL record to session

Hi Take a look at parameter log_line_prefix br Kaido On Tue, 24 Jan 2023, 20:36 Sergey Burladyan, 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: 114

Link WAL record to session

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 sessi