Postgres Pro
Downloads
Home   >   mailing lists

Re: How to get the content of Bind variables - Mailing list pgsql-performance

From Sergei Kornilov
Subject Re: How to get the content of Bind variables
Date
Msg-id 15259961551544420@myt1-06117f29c1ea.qloud-c.yandex.net
Whole thread Raw
In response to RE: How to get the content of Bind variables  (ROS Didier <didier.ros@edf.fr>)
Responses RE: How to get the content of Bind variables
List pgsql-performance
Tree view 
Hello

Postgresql does not log statement parameters on log_lock_wait. Because this is not implemented:
https://github.com/postgres/postgres/blob/REL_10_STABLE/src/backend/storage/lmgr/proc.c#L1461
Compare with errdetail_params routine in this file:
https://github.com/postgres/postgres/blob/REL_10_STABLE/src/backend/tcop/postgres.c#L1847
 

Currently query parameters can be logged only at the end of successful query execution.

regards, Sergei

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: How to get the content of Bind variables
Next
From: ROS Didier
Date:
Subject: RE: How to get the content of Bind variables