From: MichaelDBA <MichaelDBA@sqlexec.com>
To: ROS Didier <didier.ros@edf.fr>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: How to get the content of Bind variables
Date: Thu, 28 Feb 2019 07:36:56 -0500
Message-ID: <5C77D5E8.60608@sqlexec.com> (raw)
In-Reply-To: <716d29c0713049e98cb80faff31db103@PCYINTPEXMU001.NEOPROD.EDF.FR>
References: <716d29c0713049e98cb80faff31db103@PCYINTPEXMU001.NEOPROD.EDF.FR>
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 execute <unnamed>: select
pg_advisory_lock($1)
2019-02-28 00:07:55CST 2019-02-2800:02:09CST ihr2 10.86.42.184(43460)
SELECT DETAIL: parameters: $1 = '3428922050323511872'
Regards,
Michael Vitale
> ROS Didier <mailto:didier.ros@edf.fr>
> Thursday, February 28, 2019 7:21 AM
>
> 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 variables ?
>
> Thanks in advance
>
> Best Regards
>
> cid:image002.png@01D14E0E.8515EB90
>
>
>
> *
> **Didier ROS*
>
> *Expertise SGBD*
>
> EDF - DTEO - DSIT - IT DMA
>
> Département Solutions Groupe
>
> Groupe Performance Applicative
>
> 32 avenue Pablo Picasso
>
> 92000 NANTERRE
>
> _didier*.ros@edf.fr* <mailto:didier.ros@edf.fr>_
>
> Tél. : +33 6 49 51 11 88
>
> cid:image003.png@01D4BE20.1EAF68B0
> <mailto:prenom.nom@edf.fr>cid:image004.png@01D4BE20.1EAF68B0
> <sip:prenom.nom@edf.fr>
>
>
> Ce message et toutes les pièces jointes (ci-après le 'Message') sont
> établis à l'intention exclusive des destinataires et les informations
> qui y figurent sont strictement confidentielles. Toute utilisation de
> ce Message non conforme à sa destination, toute diffusion ou toute
> publication totale ou partielle, est interdite sauf autorisation expresse.
>
> Si vous n'êtes pas le destinataire de ce Message, il vous est interdit
> de le copier, de le faire suivre, de le divulguer ou d'en utiliser
> tout ou partie. Si vous avez reçu ce Message par erreur, merci de le
> supprimer de votre système, ainsi que toutes ses copies, et de n'en
> garder aucune trace sur quelque support que ce soit. Nous vous
> remercions également d'en avertir immédiatement l'expéditeur par
> retour du message.
>
> Il est impossible de garantir que les communications par messagerie
> électronique arrivent en temps utile, sont sécurisées ou dénuées de
> toute erreur ou virus.
> ____________________________________________________
>
> This message and any attachments (the 'Message') are intended solely
> for the addressees. The information contained in this Message is
> confidential. Any use of information contained in this Message not in
> accord with its purpose, any dissemination or disclosure, either whole
> or partial, is prohibited except formal approval.
>
> If you are not the addressee, you may not copy, forward, disclose or
> use any part of it. If you have received this message in error, please
> delete it and all copies from your system and notify the sender
> immediately by return message.
>
> E-mail communication cannot be guaranteed to be timely secure, error
> or virus-free.
>
Attachments:
[image/png] image.png (3.9K, ../5C77D5E8.60608@sqlexec.com/3-image.png)
download | view image
[image/png] image.png (930B, ../5C77D5E8.60608@sqlexec.com/4-image.png)
download | view image
[image/png] image.png (1.8K, ../5C77D5E8.60608@sqlexec.com/5-image.png)
download | view image
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: MichaelDBA@sqlexec.com, didier.ros@edf.fr
Subject: Re: How to get the content of Bind variables
In-Reply-To: <5C77D5E8.60608@sqlexec.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox