Brian Hurt <bhurt@xxxxxxxxxxxxxxxxx> 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