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:
For example, this stack trace indicates a function call from line 119 of a script include.
For more information, see stack traces. |
|
Example URL |
The URL for an individual query, depending on how the query was called.
|
|
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. |
--- title: Query record form fields description: A description of the fields in the query record form. locale: en-US canonical_url: https://www.servicenow.com/docs/r/australia/platform-administration/platform-performance/query-record-fields.html release: australia product: Platform Performance classification: platform-performance topic_type: reference last_updated: "2026-09-10" reading_time_minutes: 1 breadcrumb: [Reference, Platform performance, Maintain and monitor, Administer the ServiceNow AI Platform] --- # Query record form fields A description of the fields in the query record form. <table id="table_rch_vcz_yz"><thead><tr><th> Field </th><th> Description </th></tr></thead><tbody><tr><td> Example </td><td> An SQL statement for an individual query, before being canonicalized to aggregate it with similar queries. </td></tr><tr><td> Hash </td><td> The hash value for this record. </td></tr><tr><td> Example stack trace </td><td> 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](http://marxsoftware.blogspot.com/2010/10/reading-java-stack-traces-few-tips.html). </td></tr><tr><td> Example URL </td><td> 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. </td></tr><tr><td> First sighting </td><td> The first occurrence of a similar query. </td></tr><tr><td> Last sighting </td><td> The last occurrence of a similar query. </td></tr><tr><td> Total execution time </td><td> Total execution time. </td></tr><tr><td> Execution Count </td><td> The number of similar query occurrences that are aggregated. </td></tr><tr><td> Average execution time \(ms\) </td><td> The average duration to execute one of these similar queries. </td></tr></tbody> </table>**Parent Topic:**[Platform performance reference](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/platform-administration/platform-performance/platform-performance-references.md)
| title | Query record form fields |
| description | A description of the fields in the query record form. |
| locale | en-US |
| canonical_url | https://www.servicenow.com/docs/r/australia/platform-administration/platform-performance/query-record-fields.html |
| release | australia |
| product | Platform Performance |
| classification | platform-performance |
| topic_type | reference |
| last_updated | 2026-09-10 |
| reading_time_minutes | 1 |
| breadcrumb | ReferencePlatform performanceMaintain and monitorAdminister the ServiceNow AI Platform |