Re: Link WAL record to session

From: kaido vaikla <kaido(dot)vaikla(at)gmail(dot)com>
To: Sergey Burladyan <eshkinkot(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Link WAL record to session
Date: 2023-01-24 19:30:07
Message-ID: CA+427g-1pBYcQQC+6r6VQ-Xou1VU4pGR8mw3T62UJsCrtCGtsA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi
Take a look at parameter
log_line_prefix

br
Kaido

On Tue, 24 Jan 2023, 20:36 Sergey Burladyan, <eshkinkot(at)gmail(dot)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
>
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2023-01-24 19:36:53 Re: Link WAL record to session
Previous Message Sergey Burladyan 2023-01-24 18:35:55 Link WAL record to session