Regarding pg_stat_statements

Hi,
As we know that "pg_stat_statements" will monitor the queries after
normalizing the queries(Removes the values present in query). I want to
know is there a way to store those normalized values because I want to
check the type of data(values) ,range of data that is being hit to the
database. I am using Postgres 9.4

You can set log_min_duration_statement = 0 to log every statement.

On Fri, Mar 13, 2015 at 3:38 AM, Sreerama Manoj <manoj.sreerama973@gmail.com

wrote:

Hi,
As we know that "pg_stat_statements" will monitor the queries after
normalizing the queries(Removes the values present in query). I want to
know is there a way to store those normalized values because I want to
check the type of data(values) ,range of data that is being hit to the
database. I am using Postgres 9.4

--
*Matt McGuire *| Manager, Data Management
*mmcguire@parchment.com <mmcguire@parchment.com>*
direct

*916.367.6868*

*ext. 1633 | mobile 916.549.9809*

*3000 Lava Ridge Court, Suite 210 Roseville, CA 95661*

*Parchment *| Turn Credentials into Opportunities
www.parchment.com

Le vendredi 13 mars 2015 14:59:28 Sreerama Manoj a écrit :

Hi,
As we know that "pg_stat_statements" will monitor the queries after
normalizing the queries(Removes the values present in query). I want to
know is there a way to store those normalized values because I want to
check the type of data(values) ,range of data that is being hit to the
database. I am using Postgres 9.4

Hello.

You may be interested in the pg_qualstats extension:
https://github.com/dalibo/pg_qualstats

The purpose of the extension is to track values like pg_stat_statements, but
at the predicate level rather than statement level. It stores normalized
predicates as well as constants.

The documentation is here:

http://powa.readthedocs.org/en/latest/stats_extensions/pg_qualstats.html#pg-qualstats

It won't give you all normalized values though, only those present in
predicates.

--
Ronan Dunklau
http://dalibo.com - http://dalibo.org

On 03/13/2015 02:29 AM, Sreerama Manoj wrote:

As we know that "pg_stat_statements" will monitor the queries
after normalizing the queries(Removes the values present in query). I
want to know is there a way to store those normalized values because I
want to check the type of data(values) ,range of data that is being hit
to the database. I am using Postgres 9.4

BTW, this really isn't appropriate for the pgsql-hackers list; please
ask your next question like this on pgsql-general or pgsql-performance.

However, pg_qualstats is what you want:
http://powa.readthedocs.org/en/latest/stats_extensions/pg_qualstats.html

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers