Important

Helios features are now enabled during weekly update windows and are no longer directly tied to SingleStore engine releases. Refer to the release notes to view the latest features available in your Helios cluster.

Trace Event Commands

CREATE EVENT TRACE

The CREATE EVENT TRACE command creates a trace event.

Syntax

CREATE EVENT TRACE
    event_name
    [ WITH (<event_characteristic>, ...) ];

Where <event_characteristic> is an key/value pair, such as:

  • Query_text = on captures the query text

  • Duration_threshold_ms = 1000 traces all queries with runtimes over 1 second

  • Trace_all_failed_executions= on traces all queries that have failed, even when their runtimes are less than Duration_threshold_ms

Remarks

  • The event_name and event_characteristic keys are not case-sensitive.

  • Currently, Query_completion is the only usable event type.

  • The ALTER EVENT TRACE permission is required to create trace events.

  • Since event_characteristic key-value pairs are optional, each event trace has its own default values for a default configuration.

DROP EVENT TRACE

The DROP EVENT TRACE command drops a trace event.

Syntax

DROP EVENT TRACE event_name;

Remarks

  • The ALTER EVENT TRACE permission is required to drop trace events.

Last modified:

Was this article helpful?