Skip site navigation (1) Skip section navigation (2)

Re: Query plan discrepancies

From: Rod Taylor <pg(at)rbt(dot)ca>
To: Bob Arens <martian(dot)bob(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Query plan discrepancies
Date: 2004-07-17 02:28:18
Message-ID: 1090031298.81714.8.camel@jester (view raw or flat)
Thread:
Lists: 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)



In response to

pgsql-sql by date

Next:From: Gaetano MendolaDate: 2004-07-17 09:49:08
Subject: Re: FOR-IN-EXECUTE, why fail?
Previous:From: Peter EisentrautDate: 2004-07-16 20:48:43
Subject: Re: BYTEA output presentation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group