Date: Sat, 2 Mar 2019 07:10:11 -0700 (MST)
From: legrand legrand <legrand_legrand@hotmail.com>
To: pgsql-performance@postgresql.org
Message-ID: <1551535811410-0.post@n3.nabble.com>
In-Reply-To: <5342fc1893b94ea0adecb400375ef365@PCYINTPEXMU001.NEOPROD.EDF.FR>
References: <716d29c0713049e98cb80faff31db103@PCYINTPEXMU001.NEOPROD.EDF.FR>
 <20190228161900.GV28750@telsasoft.com>
 <e98a3b508fb8457cbce36a59515d45be@PCYINTPEXMU001.NEOPROD.EDF.FR>
 <30904.1551457782@sss.pgh.pa.us>
 <614c71eb156f49f696018916353fe454@PCYINTPEXMU001.NEOPROD.EDF.FR>
 <1551472898802-0.post@n3.nabble.com>
 <5342fc1893b94ea0adecb400375ef365@PCYINTPEXMU001.NEOPROD.EDF.FR>
Subject: RE: How to get the content of Bind variables
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Precedence: bulk

Did16 wrote
> Hi
>                The SQL is not executed from a trigger.
>                Here is an extract of my log file :
>>>
>=20
> 2019-03-01 14:53:37 CET [24803]: [129-1] [3686]
> user=3Dpgbd_preint_sg2,db=3Dpgbd_preint_sg2 LOG:  process 24803 still wai=
ting
> for ShareLock on transaction 3711 after 1000.476 ms
>=20
> 2019-03-01 14:53:37 CET [24803]: [130-1] [3686]
> user=3Dpgbd_preint_sg2,db=3Dpgbd_preint_sg2 DETAIL:  Process holding the =
lock:
> 24786. Wait queue: 24803.
>=20
> 2019-03-01 14:53:37 CET [24803]: [131-1] [3686]
> user=3Dpgbd_preint_sg2,db=3Dpgbd_preint_sg2 CONTEXT:  while rechecking up=
dated
> tuple (3,33) in relation "t_shared_liste_valeurs"
>=20
> 2019-03-01 14:53:37 CET [24803]: [132-1] [3686]
> user=3Dpgbd_preint_sg2,db=3Dpgbd_preint_sg2 STATEMENT:  update
> t_shared_liste_valeurs set deletion_date=3D$1, deletion_login=3D$2,
> modification_date=3D$3, modification_login=3D$4, administrable=3D$5, libe=
lle=3D$6,
> niveau=3D$7 where code=3D$8
>=20
> <<
>=20
> After a fresh db restart, the result is the same : no content of Bind
> variables in the log file.
>=20
> Best Regards
>=20
> Didier ROS
> Expertise SGBD
> EDF - DTEO - DSIT - IT DMA
> D=C3=A9partement Solutions Groupe
> Groupe Performance Applicative
> 32 avenue Pablo Picasso
> 92000 NANTERRE

OK, In case of a trigger or any pl/pgsql program I would have tryed to writ=
e
the content of bind variables using RAISE command or someting similar befor=
e
executing the UPDATE command.

But your log is now much more explicit: you where waiting on a LOCK ...

Regards
PAscal


--
Sent from: http://www.postgresql-archive.org/PostgreSQL-performance-f205008=
1.html