why does explain tell me I'm using a seq scan?
| От | Mark Harrison |
|---|---|
| Тема | why does explain tell me I'm using a seq scan? |
| Дата | |
| Msg-id | 3FAC34CE.9020701@pixar.com обсуждение исходный текст |
| Ответы |
Re: why does explain tell me I'm using a seq scan?
Re: why does explain tell me I'm using a seq scan? |
| Список | pgsql-general |
I have indexed two columns in a table. Can somebody explain to me why
the first query below uses an Index Scan while the second uses a Seq
Scan?
Many TIA!
Mark
planb=# \d abcs
Table "public.abcs"
Column | Type | Modifiers
-----------+------------------------+-----------------------------------------------
abcid | integer | not null default nextval('abcid_seq'::text)
type | character varying(255) |
versionof | integer |
Indexes: abcs_pkey primary key btree (abcid),
abcs_versionof btree (versionof)
planb=# explain select type from abcs where abcid = 6339;
QUERY PLAN
----------------------------------------------------------------------------
Index Scan using abcs_pkey on abcs (cost=0.00..6.01 rows=1 width=145)
Index Cond: (abcid = 6339)
(2 rows)
planb=# explain select type from abcs where versionof = 6339;
QUERY PLAN
----------------------------------------------------------------
Seq Scan on abcs (cost=0.00..59182.10 rows=16137 width=145)
Filter: (versionof = 6339)
(2 rows)
В списке pgsql-general по дате отправления: