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 the SingleStore node	`bigint(4)`
`NODE_IP`	The IP address of the SingleStore node	`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	JSON

LMV_TRACE_EVENTS

Was this article helpful?

Was this article helpful?