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