Re: How to get the content of Bind variables

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: How to get the content of Bind variables
Дата
Msg-id 05dffd033580da9a8e9d3cafa0890f4ff2d941b2.camel@cybertec.at
обсуждение исходный текст
Ответ на RE: How to get the content of Bind variables  (ROS Didier <didier.ros@edf.fr>)
Список 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 по дате отправления:

Предыдущее
От: ROS Didier
Дата:
Сообщение: RE: How to get the content of Bind variables
Следующее
От: Tom Lane
Дата:
Сообщение: Re: How to get the content of Bind variables