# LMV\_TRACE\_EVENTS

Although the monitoring service queries the sharded `MV_TRACE_EVENTS` view, the individual nodes' `LMV_TRACE_EVENTS` views are also available. Querying the LMVs individually is more performant than querying the sharded MV.

| 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           |

***

Modified at: December 19, 2023

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

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