Re: ToDo: log plans of cancelled queries

Поиск
Список
Период
Сортировка
От Dimitri Fontaine
Тема Re: ToDo: log plans of cancelled queries
Дата
Msg-id m28v7x140c.fsf@2ndQuadrant.fr
обсуждение исходный текст
Ответ на Re: ToDo: log plans of cancelled queries  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: ToDo: log plans of cancelled queries  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: ToDo: log plans of cancelled queries  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Pavel Stehule <pavel.stehule@gmail.com> writes:
> My propose is proposed for different dimensions and purpose - for
> example - we have a limit 20 minutes for almost all queries, and after
> this limit we killing queries. But we have to know little bit more
> about these bad queries - and we hope, so execution plan can give this
> additional info. We have same motivation like people who use
> auto_explain for slow query - but we can't to wait to query complete.

Set auto_explain.log_min_duration to 19 mins or maybe 17 and be done?

Regards,
-- 
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support



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

Предыдущее
От: Hannu Krosing
Дата:
Сообщение: Re: logical changeset generation v3 - comparison to Postgres-R change set format
Следующее
От: Dimitri Fontaine
Дата:
Сообщение: Re: erroneous restore into pg_catalog schema