Thread: 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 xid1142213518 db 13091 rel 733108033 Can I find session that writes it? -- Sergey Burladyan
Hi
br
Take a look at parameter
log_line_prefix
Kaido
On Tue, 24 Jan 2023, 20:36 Sergey Burladyan, <eshkinkot@gmail.com> 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
On Tue, Jan 24, 2023 at 12:30 PM kaido vaikla <kaido.vaikla@gmail.com> wrote:
HiTake a look at parameterlog_line_prefix
Really? Care to explain in more detail. I wouldn't expect that setting to have anything to do with WAL.
David J.
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, <david.g.johnston@gmail.com> wrote:
On Tue, Jan 24, 2023 at 12:30 PM kaido vaikla <kaido.vaikla@gmail.com> wrote:HiTake a look at parameterlog_line_prefixReally? Care to explain in more detail. I wouldn't expect that setting to have anything to do with WAL.David J.