]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Allow sampling of statements depending on duration
authorTomas Vondra <tomas.vondra@postgresql.org>
Mon, 4 Nov 2019 00:57:45 +0000 (01:57 +0100)
committerTomas Vondra <tomas.vondra@postgresql.org>
Wed, 6 Nov 2019 18:11:07 +0000 (19:11 +0100)
commit6e3e6cc0e884a6091e1094dff29db430af08fb93
treeb44e1702678389fc68ec9a2da2ff5bb21c4db9a5
parent11d9ac28e5e0077d8f23761c2962a30423f44cee
Allow sampling of statements depending on duration

This allows logging a sample of statements, without incurring excessive
log traffic (which may impact performance).  This can be useful when
analyzing workloads with lots of short queries.

The sampling is configured using two new GUC parameters:

 * log_min_duration_sample - minimum required statement duration

 * log_statement_sample_rate - sample rate (0.0 - 1.0)

Only statements with duration exceeding log_min_duration_sample are
considered for sampling. To enable sampling, both those GUCs have to
be set correctly.

The existing log_min_duration_statement GUC has a higher priority, i.e.
statements with duration exceeding log_min_duration_statement will be
always logged, irrespectedly of how the sampling is configured. This
means only configurations

  log_min_duration_sample < log_min_duration_statement

do actually sample the statements, instead of logging everything.

Author: Adrien Nayrat
Reviewed-by: David Rowley, Vik Fearing, Tomas Vondra
Discussion: https://postgr.es/m/bbe0a1a8-a8f7-3be2-155a-888e661cc06c@anayrat.info
doc/src/sgml/config.sgml
src/backend/tcop/postgres.c
src/backend/utils/misc/guc.c
src/backend/utils/misc/postgresql.conf.sample
src/include/utils/guc.h