ProcessMetricsLogCoreV2

The ProcessMetricsLogCoreV2 table captures internal metrics that were previously written to the stats.log CSV. The table is disabled by default.

To enable the ProcessMetricsLogCoreV2 table for all processes, set the following property to true:

IrisLogDefaults.writeDatabaseProcessMetrics=true

Caution

Enabling this for all processes will generate a large amount of data, which can impact performance. It is recommended that this be enabled only for debugging purposes or for specific processes where detailed metrics are required.

To enable this for a single Persistent Query or Code Studio:

  1. Click the Show Advanced dropdown (for a Persistent Query, it is in the Settings tab).
  2. Add -DIrisLogDefaults.writeDatabaseProcessMetrics=true to the Extra JVM Arguments field.

Columns

Column NameColumn TypeDescription
DateStringThe date on which the information was generated. This is the partitioning column.
AuthenticatedUserStringThe authenticated user that owns the worker.
EffectiveUserStringThe effective user that owns the worker.
ProcessInfoIdStringThe ProcessInfoID of the process that generated this event.
TimestampDateTimeThe timestamp for this event.
NameStringThe name of the metric.
IntervalStringThe timing interval for the metric.
TypeStringThe type of the metric.
NlongData specific to the metric type.
SumlongData specific to the metric type.
LastlongData specific to the metric type.
MinlongData specific to the metric type.
MaxlongData specific to the metric type.
AvglongData specific to the metric type.
Sum2longData specific to the metric type.
StdevlongData specific to the metric type.

If the use of this table is required, Deephaven support will provide further details.