long lasting select, no io nor cpu usage ?

From: Franck Routier <franck(dot)routier(at)axege(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: long lasting select, no io nor cpu usage ?
Date: 2014-03-20 13:51:45
Message-ID: 532AF271.4040903@axege.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,

I have a table (sanact) with 23.125.525 rows (and a hundred columns).
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 ?

Thanks in advance,

Franck

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2014-03-20 13:56:25 Re: long lasting select, no io nor cpu usage ?
Previous Message acanada 2014-03-20 10:17:20 Re: Query taking long time