{"revision":"c10276e953456835cdbb1f3a60d58ae1980be353","document":{"id":39150,"path":"platform-administration/platform-performance/query-record-fields.md","title":"Query record form fields","bundle":null,"doc_type":null,"release":"australia","body":"\n# Query record form fields\n\nA description of the fields in the query record form.\n\n<table id=\"table_rch_vcz_yz\"><thead><tr><th>\n\nField\n\n</th><th>\n\nDescription\n\n</th></tr></thead><tbody><tr><td>\n\nExample\n\n</td><td>\n\nAn SQL statement for an individual query, before being canonicalized to aggregate it with similar queries.\n\n</td></tr><tr><td>\n\nHash\n\n</td><td>\n\nThe hash value for this record.\n\n</td></tr><tr><td>\n\nExample stack trace\n\n</td><td>\n\nA stack trace for an individual query. Lines referencing script code \\(includes both custom and base system code\\) appear in the following format:\n\n `table name.sys_id:line number`\n\n For example, this stack trace indicates a function call from line 119 of a script include.\n\n `sys_script_include.105f70abc0a8010300d4d79ed1b93eb0:119`\n\n For more information, see [stack traces](http://marxsoftware.blogspot.com/2010/10/reading-java-stack-traces-few-tips.html).\n\n</td></tr><tr><td>\n\nExample URL\n\n</td><td>\n\nThe URL for an individual query, depending on how the query was called.\n\n -   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`\n-   Scheduled jobs: lists the name of the scheduled job.\n-   Any other method: lists an empty field.\n\n</td></tr><tr><td>\n\nFirst sighting\n\n</td><td>\n\nThe first occurrence of a similar query.\n\n</td></tr><tr><td>\n\nLast sighting\n\n</td><td>\n\nThe last occurrence of a similar query.\n\n</td></tr><tr><td>\n\nTotal execution time\n\n</td><td>\n\nTotal execution time.\n\n</td></tr><tr><td>\n\nExecution Count\n\n</td><td>\n\nThe number of similar query occurrences that are aggregated.\n\n</td></tr><tr><td>\n\nAverage execution time \\(ms\\)\n\n</td><td>\n\nThe average duration to execute one of these similar queries.\n\n</td></tr></tbody>\n</table>**Parent Topic:**[Platform performance reference](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/platform-administration/platform-performance/platform-performance-references.md)\n\n"}}