Scott Rankin <srankin@motus.com> writes:
> Any other ideas?
If there's no lock waits, and the tables are static, it's difficult to
arrive at any other conclusion but that the process is simply losing the
CPU for long intervals. What else is going on on this box? Have you
made any attempt to correlate the slow queries with spikes in load
average, swap activity, etc?
regards, tom lane