Franck Routier <franck.routier@xxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
