Re: Random slow queries

-----Original Message-----
From: pgsql-performance-owner(at)postgresql(dot)org [mailto:pgsql-performance-owner(at)postgresql(dot)org] On Behalf Of devel(dot)brain99(at)xoxy(dot)net
Sent: Tuesday, June 28, 2016 9:24 PM
To: pgsql-performance(at)postgresql(dot)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 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