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

Franck Routier <franck.routier@axege.com> 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