e : s...@zsrv.org [mailto:s...@zsrv.org]
Envoyé : samedi 2 mars 2019 17:34
À : ROS Didier ; legrand_legr...@hotmail.com;
pgsql-performa...@postgresql.org
Objet : Re: How to get the content of Bind variables
Hello
Postgresql does not log statement parameters on log_lock_wait. Because this is
edi 2 mars 2019 16:57
À : ROS Didier
Cc : t...@sss.pgh.pa.us; pgsql-performa...@postgresql.org;
legrand_legr...@hotmail.com
Objet : Re: How to get the content of Bind variables
On Fri, Mar 01, 2019 at 06:47:06PM +, ROS Didier wrote:
> log_line_prefix = '%t [%p]: [%l-1] [%x] user=%u,db
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_1
Justin Pryzby writes:
> On Fri, Mar 01, 2019 at 06:47:06PM +, ROS Didier wrote:
>> log_line_prefix = '%t [%p]: [%l-1] [%x] user=%u,db=%d,client=%h'
> On Sat, Mar 02, 2019 at 01:14:44PM +, ROS Didier wrote:
>> 2019-03-01 14:53:37 CET [24803]: [129-1] [3686]
>> user=pgbd_preint_sg2,db=pgbd
On Fri, Mar 01, 2019 at 06:47:06PM +, ROS Didier wrote:
> log_line_prefix = '%t [%p]: [%l-1] [%x] user=%u,db=%d,client=%h'
On Sat, Mar 02, 2019 at 01:14:44PM +, ROS Didier wrote:
> 2019-03-01 14:53:37 CET [24803]: [129-1] [3686]
> user=pgbd_preint_sg2,db=pgbd_preint_sg2 LOG: process 2480
Did16 wrote
> Hi
>The SQL is not executed from a trigger.
>Here is an extract of my log file :
>>>
>
> 2019-03-01 14:53:37 CET [24803]: [129-1] [3686]
> user=pgbd_preint_sg2,db=pgbd_preint_sg2 LOG: process 24803 still waiting
> for ShareLock on transaction 3711 aft
egr...@hotmail.com]
Envoyé : vendredi 1 mars 2019 21:42
À : pgsql-performa...@postgresql.org
Objet : RE: How to get the content of Bind variables
Hi Didier,
I imagine that this is the sql executed from a trigger.
Could you provide the trigger pl/pgsql code ?
as the source and target tabl
Hi Didier,
I imagine that this is the sql executed from a trigger.
Could you provide the trigger pl/pgsql code ?
as the source and target tables (anonymized) definition ?
After a fresh db restart, are thoses logs the same for the 6 first
executions and the following ones ?
Regards
PAscal
--
l. : +33 6 49 51 11 88
-Message d'origine-
De : t...@sss.pgh.pa.us [mailto:t...@sss.pgh.pa.us]
Envoyé : vendredi 1 mars 2019 17:30
À : ROS Didier
Cc : pry...@telsasoft.com; pgsql-performa...@postgresql.org
Objet : Re: How to get the content of Bind variables
ROS Didier writes:
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
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_
t.com]
Envoyé : jeudi 28 février 2019 17:19
À : ROS Didier
Cc : pgsql-performa...@postgresql.org
Objet : Re: How to get the content of Bind variables
On Thu, Feb 28, 2019 at 12:21:56PM +, ROS Didier wrote:
> Statement: update t_shared_liste_valeurs set deletion_date=$1,
> deleti
On Thu, Feb 28, 2019 at 12:21:56PM +, ROS Didier wrote:
> Statement: 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
>
> è how to get the content of the bind variable
; pgsql-performa...@postgresql.org
Objet : Re: How to get the content of Bind variables
ROS Didier wrote:
>In the log file of my PostgreSQL cluster, I find :
> >>
> Statement: update t_shared_liste_valeurs set deletion_date=$1,
> deletion_login=$2, modifica
ROS Didier wrote:
>In the log file of my PostgreSQL cluster, I find :
> >>
> Statement: 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
> <<
>
> how to
E20.1EAF68B0]
De : michael...@sqlexec.com [mailto:michael...@sqlexec.com]
Envoyé : jeudi 28 février 2019 13:37
À : ROS Didier
Cc : pgsql-performa...@postgresql.org
Objet : Re: How to get the content of Bind variables
If you set log_min_duration_statement low enough for your particular query, y
If you set log_min_duration_statement low enough for your particular
query, you will see another line below it showing what values are
associated with each bind variable like this:
2019-02-28 00:07:55CST 2019-02-2800:02:09CST ihr2 10.86.42.184(43460)
SELECT LOG: duration: 26078.308 ms execut
Hi
In the log file of my PostgreSQL cluster, I find :
>>
Statement: 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
<<
è how to get the content of the bind va
18 matches
Mail list logo
