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
Re: Suggestion about logging only every n-th statement Re: Suggestion about logging only every n-th statement |
Список | 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 по дате отправления: