# MV\_TRACE\_EVENTS

While the trace events can be viewed via the information schema `MV_TRACE_EVENTS` table, this buffer is not intended to be directly consumed by the end user. The [PROCESS](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/grant.md) permission is required to query `MV_TRACE_EVENTS`.

The new information schema table represents semi-structured data to support any arbitrary event that occurs on a node. It also includes a JSON column for details specific to that event type. Queries against this table can also filter events using familiar SQL DML. Note that this is where event filtering happens. The DDL language used to create and configure trace events defines how an event is traced and may, depending on the options selected, result in some events not being traced.

Note that `MV_TRACE_EVENTS` is a ring buffer where the oldest events are overwritten when the buffer wraps around. To save events, other software (such as the [Query History](https://docs.singlestore.com/db/v9.1/query-data/query-tuning/query-history.md) feature)  must gather them before they age out of `MV_TRACE_EVENTS`.

| Column Name          | Description                                                                                                                                              | Column Type    |
| -------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------- | -------------- |
| `NODE_ID`            | The ID of theSingleStorenode                                                                                                                             | `bigint(4)`    |
| `NODE_IP`            | The IP address of theSingleStorenode                                                                                                                     | `varchar(256)` |
| `NODE_TYPE`          | The type of node: master aggregator (MA), child aggregator (CA), or leaf node (LEAF)                                                                     | `varchar(8)`   |
| `NODE_START_EPOCH_S` | The time the node started                                                                                                                                | `bigint(20)`   |
| `EVENT_ID`           | The event ID                                                                                                                                             | `bigint(20)`   |
| `EVENT_TYPE`         | `Query_completion`                                                                                                                                       | `varchar(256)` |
| `TIME`               | Time when the event was traced in the buffer                                                                                                             | `datetime(6)`  |
| `DETAILS`            | Refer to[View MV\_TRACE\_EVENTS](https://docs.singlestore.com/db/v9.1/query-data/query-tuning/query-history/#section-idm4666110973244834048400727929.md) | `JSON`         |

The rows are returned approximately in ascending order of time, grouped individually by node. As there is no guarantee that an event that occurred at a specific time will be inserted into the ring buffer before an event that occurs later, events are not guaranteed to be returned in chronological order.

***

Modified at: December 19, 2023

Source: [/db/v9.1/reference/information-schema-reference/trace-events/mv-trace-events/](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/trace-events/mv-trace-events/)

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