Re: performance statistics monitoring without spamming logs

2018-11-22 Thread Adrien NAYRAT
On 11/22/18 6:41 AM, Justin Pryzby wrote: and then probably look at the ratio of user CPU/clock time. Maybe pg_stat_kcache could help you : https://github.com/powa-team/pg_stat_kcache https://rjuju.github.io/postgresql/2018/07/17/pg_stat_kcache-2-1-is-out.html

Re: performance statistics monitoring without spamming logs

2018-11-21 Thread Justin Pryzby
Hi, I'm replying to an old thread from -performance: https://www.postgresql.org/message-id/flat/7ffb9dbe-c76f-8ca3-12ee-7914ede872e6%40stormcloud9.net I was looking at: https://commitfest.postgresql.org/20/1691/ "New GUC to sample log queries" On Tue, Jul 10, 2018 at 01:54:12PM -0400, Patrick He