-----Original Message----- From: pgsql-performance-owner@xxxxxxxxxxxxxx [mailto:pgsql-performance-owner@xxxxxxxxxxxxxx] On Behalf Of devel.brain99@xxxxxxxx Sent: Tuesday, June 28, 2016 9:24 PM To: pgsql-performance@xxxxxxxxxxxxxx Subject: 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 (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
