Re: Random slow queries

From: Kevin Grittner <kgrittn(at)gmail(dot)com>
To: devel(dot)brain99(at)xoxy(dot)net
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Random slow queries
Date: 2016-06-29 12:45:49
Message-ID: CACjxUsMncEHCHsPoAJP+XuOVKJrP2ftF4TRZEuCyiM6Gb4OZ_w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, Jun 28, 2016 at 8:24 PM, <devel(dot)brain99(at)xoxy(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Igor Neyman 2016-06-29 14:32:30 Re: Random slow queries
Previous Message Niels Kristian Schjødt 2016-06-29 10:00:00 pg_xlog dir not getting swept