Suggestion about logging only every n-th statement

Поиск
Список
Период
Сортировка
От Janning Vygen
Тема Suggestion about logging only every n-th statement
Дата
Msg-id c9d37330-5aa6-2793-af35-f32a19fe8c58@kicktipp.de
обсуждение исходный текст
Ответы Re: Suggestion about logging only every n-th statement  (Geoff Winkless <pgsqladmin@geoff.dj>)
Re: Suggestion about logging only every n-th statement  (Adrien NAYRAT <adrien.nayrat@anayrat.info>)
Re: Suggestion about logging only every n-th statement  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Список pgsql-general
Back in 2009 I made a suggestion which is not implemented yet but would 
still be very valuable and easy to implement in my opinion (not for me 
as I am not speaking C):

https://www.postgresql.org/message-id/flat/200903161426.56662.vygen%40kicktipp.de#200903161426.56662.vygen@kicktipp.de

We still can't afford to log each and every statement as we have too 
many and we don't want to afford more disk performance/space. Therefore 
we log only statements slower than 50ms.

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.

What do you think?

regards
Janning



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

Предыдущее
От: Thomas Kellerer
Дата:
Сообщение: Plan output: actual execution time not considering loops?
Следующее
От: Łukasz Jarych
Дата:
Сообщение: Using DSN Connection and knowing windows username