QueryPerformance¶
This table contains performance information for executed OctoSAM queries
Fields¶
| Field | Type | Description |
|---|---|---|
| DurationMillis | bigint | Duration of the Query |
| Frontend | nvarchar | OctoSAM frontend / application that started the query |
| Guid | uniqueidentifier | GUID of the query. Each query definition has a unique GUID. |
| ID | bigint | Internal ID for the QueryPerformance entity (Primary Key) |
| Parameters | nvarchar | A JSON document containing the query parameters |
| Path | nvarchar | Repository path of the query at the time of execution |
| Rows | bigint | Number of rows the query returned |
| StartDateTime | datetime2 | Date/Time the Query was started |
| User | nvarchar | User that executed the query |