ProcessEventLogIndex
Since the ProcessEventLog is a high-volume internal table, it has an associated index table that you can use to optimize administrative queries commonly performed against those tables: the ProcessEventLogIndex. The Data Import Server produces this Index table as it imports data, making it possible to identify the set of internal partitions that have data for a given key.
Using the index table can significantly reduce the time it takes to query the ProcessEventLog table, especially when you are looking for specific processes. See Indexing Intraday Partitions for more details.
Columns
| Column Name | Column Type | Description |
|---|---|---|
| Date | String | The date of the event. |
| InternalPartition | String | The column used to partition data. |
| Process | String | The name of the process that generated the event (e.g., RemoteQueryDispatcher, worker_1). |
| ProcessInfoId | String | The unique identifier for the worker, used for correlating log entries and tables. |
| AuthenticatedUser | String | The authenticated user that owns the worker. |
| EffectiveUser | String | The effective user that owns the worker. |
Related documentation
- Internal tables overview
AuditEventLogPersistentQueryConfigurationLogPersistentQueryStateLogProcessEventLogProcessInfoProcessMetricsQueryOperationPerformanceLogIndexQueryOperationPerformanceLogQueryPerformanceLogQueryUserAssignmentLogResourceUtilizationServerStateLogIndexServerStateLogUpdatePerformanceLogIndexUpdatePerformanceLogWorkspaceDataSnapshotWorkspaceData