Add log_statement_sample_rate parameter
Alvaro Herrera <alvherre@alvh.no-ip.org>
Add log_statement_sample_rate parameter This allows to set a lower log_min_duration_statement value without incurring excessive log traffic (which reduces performance). This can be useful to analyze workloads with lots of short queries. Author: Adrien Nayrat Reviewed-by: David Rowley, Vik Fearing Discussion: https://postgr.es/m/c30ee535-ee1e-db9f-fa97-146b9f62caed@anayrat.info
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/config.sgml | modified | +25 −5 |
| src/backend/tcop/postgres.c | modified | +14 −2 |
| src/backend/utils/misc/guc.c | modified | +14 −1 |
| src/backend/utils/misc/postgresql.conf.sample | modified | +8 −5 |
| src/include/utils/guc.h | modified | +1 −0 |
Documentation touched
Discussion
- New GUC to sample log queries 70 messages · 2018-05-30 → 2019-01-04