Re: Suggestion about logging only every n-th statement
От | Andreas Kretschmer |
---|---|
Тема | Re: Suggestion about logging only every n-th statement |
Дата | |
Msg-id | B40F3F57-1A83-435F-8FAB-0E989A357A64@a-kretschmer.de обсуждение исходный текст |
Ответ на | Suggestion about logging only every n-th statement (Janning Vygen <vygen@kicktipp.de>) |
Ответы |
Re: Suggestion about logging only every n-th statement
|
Список | pgsql-general |
On 20 June 2018 13:51:25 CEST, Janning Vygen <vygen@kicktipp.de> 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.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 I would suggest using of pg_stat_statements for that. Regards, Andreas -- 2ndQuadrant - The PostgreSQL Support Company
В списке pgsql-general по дате отправления: