QueryOperationPerformanceLogIndex
The QueryOperationPerformanceLogIndex compiles information about workers and users interacting with the table.
Since the QueryOperationPerformanceLog is a high-volume internal tables, it has an associated index table that you can use to optimize administrative queries commonly performed against those tables: the QueryOperationPerformanceLogIndex. 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.
Columns
| Name | DataType | Description |
|---|---|---|
| Date | String | The date of the event. |
| InternalPartition | String | The column used to partition the table. |
| ProcessInfoId | String | The unique identifier for the worker, used for correlating log entries and tables. |
| WorkerName | String | The worker's name (e.g., worker_6baf6fae). |
| 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. |
Related documentation
- Internal tables overview
AuditEventLogPersistentQueryConfigurationLogPersistentQueryStateLogProcessEventLogIndexProcessEventLogProcessInfoProcessMetricsQueryOperationPerformanceLogQueryPerformanceLogQueryUserAssignmentLogResourceUtilizationServerStateLogIndexServerStateLogUpdatePerformanceLogIndexUpdatePerformanceLogWorkspaceDataSnapshotWorkspaceData