query_profiler_* session settings

These settings are available in system.settings and are autogenerated from source.

query_profiler_cpu_time_period_ns

Sets the period for a CPU clock timer of the query profiler. This timer counts only CPU time.

Possible values:

• A positive integer number of nanoseconds.

  Recommended values:

  • 10000000 (100 times a second) nanoseconds and more for single queries.
  • 1000000000 (once a second) for cluster-wide profiling.

• 0 for turning off the timer.

See also:

• System table trace_log

query_profiler_real_time_period_ns

Sets the period for a real clock timer of the query profiler. Real clock timer counts wall-clock time.

Possible values:

• Positive integer number, in nanoseconds.

  Recommended values:

  • 10000000 (100 times a second) nanoseconds and less for single queries.
  • 1000000000 (once a second) for cluster-wide profiling.

• 0 for turning off the timer.

See also:

• System table trace_log

Cloud default value: 3000000000.