RE: How to get the content of Bind variables

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

RE: How to get the content of Bind variables

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 +0000, ROS Didier wrote: > log_line_prefix = '%t [%p]: [%l-1] [%x] user=%u,db

RE: How to get the content of Bind variables

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 after 1000.476 ms 2019

RE: How to get the content of Bind variables

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:

RE: How to get the content of Bind variables

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 +0000, ROS Didier wrote: > Statement: update t_shared_liste_valeurs set deletion_date=$1, > deleti

RE: How to get the content of Bind variables

Département Solutions Groupe Groupe Performance Applicative 32 avenue Pablo Picasso 92000 NANTERRE   didier@edf.fr Tél. : +33 6 49 51 11 88 -Message d'origine- De : laurenz.a...@cybertec.at [mailto:laurenz.a...@cybertec.at] Envoyé : jeudi 28 février 2019 17:01 À : ROS Didier

RE: How to get the content of Bind variables

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

How to get the content of Bind variables

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

RE: Why the index is not used ?

am going to test it. Best Regards Didier ROS De : p...@paulmcgarry.com [mailto:p...@paulmcgarry.com] Envoyé : lundi 8 octobre 2018 00:11 À : ROS Didier Cc : fola...@peoplecall.com; pavel.steh...@gmail.com; pgsql-...@lists.postgresql.org; pgsql-performance@lists.postgresql.org; pgsql-gene

RE: Why the index is not used ?

.com [mailto:tomas.von...@2ndquadrant.com] Envoyé : dimanche 7 octobre 2018 22:08 À : ROS Didier ; fola...@peoplecall.com Cc : pavel.steh...@gmail.com; pgsql-...@lists.postgresql.org; pgsql-performance@lists.postgresql.org; pgsql-gene...@lists.postgresql.org Objet : Re: Why the index is not used ? Hi

RE: Why the index is not used ?

s Didier De : greatvo...@gmail.com [mailto:greatvo...@gmail.com] Envoyé : dimanche 7 octobre 2018 21:33 À : ROS Didier Cc : fola...@peoplecall.com; pavel.steh...@gmail.com; pgsql-...@lists.postgresql.org; pgsql-performance@lists.postgresql.org; pgsql-gene...@lists.postgresql.org Objet : Re: Why

RE: Why the index is not used ?

octobre 2018 18:51 À : ROS Didier Cc : pgsql-...@lists.postgresql.org; pgsql-performance@lists.postgresql.org; pgsql-gene...@lists.postgresql.org Objet : Re: Why the index is not used ? Hello Didier, >> (3), (5) to find the match, you decrypt the whole table, apparently this take quite

RE: Why the index is not used ?

ra.ku...@guycarp.com [mailto:virendra.ku...@guycarp.com] Envoyé : dimanche 7 octobre 2018 20:41 À : ROS Didier ; fola...@peoplecall.com Cc : pavel.steh...@gmail.com; pgsql-...@lists.postgresql.org; pgsql-performance@lists.postgresql.org; pgsql-gene...@lists.postgresql.org Objet : RE: Why the index is not

RE: Why the index is not used ?

@gmail.com [mailto:greatvo...@gmail.com] Envoyé : dimanche 7 octobre 2018 21:33 À : ROS Didier Cc : fola...@peoplecall.com; pavel.steh...@gmail.com; pgsql-...@lists.postgresql.org; pgsql-performance@lists.postgresql.org; pgsql-gene...@lists.postgresql.org Objet : Re: Why the index is not used ? Addition

RE: Why the index is not used ?

t Regards Didier ROS -Message d'origine- De : fola...@peoplecall.com [mailto:fola...@peoplecall.com] Envoyé : dimanche 7 octobre 2018 17:58 À : ROS Didier Cc : pavel.steh...@gmail.com; pgsql-...@lists.postgresql.org; pgsql-performance@lists.postgresql.org; pgsql-gene...@lists.postg

RE: Why the index is not used ?

lmcgarry.com] Envoyé : dimanche 7 octobre 2018 04:21 À : ROS Didier Cc : pgsql-...@lists.postgresql.org; pgsql-performance@lists.postgresql.org; pgsql-gene...@lists.postgresql.org Objet : Re: Why the index is not used ? I haven’t looked up what pgp_sym_encrypt() does but assuming it does encryption

RE: Why the index is not used ?

f.fr<mailto:support-oracle-nive...@edf.fr> Tél. : 01 78 66 61 14 Tél. mobile : 06 49 51 11 88 Lync : ros.did...@edf.fr De : pavel.steh...@gmail.com [mailto:pavel.steh...@gmail.com] Envoyé : samedi 6 octobre 2018 12:14 À : ROS Didier Cc : pgsql-...@lists.postgresql.org; pgsql-performance@lists.po

Why the index is not used ?

Hi I would like to submit the following problem to the PostgreSQL community. In my company, we have data encryption needs. So I decided to use the following procedure : (1)Creating a table with a bytea type column to store the encrypted data CREATE TABLE cartedecredit(card_id SERIAL PRIMARY