public inbox for [email protected]  

help / color / mirror / Atom feed

From: Igor Neyman <[email protected]>
To: [email protected] <[email protected]>
To: [email protected] <[email protected]>
Subject: Re: Random slow queries
Date: Wed, 29 Jun 2016 14:32:30 +0000
Message-ID: <DM2PR07MB5578DB88C4DCCEA3213FA76DA230@DM2PR07MB557.namprd07.prod.outlook.com> (raw)
In-Reply-To: <CACjsgDm+n0s=5cMwGF7nRMXS8fX6CF9t1HsOr_M2iejpxKgS1A@mail.gmail.com>
References: <CACjsgDm+n0s=5cMwGF7nRMXS8fX6CF9t1HsOr_M2iejpxKgS1A@mail.gmail.com>
List-Unsubscribe:  <mailto:[email protected]?body=unsub%20pgsql-performance>


-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of [email protected]
Sent: Tuesday, June 28, 2016 9:24 PM
To: [email protected]
Subject: [PERFORM] Random slow queries

Hi,

I have a weird slow query issue I can't seem to find the cause of, so I'm hoping someone here can shed some light on this.

........................................
........................................


Given the reasonably small dataset (a pg_dump of the full database containing about 2500 jobs is less than 1MB) I would think that the whole database fits in memory anyway, making this issue all the more puzzling. Have I missed something obvious?

Best regards,
Roel

______________________________________________________________________________________________________________________

Did you try AUTO_EXPLAIN extension (https://www.postgresql.org/docs/9.3/static/auto-explain.html) for diagnostic purposes?
With auto_explain.loganalize = true it will log automatically EXPLAIN ANALYZE output, rather than just EXPLAIN output.  Turning this parameter ON permanently could have negative impact on over-all performance, so use it judiciously.  

Regards,
Igor


-- 
Sent via pgsql-performance mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Random slow queries
  In-Reply-To: <DM2PR07MB5578DB88C4DCCEA3213FA76DA230@DM2PR07MB557.namprd07.prod.outlook.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox