QueryPerformanceLogCoreV2

The QueryPerformanceLogCoreV2 table contains details on query-level performance for each worker. A given worker may be running multiple queries; each will have its own set of query performance log entries.

Columns

Name	DataType	Description
Date	String	The date of the event.
ServerHost	String	The host that the worker is executing on.
PrimaryAuthenticatedUser	String	The authenticated user that owns the worker.
PrimaryEffectiveUser	String	The effective user that owns the worker.
OperationAuthenticatedUser	String	The authenticated user that initiated the query operation.
OperationEffectiveUser	String	The effective user that initiated the query operation.
WorkerName	String	The worker's name (e.g., `worker_6baf6fae`).
ProcessInfoId	String	The unique identifier for the worker, used for correlating log entries and tables.
EvaluationNumber	long	An increasing integral value for requests made to the worker.
ParentEvaluationNumber	long	When a query is part of a batch, the evaluation number of the enclosing parent.
Description	String	A textual description of the operation, generally including the name and some of the arguments.
SessionId	String	A unique identifier for the user-session performing the operation.
StartTime	Instant	The time this operation began.
EndTime	Instant	The time this operation finished.
UsageNanos	long	How long, in nanoseconds, this operation took.
CpuNanos	long	How long, in nanoseconds, this operation used the CPU.
UserCpuNanos	long	How long, in nanoseconds, this operation used the CPU in user-space. System time can be derived by subtracting UserCpuNanos from CpuNanos.
FreeMemory	long	The free memory at the end of this operation.
TotalMemory	long	The total size of the JVM heap memory at the end of this operation.
FreeMemoryChange	long	The change in free memory during this operation.
TotalMemoryChange	long	The change in total JVM heap memory during this operation.
Collections	long	The number of garbage collections while executing this operation.
CollectionTimeNanos	long	The number of nano seconds spent in the garbage collector while executing this operation.
AllocatedBytes	long	The number of bytes allocated by this operation.
PoolAllocatedBytes	long	The number of bytes allocated from pools by this operation.
WasInterrupted	Boolean	Was this operation interrupted?
Exception	String	If an exception was produced by this query, the Exception information. Otherwise null.

QueryPerformanceLogCoreV2

Columns

Related documentation