impact of auto explain on overall performance

Поиск
Список
Период
Сортировка
От Stephan Schmidt
Тема impact of auto explain on overall performance
Дата
Msg-id BN7PR08MB4307BF020C74744E2638C21DE84B0@BN7PR08MB4307.namprd08.prod.outlook.com
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Gunther
Дата:
Сообщение: Distributing data over "spindles" even on AWS EBS, (followup to the work queue saga)
Следующее
От: Justin Pryzby
Дата:
Сообщение: Re: impact of auto explain on overall performance