Re: QRY seems not using indexes

От: Qingqing Zhou
Тема: Re: QRY seems not using indexes
Дата: ,
Msg-id: dd9bm4$238b$1@news.hub.org
(см: обсуждение, исходный текст)
Ответы: Re: QRY seems not using indexes  (Mark Kirkwood)
Список: pgsql-performance

<> writes
>
>
> so, if I do a qry like "EXPLAIN ANALYZE select * from pridecdr where
> idsede=8977758488" it tooks a lot of time before i get back any result:
>
> Index Scan using prd_id_sede on pridecdr  (cost=0.00..699079.90
> rows=181850 width=138) (actual time=51.241..483068.255 rows=150511
> loops=1)
>    Index Cond: (idsede = 8977758488::bigint)
>  Total runtime: 483355.325 ms
>

The query plan looks ok. Try to do EXPLAIN ANALYZE twice and see if there is
any difference. This could reduce the IO time to read your index/data since
you got enough RAM.

Also, if you haven't done VACUUM FULL for a long time, do so and compare the
difference.

Regards,
Qingqing




В списке pgsql-performance по дате сообщения:

От: Michael Fuhr
Дата:
Сообщение: Re: Why hash join instead of nested loop?
От: Ian Westmacott
Дата:
Сообщение: Re: Why hash join instead of nested loop?