> We run this query all day long. What are things that might cause it to
> take 1000 times longer than normal? It was not during our nightly
> backup or any other intensive scheduled task that I'm aware of.
> Autovacuum? Something else?
Lock-block is the obvious. That is, some other session had some of
those rows locked for writing, and was open for 1.6 minutes before
committing.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com