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