Re: Query hitting empty tables taking 48 minutes

Поиск
Список
Период
Сортировка
От Robert Creager
Тема Re: Query hitting empty tables taking 48 minutes
Дата
Msg-id 4457A071-1CE2-4936-BFD5-D93F629FF7AF@logicalchaos.org
обсуждение исходный текст
Ответ на Re: Query hitting empty tables taking 48 minutes  (Robert Creager <robert@logicalchaos.org>)
Список pgsql-general


On Jun 18, 2018, at 4:33 PM, Robert Creager <robert@logicalchaos.org> wrote:

I cannot explain the discrepancy between the runtimes of 85 seconds versus 10857 seconds.

It would be nice if the auto_explain analyze did include the other information like the psql analyze does.

Like this.  I’ll try again.

auto_explain.log_triggers (boolean)
auto_explain.log_triggers causes trigger execution statistics to be included when an execution plan is logged. This parameter has no effect unless auto_explain.log_analyze is enabled. This parameter is off by default. Only superusers can change this setting.



В списке pgsql-general по дате отправления:

Предыдущее
От: Sherrylyn Branchaw
Дата:
Сообщение: Re: What to do when dynamic shared memory control segment is corrupt
Следующее
От: Benjamin Scherrey
Дата:
Сообщение: Re: High WriteLatency RDS Postgres 9.3.20