log_min_duration_sample

doc html

<p>
         Allows sampling the duration of completed statements that ran for
         at least the specified amount of time.  This produces the same
         kind of log entries as
         <a class="xref" href="/docs/18/runtime-config-logging.html#GUC-LOG-MIN-DURATION-STATEMENT">log_min_duration_statement</a>, but only for a
         subset of the executed statements, with sample rate controlled by
         <a class="xref" href="/docs/18/runtime-config-logging.html#GUC-LOG-STATEMENT-SAMPLE-RATE">log_statement_sample_rate</a>.
         For example, if you set it to <code class="literal">100ms</code> then all
         SQL statements that run 100ms or longer will be considered for
         sampling.  Enabling this parameter can be helpful when the
         traffic is too high to log all queries.
         If this value is specified without units, it is taken as milliseconds.
         Setting this to zero samples all statement durations.
         <code class="literal">-1</code> (the default) disables sampling statement
         durations.
         Only superusers and users with the appropriate <code class="literal">SET</code>
         privilege can change this setting.
        </p><p>
         This setting has lower priority
         than <code class="varname">log_min_duration_statement</code>, meaning that
         statements with durations
         exceeding <code class="varname">log_min_duration_statement</code> are not
         subject to sampling and are always logged.
        </p><p>
         Other notes for <code class="varname">log_min_duration_statement</code>
         apply also to this setting.
        </p>

documentation revision

{"inputs":[{"file":"runtime-config-logging.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"278d913b9c0f735c5cd7b35fd7205826bbd9c449805370d2dbe54105c0ed1d88","version":"18.7"},{"file":"runtime-config-logging.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"68c010254e1859ec0b76f06a563babd51a6c38997f1242e35e4c6b649724b1cb","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}