[HACKERS] Regarding pg_stat_statements

2015-03-13 Thread 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 databas

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

2015-02-26 Thread Sreerama Manoj
015 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 no

[HACKERS] How to create virtual indexes on postgres

2015-02-26 Thread 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