Sequential scan where Index scan expected.

Поиск
Список
Период
Сортировка
От Bryce Nesbitt
Тема Sequential scan where Index scan expected.
Дата
Msg-id 4407EFD9.7050008@obviously.com
обсуждение исходный текст
Ответ на Re: dump with lo  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Sequential scan where Index scan expected.  ("Nikolay Samokhvalov" <samokhvalov@gmail.com>)
Список pgsql-sql
I'm getting sequential scans (and poor performance), on scans using my
primary keys.
Can anyone help figure out why?

demo=# \d xx_thing                    Table "public.xx_thing"        Column          |            Type             |
Modifiers
-------------------------+-----------------------------+-----------thing_id              | bigint
|not null
 
thing_model           | character varying(128)      |thing_color           | character varying(128)      |thing_year
       | integer                     |
 
Indexes:   "xx_thing_pkey" primary key, btree (thing_id)


demo=# analyze verbose xx_thing_event;
INFO:  analyzing "public.xx_thing_event"
INFO:  "xx_thing_event": 3374 pages, 3000 rows sampled, 197478 estimated
total rows


demo=# explain update xx_thing_event set thing_color='foo' where
thing_event_id=10000;                            QUERY PLAN
---------------------------------------------------------------------Seq Scan on xx_thing_event  (cost=0.00..5842.48
rows=1width=110)  Filter: (thing_event_id = 10000)
 
(2 rows)




В списке pgsql-sql по дате отправления:

Предыдущее
От: Michael Glaesemann
Дата:
Сообщение: Re: How to check date-interval constraints
Следующее
От: Bryce Nesbitt
Дата:
Сообщение: Sequential scan where Index scan expected (update)