Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <pgsql-performance-owner+archive@lists.postgresql.org>)
	id 1gzdaF-0002EE-QZ
	for pgsql-performance@arkaria.postgresql.org; Fri, 01 Mar 2019 08:31:56 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-performance-owner+archive@lists.postgresql.org>)
	id 1gzdaC-00016r-RR
	for pgsql-performance@arkaria.postgresql.org; Fri, 01 Mar 2019 08:31:52 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <laurenz.albe@cybertec.at>)
	id 1gzdaC-0000z4-Fh
	for pgsql-performance@lists.postgresql.org; Fri, 01 Mar 2019 08:31:52 +0000
Received: from mx2a.mailbox.org ([2001:67c:2050:104:0:2:25:2]
 helo=mx2.mailbox.org)
	by makus.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <laurenz.albe@cybertec.at>)
	id 1gzda9-0003MM-7Z
	for pgsql-performance@postgresql.org; Fri, 01 Mar 2019 08:31:51 +0000
Received: from smtp1.mailbox.org (smtp1.mailbox.org
 [IPv6:2001:67c:2050:105:465:1:1:0])
	(using TLSv1.2 with cipher ECDHE-RSA-CHACHA20-POLY1305 (256/256 bits))
	(No client certificate requested)
	by mx2.mailbox.org (Postfix) with ESMTPS id A3B6BA11CF;
	Fri,  1 Mar 2019 09:31:44 +0100 (CET)
X-Virus-Scanned: amavisd-new at heinlein-support.de
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at;
 s=MBO0001;
	t=1551429102; h=from:from:sender:reply-to:subject:subject:date:date:
	 message-id:message-id:to:to:cc:mime-version:mime-version:
	 content-type:content-type:
	 content-transfer-encoding:content-transfer-encoding:
	 in-reply-to:in-reply-to:references:references;
	bh=ImPYhRiEIMAmypXpe43XRTKV+RSpYJFnMOMsCMT4XpM=;
	b=LN0j0QSPvurr2lqGc00YEEQb26NxqoquoM7AkRmlAEju0vyBirXJeNzYBN9EZECQC4QG/G
	iTUG7jZLLJzAobxSPPrr4Ugo6V4hBrLuY7xlYJSMpHsf1uSGS6K5QN9F6KKIdzlz0UpLT1
	TvEJpJewpqQAxk6DfGtDsyygAQrs/CXt2q9BGYZohVbN6vP5TZiCK5EDa9gbQy6e8p4pLr
	sNVtssYpDv+1ZJRPZT8L0ceH4LA3H0wdJwIRMvvm6b+UJWMRQsfYvQFlOfxwaxzLWbgE3g
	wpreEpfv9Gb75fs/Ap03mc3j1HZQpmvxnSYmzQbTQPQHfJt6FEgqO9zycp2txA==
Received: from smtp1.mailbox.org ([80.241.60.240])
	by spamfilter01.heinlein-hosting.de (spamfilter01.heinlein-hosting.de
 [80.241.56.115]) (amavisd-new, port 10030)
	with ESMTP id WXpDOW3YzQlm; Fri,  1 Mar 2019 09:31:39 +0100 (CET)
Message-ID: <05dffd033580da9a8e9d3cafa0890f4ff2d941b2.camel@cybertec.at>
Subject: Re: How to get the content of Bind variables
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: ROS Didier <didier.ros@edf.fr>, "pgsql-performance@postgresql.org"
	 <pgsql-performance@postgresql.org>
Date: Fri, 01 Mar 2019 09:31:38 +0100
In-Reply-To: <03acdbec6d824785a9901315f671fa7a@PCYINTPEXMU001.NEOPROD.EDF.FR>
References: <716d29c0713049e98cb80faff31db103@PCYINTPEXMU001.NEOPROD.EDF.FR>
	 <5ac91fe099a085b9a04e38f7fc9b38f5381686af.camel@cybertec.at>
	 <03acdbec6d824785a9901315f671fa7a@PCYINTPEXMU001.NEOPROD.EDF.FR>
Organization: Cybertec
Content-Type: text/plain; charset="UTF-8"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Authentication-Results: default_out
X-Rspamd-Queue-Id: 5EDC1909
List-Id: <pgsql-performance.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-performance@lists.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-performance>
Precedence: bulk

ROS Didier wrote:
> Here is a biggest part of my log file :
> 
>  2019-02-27 14:41:28 CET [16239]: [5696-1] [10086] user=pgbd_preint_sg2,db=pgbd_preint_sg2,client=localhost.localdomainLOG:  duration: 1.604 ms
> 2019-02-27 14:41:28 CET [16239]: [5697-1] [10086] user=pgbd_preint_sg2,db=pgbd_preint_sg2,client=localhost.localdomainLOG:  duration: 0.084 ms  parse <unnamed>: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8
> 2019-02-27 14:41:28 CET [16239]: [5698-1] [10086] user=pgbd_preint_sg2,db=pgbd_preint_sg2,client=localhost.localdomainLOG:  plan:
> 2019-02-27 14:41:28 CET [16239]: [5699-1] [10086] user=pgbd_preint_sg2,db=pgbd_preint_sg2,client=localhost.localdomainSTATEMENT:  update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8
> 2019-02-27 14:41:28 CET [16239]: [5700-1] [10086] user=pgbd_preint_sg2,db=pgbd_preint_sg2,client=localhost.localdomainLOG:  duration: 0.288 ms  bind <unnamed>: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8
> 2019-02-27 14:41:28 CET [16239]: [5701-1] [10086] user=pgbd_preint_sg2,db=pgbd_preint_sg2,client=localhost.localdomainLOG:  execute <unnamed>: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8
> <<
> The statement has been executed
> It is the same problem for all the statements.
> I can not get the content of the bind variables.

You should set "log_error_verbosity" back from "terse" to "default".
Then you will see the DETAIL messages.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com