Re: Suggestion about logging only every n-th statement

Поиск
Список
Период
Сортировка
От Geoff Winkless
Тема Re: Suggestion about logging only every n-th statement
Дата
Msg-id CAEzk6ffqPUcdQb6SVMkE2ROEJ-SyYg+zKroDV-RGG54S4iuixw@mail.gmail.com
обсуждение исходный текст
Ответ на Suggestion about logging only every n-th statement  (Janning Vygen <vygen@kicktipp.de>)
Список pgsql-general
On Wed, 20 Jun 2018 at 12:51, Janning Vygen <vygen@kicktipp.de> wrote:
But for analyzing usage patterns it would be very nice to have this
combined with a sample_rate for logging.

   logging_sample_rate = n

So each n-th statement will get logged regardless of execution time.

I think you would need to introduce a randomizing element ​if you wanted to make it statistically valid. Logging every n'th statement could (depending on your usage pattern) be catastrophically inaccurate.

Geoff

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

Предыдущее
От: Łukasz Jarych
Дата:
Сообщение: Using DSN Connection and knowing windows username
Следующее
От: Adrien NAYRAT
Дата:
Сообщение: Re: Suggestion about logging only every n-th statement