impact of auto explain on overall performance - Mailing list pgsql-performance

From Stephan Schmidt
Subject impact of auto explain on overall performance
Date
Msg-id BN7PR08MB4307BF020C74744E2638C21DE84B0@BN7PR08MB4307.namprd08.prod.outlook.com
Whole thread Raw
Responses Re: impact of auto explain on overall performance  (Justin Pryzby <pryzby@telsasoft.com>)
Re: impact of auto explain on overall performance  (Jeff Janes <jeff.janes@gmail.com>)
Re: impact of auto explain on overall performance  (Jeremy Schneider <schneider@ardentperf.com>)
List pgsql-performance

Hello,

 

i’m currently working on a high Performance Database and want to make sure that whenever there are slow queries during regular operations i’ve got all Information about the query in my logs. So auto_explain come to mind, but the documentation explicitly states that it Comes at a cost. My Question is, how big is the latency added by auto_explain in percentage or ms ?

 

Best regards,

 

stephan

pgsql-performance by date:

Previous
From: Gunther
Date:
Subject: Distributing data over "spindles" even on AWS EBS, (followup to the work queue saga)
Next
From: Justin Pryzby
Date:
Subject: Re: impact of auto explain on overall performance