UpdatePerformanceLogCoreV2

The UpdatePerformanceLogCoreV2 contains aggregated performance details on incremental update operations performed in UpdateGraphs.

Columns

NameDataTypeDescription
DateStringThe date of the event.
ServerHostStringThe host that the worker is executing on.
PrimaryAuthenticatedUserStringThe authenticated user that owns the worker.
PrimaryEffectiveUserStringThe effective user that owns the worker.
OperationAuthenticatedUserStringThe authenticated user that initiated the query operation.
OperationEffectiveUserStringThe effective user that initiated the query operation.
WorkerNameStringThe worker's name (e.g., worker_6baf6fae).
ProcessInfoIdStringThe unique identifier for the worker, used for correlating log entries and tables.
UpdateGraphStringThe name of the update graph for this entry.
EntryIdlongA numeric identifier for this performance entry, which can be used to identify the same operation across cycles.
EvaluationNumberlongThe evaluation number of the corresponding entry in the QueryOperationPerformanceLogCoreV2.
OperationNumberintThe operation number of the corresponding entry in the QueryOperationPerformanceLogCoreV2.
EntryDescriptionStringA textual description of the operation, generally including the name and some of the arguments.
EntryCallerLineStringThe file and line number where the operation was initiated, if available.
IntervalStartTimeInstantThe beginning of the interval this row represents.
IntervalEndTimeInstantThe end of the interval this row represents.
UsageNanoslongHow long, in nanoseconds, this operation took in this interval.
CpuNanoslongHow long, in nanoseconds, this operation used the CPU in this interval.
UserCpuNanoslongHow long, in nanoseconds, this operation used the CPU in user-space in this interval. System time can be derived by subtracting UserCpuNanos from CpuNanos.
RowsAddedlongHow many rows were added in this interval.
RowsRemovedlongHow many rows were removed in this interval.
RowsModifiedlongHow many rows were modified in this interval.
RowsShiftedlongHow many rows were shifted in this interval (this may not be an exact count).
InvocationCountlongHow many times this entry was executed in this interval.
MinFreeMemorylongThe minimum memory at the end of an operation.
MaxTotalMemorylongThe maximum total memory at the end of an operation.
CollectionslongThe number of garbage collections while executing this operation in this interval.
CollectionTimeNanoslongThe number of nano seconds spent in the garbage collector while executing this operation in this interval.
AllocatedByteslongThe number of bytes allocated by this operation in this interval.
PoolAllocatedByteslongThe number of bytes allocated from pools by this operation in this interval.