Query record form fields

  • Rversion finale: Australia
  • Mis à jour 12 mars 2026
  • 1 minute de lecture

    • A description of the fields in the query record form.

    Tableau 1. Query record fields
    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.