Postgres Pro
Downloads
Home   >   mailing lists

Re: Link WAL record to session - Mailing list pgsql-general

From kaido vaikla
Subject Re: Link WAL record to session
Date
Msg-id CA+427g-1pBYcQQC+6r6VQ-Xou1VU4pGR8mw3T62UJsCrtCGtsA@mail.gmail.com
Whole thread Raw
In response to Link WAL record to session  (Sergey Burladyan <eshkinkot@gmail.com>)
Responses Re: Link WAL record to session
List pgsql-general
Tree view
Hi
Take a look at parameter 
log_line_prefix

br
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


pgsql-general by date:

Previous
From: Sergey Burladyan
Date:
Subject: Link WAL record to session
Next
From: "David G. Johnston"
Date:
Subject: Re: Link WAL record to session