QUERY_THRESHOLD

Description

When a query takes longer than the specified threshold, a warning will be generated in the trace log. This helps identify performance bottlenecks and problematic queries.

Type

Float

Unit

Seconds

Default

0.0

Implementation Features

  • High-precision query timing

  • Minimal overhead when disabled

  • Supports fractional seconds

  • Integrates with trace system

Warning Information

  • Query text and parameters

  • Execution time

  • Resource statistics

  • Lock information

  • Query plan (if available)

  • Context information

Use Cases

  • Performance monitoring

  • Query optimization

  • SLA compliance

  • Resource planning

  • Bottleneck identification