Re: Regarding pg_stat_statements

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Sreerama Manoj <manoj(dot)sreerama973(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Regarding pg_stat_statements
Date: 2015-03-13 23:29:40
Message-ID: 550372E4.7020102@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jason Dusek 2015-03-14 09:09:45 Re: regclass and format('%I')
Previous Message Steven Lembark 2015-03-13 20:03:38 Re: Basic Question on Point In Time Recovery

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Vondra 2015-03-13 23:39:30 xloginsert.c hole_length warning on gcc 4.8.3
Previous Message Tatsuo Ishii 2015-03-13 23:27:51 Re: Strange debug message of walreciver?