From: Andrei Bintintan <klodoma@ar-sd.net>
To: pgsql-admin@postgresql.org
Subject: Index not used. WHY?
Date: Thu, 4 Dec 2003 16:57:51 +0200
Message-ID: <014901c3ba76$ffd65650$0b00a8c0@andy> (raw)
Hi,
I have the following table:
CREATE TABLE public.rights (
id int4 DEFAULT nextval('"rights_id_seq"'::text) NOT NULL,
id_user int4 NOT NULL,
id_modull int4 NOT NULL,
CONSTRAINT rights_pkey PRIMARY KEY (id)
)
and I created the following indexes:
CREATE INDEX right_id_modull_idx ON rights USING btree (id_modull);
CREATE INDEX right_id_user_idx ON rights USING btree (id_user);
Now the problem:
EXPLAIN SELECT * FROM rights r WHERE r.id_modull =15
returnes:
Seq Scan on rights r (cost=0.00..12.30 rows=42 width=12)
Filter: (id_modull = 15)
EXPLAIN SELECT * FROM rights r WHERE r.id_user =15
returnes:
Index Scan using right_id_user_idx on rights r (cost=0.00..8.35 rows=11 width=12)
Index Cond: (id_user = 15)
Question: Why the right_id_modull_idx is NOT USED at the 1st query and the second query the right_id_user_idx index is used.
I don't understand this.
Thanx in advance.
Andy.
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-performance@postgresql.org
Cc: klodoma@ar-sd.net, pgsql-admin@postgresql.org
Subject: Re: Index not used. WHY?
In-Reply-To: <014901c3ba76$ffd65650$0b00a8c0@andy>
* 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