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
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
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