pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Rod Taylor <pg@rbt.ca>
To: Bob Arens <martian.bob@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Query plan discrepancies
Date: Fri, 16 Jul 2004 22:28:18 -0400
Message-ID: <1090031298.81714.8.camel@jester> (raw)
In-Reply-To: <e6720fb8.0407130456.8140e04@posting.google.com>
References: <e6720fb8.0407130456.8140e04@posting.google.com>

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)

view thread (2+ messages)

Message-ID: <1090031298.81714.8.camel@jester>
Permalink:  ../1090031298.81714.8.camel@jester/
Also on:    postgresql.org/message-id/1090031298.81714.8.camel@jester

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: pg@rbt.ca, martian.bob@gmail.com
  Subject: Re: Query plan discrepancies
  In-Reply-To: <1090031298.81714.8.camel@jester>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox