QueryOperationPerformanceLogCoreV2

The QueryOperationPerformanceLogCoreV2 table contains performance details on Deephaven query operations. Each query is broken up into its component parts for this log, allowing in-depth understanding of the performance impacts of each individual operation for a query.

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.
EvaluationNumberlongAn increasing integral value for requests made to the worker.
ParentEvaluationNumberlongWhen a query is part of a batch, the evaluation number of the enclosing parent.
OperationNumberintAn identifier for an operation within an evaluation.
ParentOperationNumberintWhen a query is part of a batch, the enclosing operation within the parent.
DepthintThe level of operation within a nested operation, zero when there is no parent.
SessionIdStringA unique identifier for the user-session performing the operation.
DescriptionStringA textual description of the operation, generally including the name and some of the arguments.
CallerLineStringThe file and line number where the operation was initiated, if available.
IsTopLevelBooleanIs this the top-level operation or a sub-operation? For example, a compilation is a sub-operation of other operations and measured separately.
IsCompilationBooleanDoes this represent a formula compilation operation?
StartTimeInstantThe time this operation began.
EndTimeInstantThe time this operation finished.
UsageNanoslongHow long, in nanoseconds, this operation took.
CpuNanoslongHow long, in nanoseconds, this operation used the CPU.
UserCpuNanoslongHow long, in nanoseconds, this operation used the CPU in user-space. System time can be derived by subtracting UserCpuNanos from CpuNanos.
FreeMemorylongThe free memory at the end of this operation.
TotalMemorylongThe total size of the JVM heap memory at the end of this operation.
FreeMemoryChangelongThe change in free memory during this operation.
TotalMemoryChangelongThe change in total JVM heap memory during this operation.
CollectionslongThe number of garbage collections while executing this operation.
CollectionTimeNanoslongThe number of nano seconds spent in the garbage collector while executing this operation.
AllocatedByteslongThe number of bytes allocated by this operation.
PoolAllocatedByteslongThe number of bytes allocated from pools by this operation.
InputSizeLonglongThe number of rows in the input for this operation.
WasInterruptedBooleanWas this operation interrupted?