Search Postgresql Archives

Re: Suggestion about logging only every n-th statement

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, 20 Jun 2018 at 12:51, Janning Vygen <vygen@xxxxxxxxxxx> 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux