-----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
