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 ) id 1gzl2q-0005FY-Lp for pgsql-performance@arkaria.postgresql.org; Fri, 01 Mar 2019 16:29:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gzl2o-0006ap-Tj for pgsql-performance@arkaria.postgresql.org; Fri, 01 Mar 2019 16:29:54 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gzl2o-0006ah-M7 for pgsql-performance@lists.postgresql.org; Fri, 01 Mar 2019 16:29:54 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gzl2l-0000Ut-9O for pgsql-performance@postgresql.org; Fri, 01 Mar 2019 16:29:53 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id x21GTg1s030905; Fri, 1 Mar 2019 11:29:42 -0500 From: Tom Lane To: ROS Didier cc: "pryzby@telsasoft.com" , "pgsql-performance@postgresql.org" Subject: Re: How to get the content of Bind variables In-reply-to: References: <716d29c0713049e98cb80faff31db103@PCYINTPEXMU001.NEOPROD.EDF.FR> <20190228161900.GV28750@telsasoft.com> Comments: In-reply-to ROS Didier message dated "Fri, 01 Mar 2019 07:54:12 +0000" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <30903.1551457782.1@sss.pgh.pa.us> Date: Fri, 01 Mar 2019 11:29:42 -0500 Message-ID: <30904.1551457782@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ROS Didier writes: > postgres=# show log_error_verbosity ; > log_error_verbosity > --------------------- > default > (1 row) So ... how old is this server? AFAIK the above should be enough to ensure you get the DETAIL lines with parameter values. But the ability to log those hasn't been there forever. regards, tom lane