# 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](https://docs.singlestore.com/cloud/reference/sql-reference/security-management-commands/grant.md) 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](https://docs.singlestore.com/cloud/reference/sql-reference/security-management-commands/grant.md) is required to drop trace events.

***

Modified at: July 29, 2024

Source: [/cloud/reference/sql-reference/trace-event-commands/](https://docs.singlestore.com/cloud/reference/sql-reference/trace-event-commands/)

(An index of the documentation is available at /llms.txt)