pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Achilleus Mantzios <achill@matrix.gatewaynet.com>
To: Ahti Legonkov <lego@127.0.0.1>
Cc: pgsql-sql@postgresql.org
Subject: Re: Why doesn't it use indexes?
Date: Wed, 3 Jul 2002 10:54:34 +0300 (EEST)
Message-ID: <Pine.LNX.4.44.0207031052550.9583-100000@matrix.gatewaynet.com> (raw)
In-Reply-To: <3D21CAF3.8090508@127.0.0.1>

On Tue, 2 Jul 2002, Ahti Legonkov wrote:

Check the actual time by explain analyze.
If sequential scan (your table is small e.g.) is faster
then there is no need for index use.
Also check the enable_indexscan variable.

> Hi,
> 
> I have this query:
> select * from reo inner join usr on reo.owner_id=usr.user_id
> 
> I also have created these indexes:
> CREATE INDEX "owner_id_reo_key" ON reo (owner_id);
> CREATE INDEX "user_id_user_key" ON usr (user_id);
> 
> Explain tells me this:
> Merge Join  (cost=1341.74..1481.12 rows=299697 width=461)
>    ->  Sort  (cost=775.05..775.05 rows=6629 width=328)
>          ->  Seq Scan on apartment_reo reo  (cost=0.00..354.29 rows=6629 
> width=328)
>    ->  Sort  (cost=566.69..566.69 rows=4521 width=133)
>          ->  Seq Scan on USER usr  (cost=0.00..292.21 rows=4521 width=133)
> 
> Why it does not use indexes I have created?
> 
> 

-- 
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
tel:    +30-10-8981112
fax:    +30-10-8981877
email:  achill@matrix.gatewaynet.com
        mantzios@softlab.ece.ntua.gr






view thread (3+ messages)

Message-ID: <Pine.LNX.4.44.0207031052550.9583-100000@matrix.gatewaynet.com>
Permalink:  ../Pine.LNX.4.44.0207031052550.9583-100000@matrix.gatewaynet.com/
Also on:    postgresql.org/message-id/Pine.LNX.4.44.0207031052550.9583-100000@matrix.gatewaynet.com

 · 

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: achill@matrix.gatewaynet.com, lego@127.0.0.1
  Subject: Re: Why doesn't it use indexes?
  In-Reply-To: <Pine.LNX.4.44.0207031052550.9583-100000@matrix.gatewaynet.com>

* 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