Re: Bad plan on a huge table query

[Jeff Janes <jeff.janes@xxxxxxxxx>]

On Thu, Mar 21, 2013 at 10:53 AM, Daniel Cristian Cruz <danielcristian@xxxxxxxxx> wrote:

And now, it runs, at least:

http://explain.depesz.com/s/GDJn

No one could send a guess on it?

Without showing either the query, or the definition of the tables, you are not giving us much to go on.

I'm particularly interested in what inicio is and what idx_aula_confirmacao_2 is.  If inicio is already a date, why is being cast to date?  And if it is not already a date, how can it be used in the index scan?

        ->  Index Scan using idx_aula_confirmacao_2 on aula_confirmacao  (cost=0.01..7582.88 rows=4442 width=24) (actual time=64.017..81747.794 rows=101508 loops=1)"
                          Index Cond: (((inicio)::date >= date_trunc('YEAR'::text, now())) AND ((inicio)::date <= now()))"

 Cheers,

Jeff