[HACKERS] Regarding pg_stat_statements

[Sreerama Manoj]

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

Re: [HACKERS] How to create virtual indexes on postgres

[Sreerama Manoj]

But, it runs with  Postgres 9.1 version...But I use 9.4..I think I cant use
that. Or as an alternative Is there any provision in postgres to know
use(Increase in Performance) of an index before creating that index.

On Thu, Feb 26, 2015 at 5:37 PM, Michael Paquier 
wrote:

> On Thu, Feb 26, 2015 at 6:20 PM, Sreerama Manoj
>  wrote:
> > So my question was can we know whether the planner  will use the index
> > before actually creating a real Index..or can we create "virtual" or
> > "Hypothetical" Index those can only be known to the planner and not the
> user
> > or Is there any alternative to do it..If present,share with me.
>
> No, the index needs to be created to allow the planner to use it. This
> reminds me of this project though, that if I recall correctly has
> patches Postgres to allow the use of hypothetical indexes:
> https://sourceforge.net/projects/hypotheticalind/
> --
> Michael
>

[HACKERS] How to create virtual indexes on postgres

[Sreerama Manoj]

Hi,
 I use Postgres 9.4 database.Now,I am optimizing the queries by using
the results of "explain" and "explain analyze",Sometimes I am creating
Indexes to optimize them. But, I was not successful sometimes as even I
create Index to optimize them, the planner is not using them .

So my question was can we know whether the planner  will use the index
before actually creating a real Index..or can we create "virtual" or
"Hypothetical" Index those can only be known to the planner and not the
user or Is there any alternative to do it..If present,share with me.