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

From Laurenz Albe
Subject Re: How to get the content of Bind variables
Date
Msg-id 05dffd033580da9a8e9d3cafa0890f4ff2d941b2.camel@cybertec.at
Whole thread Raw
In response to RE: How to get the content of Bind variables  (ROS Didier <didier.ros@edf.fr>)
List pgsql-performance
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_valeursset 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=$7where 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_valeursset 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_valeursset 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



pgsql-performance by date:

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