Re: Suggestion about logging only every n-th statement

On 06/20/2018 01:51 PM, Janning Vygen wrote:
> 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(dot)56662(dot)vygen%40kicktipp(dot)de#200903161426(dot)56662(dot)vygen(at)kicktipp(dot)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
>
>

Hello Janning,

FYI in made this patch which seems do what you want :
https://www.postgresql.org/message-id/flat/c30ee535-ee1e-db9f-fa97-146b9f62caed%40anayrat(dot)info#c30ee535-ee1e-db9f-fa97-146b9f62caed(at)anayrat(dot)info

I will add an entry in september's commit fest.

Regards,