Re: New GUC to sample log queries
От | Alvaro Herrera |
---|---|
Тема | Re: New GUC to sample log queries |
Дата | |
Msg-id | 20181129132707.ybvbqyeeelvp5noq@alvherre.pgsql обсуждение исходный текст |
Ответ на | Re: New GUC to sample log queries (Adrien Nayrat <adrien.nayrat@anayrat.info>) |
Ответы |
Re: New GUC to sample log queries
|
Список | pgsql-hackers |
=# select name, short_desc, extra_desc, category from pg_settings where category like 'Reporting%When%' ; ─[ RECORD 1 ]──────────────────────────────────────────────────────────────────────────────────────────────────── name │ log_min_duration_statement short_desc │ Sets the minimum execution time above which statements will be logged. extra_desc │ Zero prints all queries. -1 turns this feature off. category │ Reporting and Logging / When to Log ─[ RECORD 2 ]──────────────────────────────────────────────────────────────────────────────────────────────────── name │ log_min_error_statement short_desc │ Causes all statements generating error at or above this level to be logged. extra_desc │ Each level includes all the levels that follow it. The later the level, the fewer messages are sent. category │ Reporting and Logging / When to Log ─[ RECORD 3 ]──────────────────────────────────────────────────────────────────────────────────────────────────── name │ log_min_messages short_desc │ Sets the message levels that are logged. extra_desc │ Each level includes all the levels that follow it. The later the level, the fewer messages are sent. category │ Reporting and Logging / When to Log ─[ RECORD 4 ]──────────────────────────────────────────────────────────────────────────────────────────────────── name │ log_statement_sample_rate short_desc │ Fraction of statements to log. extra_desc │ 1.0 logs all statements. category │ Reporting and Logging / When to Log The description here seems a bit short on details to me. I would say something like "Fraction of statements over log_min_duration_statement to log"; otherwise it's not clear why this doesn't apply to log_statement. I think the extra_desc should be more verbose too. (Not really clear to me what to put in each ... suggestions welcome.) (More generally, I think we should add a lot more juice to the GUC description fields.) Attached is pgindent fixes for your next submission. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Вложения
В списке pgsql-hackers по дате отправления: