Re: [GENERAL] Performance degradation when using auto_explain

On 01/04/2017 08:54 PM, Kisung Kim wrote: On Wed, Jan 4, 2017 at 1:21 AM, Andreas Kretschmer > wrote: Kisung Kim > wrote: > And finally I found that auto_explain is the cause of

Re: [GENERAL] Performance degradation when using auto_explain

Kisung Kim wrote: > And finally I found that auto_explain is the cause of the problem. real hardware or virtual hardware? On virtual there are sometimes problems with exact timings, please read: https://www.postgresql.org/docs/current/static/pgtesttiming.html Regards,

[GENERAL] Performance degradation when using auto_explain

Hi, I found performance degradation when using auto_explain with log_analyze option true. It automatically logs query plan analyze results. But when there are many concurrent sessions, the performance degrades in proportion to the number of concurrent sessions. These queries are all read-only