Brian Hurt <bhurt@janestcapital.com> writes:
> I'm experiencing a problem with our postgres database. Queries that
> normally take seconds suddenly start taking hours, if they complete at
> all.
Are they waiting? Consuming CPU? Consuming I/O? top and vmstat will
help you find out.
regards, tom lane