On Tue, May 10, 2016 at 5:06 PM, Lucas Possamai <drum.lu...@gmail.com> wrote:
> >>> >> My crystal ball is not working, you have a PostgreSQL version? >> > > Maybe you should have a look on the subject of this email... > > >> >> in postgresql.conf are track_activities and track_counts both on? >> > > yes > > >> >> Did you ANALYZE the table after you re-added the index? >> > > Yes > >Maybe you should have a look on the subject of this email... Sorry, I was too busy looking at the content. Has the size / # rows changed recently? If the planner thinks it can load all the rows faster, it will use a seqscan regardless if you have an index. If that is the case, you can force index use by doing a SET enable_seqscan = off before executing the query. -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.