Re: Random slow queries

-----Original Message-----
From: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of
devel.brain99@xoxy.net
Sent: Tuesday, June 28, 2016 9:24 PM
To: pgsql-performance@postgresql.org
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
thinkthat 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.
Turningthis parameter ON permanently could have negative impact on over-all performance, so use it judiciously.  
 

Regards,
Igor