On Tue, Jun 28, 2016 at 8:24 PM, <devel.brain99@xxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
