Re: How to get the content of Bind variables

From: Sergei Kornilov <sk(at)zsrv(dot)org>
To: ROS Didier <didier(dot)ros(at)edf(dot)fr>, "legrand_legrand(at)hotmail(dot)com" <legrand_legrand(at)hotmail(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: How to get the content of Bind variables
Date: 2019-03-02 16:33:40
Message-ID: 15259961551544420@myt1-06117f29c1ea.qloud-c.yandex.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message ROS Didier 2019-03-02 19:14:41 RE: How to get the content of Bind variables
Previous Message Tom Lane 2019-03-02 16:33:19 Re: How to get the content of Bind variables