Query record form fields
A description of the fields in the query record form.
| Field | Description |
|---|---|
| Example | An SQL statement for an individual query, before being canonicalized to aggregate it with similar queries. |
| Hash | The hash value for this record. |
| Example stack trace | A stack trace for an individual query. Lines referencing script code \(includes both custom and base system code\) appear in the following format: `table name.sys_id:line number` For example, this stack trace indicates a function call from line 119 of a script include. `sys_script_include.105f70abc0a8010300d4d79ed1b93eb0:119` For more information, see stack traces. |
| Example URL | The URL for an individual query, depending on how the query was called. - User transactions: lists the transaction parameters. For example, if a user navigates to the incident list, the URL is `/incident_list.do` `sysparm_query=active=true` - Scheduled jobs: lists the name of the scheduled job. - Any other method: lists an empty field. |
| First sighting | The first occurrence of a similar query. |
| Last sighting | The last occurrence of a similar query. |
| Total execution time | Total execution time. |
| Execution Count | The number of similar query occurrences that are aggregated. |
| Average execution time \(ms\) | The average duration to execute one of these similar queries. |
Parent Topic:Platform performance reference