> (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.