Re: Allow auto_explain to log to NOTICE

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Allow auto_explain to log to NOTICE
Дата
Msg-id 20180427021638.bpk3e6gbqtredk2b@alap3.anarazel.de
обсуждение исходный текст
Ответ на Allow auto_explain to log to NOTICE  (Tom Dunstan <pgsql@tomd.cc>)
Список pgsql-hackers
Hi,

On 2018-04-27 11:43:58 +0930, Tom Dunstan wrote:
> This patch allows a user to configure auto_explain to log to NOTICE instead
> of the server log. This allows automated testing of application-generated
> queries to ensure correct plans etc from code that can inspect returned
> notices but not the server log.

> I don't see any tests for auto_explain so haven't added any test cases.
> Happy to do so if that's deemed necessary.

I'd be in favor of adding them.


> +static int    auto_explain_log_destination = LOG;

I very much dislike this name - it's too similar too the log_destination
GUC, while being about something different. How about "log_level"?

>  
> +static const struct config_enum_entry destination_options[] = {
> +    {"log", LOG, false},
> +    {"notice", NOTICE, false},
> +    {NULL, 0, false}
> +};

I'd argue this should contain the non-error cases. It's just as
reasonable to want to add this as a debug level or such.

Greetings,

Andres Freund


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

Предыдущее
От: Tom Dunstan
Дата:
Сообщение: Allow auto_explain to log to NOTICE
Следующее
От: Tom Dunstan
Дата:
Сообщение: Re: Allow auto_explain to log to NOTICE