Re: pg_stat_statements in the query column I am not getting the exact query

From: legrand legrand <legrand_legrand(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_stat_statements in the query column I am not getting the exact query
Date: 2018-08-19 20:49:44
Message-ID: 1534711784030-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
This is the expected behavior, like that sql statements with différent
values are shared in pg_stat_statements ...
There is no parameter to change this, if you really want query paramèters
you néed to have a look at statements logging, but be carrefull this can
generate a huge volume of log files depending on your workload ...

See log_statements at
https://www.postgresql.org/docs/9.5/static/runtime-config-logging.html

Regards
PAscal

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Achilleas Mantzios 2018-08-20 06:08:39 Re: Audit management
Previous Message Vijaykumar Jain 2018-08-19 20:00:10 Re: [External] Re: ERROR: cache lookup failed for function 125940