TrackerQueries
Stores logged query-execution records. This table supports diagnostic analysis and query performance tuning.
Columns
| Name | Type | ReadOnly | Description |
| Date_Modified | Datetime | True |
The date and time when this query tracking record was most recently updated. This value supports audit visibility and performance review. |
| Deleted | Bool | False |
A Boolean field that returns a value of 'true' when this query tracking record is marked as deleted. It returns a value of 'false' when the record remains active and available. |
| Id [KEY] | Int | True |
The unique identifier (Id) for this tracked query record. This value is used to reference, analyze, and correlate query performance activity. |
| Query_Hash | String | False |
The hashed representation of the query text. This value is used to identify identical query patterns without storing full query text for every instance. |
| Query_Id | String | False |
The Id that uniquely identifies the executed query instance in the tracking system. This value links execution statistics to the query body and context. |
| Run_Count | Int | True |
The total number of times this query has executed. This value helps measure frequency and performance impact over time. |
| Sec_Avg | Double | True |
The average execution time of the query in seconds. This metric assists in identifying slow-running or inefficient queries. |
| Sec_Total | Double | True |
The total cumulative execution time of the query in seconds across all tracked runs. This value highlights long-term performance cost. |
| Text | String | False |
The full text of the SQL query as recorded by the tracking system. This value is used for performance tuning, debugging, and optimization analysis. |