(1) is it *only* that query?
No. There seem to be one or two others exhibiting similarly bad performance.
(2) is there some reason you might have excessive disk fragmentation, like running on a VM?
No VM. The database is the only thing running on the server. Filesystem is XFS.
-- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
