Search Postgresql Archives

Re: How to see index was rejected for seq scan?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> But for simple queries, you might get some insight if you set
> enable_seqscan to off.  Then the planner will give you an index-using
> plan if it is at all possible.  Then you can compare the costs.  If the
> planner still gives you a sequential scan, then the index was not
> applicable for other reasons.

Thanks!  This gives me enough information. I was essentially looking for something concrete to discuss for cases where someone even more novice than myself in query optimization points to issues after adding an index.

I have a tangential question that I am curious about more than it being helpful in building queries.

Is index information used to determine the input scan cost or is that determine through another mechanism or other metadata in the table?  I mean this for a simple case and not in an exhaustive general sense.  For example a table with an id and timestamp column with an index on the id and timestamp filtered by a date range. 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux