Franck Routier <franck(dot)routier(at)axege(dot)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