nbeweb=> EXPLAIN ANALYZE select count(*) from onp_web_index; Total runtime: 179748.993 ms
WOW. It's possible your table is bloated. What version of PG are you using ?
VACUUM FULL ANALYZE VERBOSE onp_web_index
if it solves your problem, good, else post the results from that command.
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster