Query record form fields

reference brazil Updated Sep 10, 2026 1 min read query-record-fields.md
Raw file servicenow.com

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](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/brazil/markdown/platform-administration/platform-performance/platform-performance-references.md)
Search documentation
Search document titles and file paths on the brazil branch