Re: Query plan discrepancies - Mailing list pgsql-sql

Have you run ANALYZE recently?

Please send back EXPLAIN ANALYZE for the below query. 

> EXPLAIN from DB 2 (doesn't come back):
>                                                        QUERY PLAN
>
-------------------------------------------------------------------------------------------------------------------------
>  HashAggregate  (cost=7763.55..7763.56 rows=1 width=8)
>    ->  Nested Loop  (cost=4363.86..7763.55 rows=1 width=8)
>          ->  HashAggregate  (cost=4363.86..4363.86 rows=200 width=146)
>                ->  Seq Scan on word_stats_base  (cost=0.00..4126.09
> rows=95109 width=146)
>          ->  Index Scan using medline_abstract_tokens_norm on
> medline_abstract_tokens  (cost=0.00..16.99 rows=1 width=8)
>                Index Cond: ((medline_abstract_tokens.norm)::text =
> ("outer".norm_token)::text)
>                Filter: (pmid = 7968456)
> (7 rows)