Re: long lasting select, no io nor cpu usage ?

Список
Период
Сортировка
От Tom Lane
Тема Re: long lasting select, no io nor cpu usage ?
Дата
Msg-id 2042.1395323785@sss.pgh.pa.us
обсуждение исходный текст
Ответ на long lasting select, no io nor cpu usage ?  (Franck Routier)
Ответы Re: long lasting select, no io nor cpu usage ?  (Franck Routier)
Список pgsql-performance
Дерево обсуждения
long lasting select, no io nor cpu usage ?  (Franck Routier, )
 Re: long lasting select, no io nor cpu usage ?  (Tom Lane, )
  Re: long lasting select, no io nor cpu usage ?  (Franck Routier, )
   Re: long lasting select, no io nor cpu usage ?  (Tom Lane, )
    Re: long lasting select, no io nor cpu usage ?  (Franck Routier, )
Franck Routier <> writes:
> I am doing a select, that did not finish after some 15 hours... Select
> is as follows:

> select * from sanact where sanact___rfovsnide = 'MYVERSION' order by
> sanactcsu;

> There is an index on sanact___rfovsnide and doing EXPLAIN shows it is used.
> Resulting dataset should be 1626000 rows.

> iostat shows 99.5% idle disks, almost no activity.
> top shows almost no cpu usage.

> Where should I be looking for a problem ?

pg_locks, probably.

            regards, tom lane


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

Предыдущее
От: Torsten Förtsch
Дата:
Сообщение: Re: Performance of UNION vs IN
Следующее
От: Stefan Amshey
Дата:
Сообщение: slow join not using index properly