On Tue, Jun 28, 2016 at 8:24 PM, <devel.brain99@xoxy.net> wrote:
> The problem:
> Most queries execute fast, however sometimes queries on the job
> table (which contains the job queue) take exactly 122 seconds
> (+ 0-50ms) to execute for no clear reason.
> Have I missed something obvious?
Please monitor for the start of such an event and capture the full
contents of pg_stat_activity and pg_locks during that 2 minute
window.
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company